Comments Formating

  • Thread starter Thread starter Mohammad Sutari
  • Start date Start date
M

Mohammad Sutari

Dear All;
How can I change the default format of the comment box;
thus when i open new comment box my own format appears?
Thanks a lot
 
Unfortunately, there is no way to change the default format of Excel
comments. I guess you could write a macro to insert the comments and format
them at the same time.

Here is an article that will change the font in a cell comment.

213680 XL2000: How to Change the Font in a Cell Comment
http://support.microsoft.com/?id=213680

Hope this helps.
 
You can change the font size of new comments by changing the settings in
your Control Panel. (Instructions for Windows XP)

1. Right-click on the desktop, and choose Properties
2. On the Appearance tab, click Advanced.
3. From the Item dropdown, choose Tooltip
4. Choose a font Size, click OK, click OK

Note -- this will also affect your Tooltips formatting
 
Back
Top