Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to change the default formatting of comments in excel?
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 |
#2
|
|||
|
|||
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Zach" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
How to change default printing parameters on Excel & ...... | Excel Discussion (Misc queries) | |||
Change the default chart colours | Charts and Charting in Excel | |||
How can I globally change the formatting of all my comments in Exc | Excel Discussion (Misc queries) | |||
how do i set default font / text size in comments? | Setting up and Configuration of Excel |