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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

8 sentences to help you master subject-verb agreement

When professionals prepare written material for readers inside their organization or outside, they should make sure that no errors distract from the message they need to convey. Take this short quiz for practice in subject-verb agreement.