Change The Format Of Text In Sticky Note Comments

This is the placeholder for an optional "sub" headline.
BY STANLEY ZAROWIN

Q. Is there a way to change the format of Comments, which are attached like sticky notes to an Excel cell?

A. Yes, you can easily change the font and type style in individual Comments or, with a few extra steps, change the default setting for all ToolTips, which is what a Comment is.

To change an existing Comment format, put your cursor over the cell, which will show a red triangle to indicate the Comment’s presence, and right click. Select Edit Comment in the following menu:

Now highlight the words you want to reformat and again right click. That will bring up this menu:

Click on Format Comment to bring up the menu below and proceed to format the text.

Although there is no way within Excel to change the default characteristics, you can make changes in Windows. However, any change in Windows will affect the ToolTips in all your other Microsoft applications. Here are the steps:

Minimize or close all applications and right click on any area of the desktop itself to evoke the Windows’ Context menu. Click on Properties .

That brings up the Display Properties menu.

Click on the Appearance tab, and in the Items drop-down list, select ToolTip and use the Font and Size controls to select the characteristics you want. Click on OK .

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.