Format Comments in Excel

  • Thread starter Thread starter Thomas W. Bradford
  • Start date Start date
T

Thomas W. Bradford

I am trying to permanently set the font for comments in
Excel. Although I have set me worksheet standard to Times
New Roman 10, everytime I pull up a comment, it is in
Tahoma 8. How do I change it so that when I add a
comment, it always comes up, Times New Roman 10?

Thanks!
 
Cell Comments
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font

Excel uses the Tahoma font for new comment boxes, and you cannot c
hange that default. You can set the default interior color, the font color, and
the fontsize in the Control Panel (Display, Appearance, Tool Tip). -

You would have to use a macro such as is included in the above link.
 
Back
Top