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

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.