"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"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.
  1. Right click on the cell containing the comment.
  2. Select Show Comment.
  3. Right-click on the border of the comment and select Format Comment.
  4. Make formatting changes the same as with any text box in Excel.
  5. Right-click on the border of the comment and select Hide Comment.
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.

Here's what you need to do:

  1. Go to your Windows Desktop (Windows key + M).
  2. Right click on the desktop and choose Properties from the popup menu.
  3. Click the Appearance tab.
  4. From the Item dropdown list, select ToolTip.
  5. You can now choose a new background color, font face, font color, font size, bold, or italics.
  6. Click OK to accept the changes.
Note that these changes will apply to across all Windows' ToolTips as well as Excel's comments.

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)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.