Comments in Excel

[amandaj.north]

When you create a comment the font and size defaults
to "Tahoma", "8". Is there a way of changing the default
font and size for comments so that when you create
comments after changing the default they will all be the
font and size that you set as the default.
eg. "Arial", "10".

 

[Debra Dalgleish]

You can change the default font size:

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

or use a macro to insert a comment with specific formatting:

http://www.contextures.com/xlcomments03.html#Formatted