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 .