how to change the default formatting of comments in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could some one please help me to change the default formatting
[text,background color, border lines etc.] on a permanent basis.

I know that we could change the format of one comment in the excel
worksheet, by selecting the border of that comment and then pressing
"Cntrl+1". But that works forjust one cell comment, what if I wanna have it
changed for all future work puposes. Would appreciate your assistance ..
thanks
 
Hi Zach,
Excel uses the Tahoma font for new comment boxes, and you cannot change
that default. You can set the default interior color, the font color, and the fontsize in the
Control Panel (Display, Appearance, Tool Tip). Also see "Retain a copy of your
Original Control Display Settings" (link) for some precautions to backup what you already
have for a color display scheme. before changing them.

Additional information, macros, and links at
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL FORMATTING IN EXCEL 2010 1
How do I change default font/pitch of text in Excel's comments? 1
How do you format a larger font for cell comments ? 1
How do I change the name on comments inserted in Excel 1
How do I change the comment default format to include date? 4
Can't Edit Worksheet Comments 1
How to change text color in a cell "comment" in Office 2007? 1
How do I format all comments in an Excel worksheet? 3

Back
Top