"How To Excel" Mini-Tutorials|
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"
Change The Format Of Excel's Comments
In order to change the format of an individual comment in Excel,
you format it the same as if it was a text box.
You can also change the default format for all comments in Excel.
However, it has to be done from outside of Excel. Be aware that to change
the default format for Excel comments,
you will also be changing the default format for all tool tips
(those little notes that popup every time you pause the cursor
over a tool button) in Windows.
- Right click on the cell containing the comment.
- Select Show Comment.
- Right-click on the border of the comment and select Format Comment.
- Make formatting changes the same as with any text box in Excel.
- Right-click on the border of the comment and select Hide Comment.
Here's what you need to do:
Note that these changes will apply to across all Windows' ToolTips as well as Excel's comments.
- Go to your Windows Desktop (Windows key + M).
- Right click on the desktop and choose Properties from the popup menu.
- Click the Appearance tab.
- From the Item dropdown list, select ToolTip.
- You can now choose a new background color, font face, font color, font size, bold, or italics.
- Click OK to accept the changes.
Thanks to Tim Owens for the tip suggestion.
Why not print (CTRL+P) this tip and share it with your friends and associates?
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.|
Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)