If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default Font Setting in Excel Comments
How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.? |
#2
|
|||
|
|||
Default Font Setting in Excel Comments
It might help for me to say that this is in Excel 2003.
Thx in advance for help. -----Original Message----- How do I change the default setting for the font in an Excel Comment from Tahoma 8 pt.? . |
#3
|
|||
|
|||
Default Font Setting in Excel Comments
To change the default font size (this will also change the settings for
tooltips in Excel and other programs): 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 (Note: selecting a font type here will not affect the default font used in Excel's comments) To insert a comment with a specific font, you can use a macro: http://www.contextures.com/xlcomments03.html#Formatted tim wrote: How do I change the default setting for the font in an Excel Comment from Tahoma 8 pt.? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Default Font Setting in Excel Comments
Thank you for the macro. That may be the route I have to
take. But first I would like to know if there is any way to change the default setting for the font for "Insert Comment". If it's set to Tahoma 8 pt. right now shouldn't there be a way to make the default be 10 pt.? -----Original Message----- To change the default font size (this will also change the settings for tooltips in Excel and other programs): 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 (Note: selecting a font type here will not affect the default font used in Excel's comments) To insert a comment with a specific font, you can use a macro: http://www.contextures.com/xlcomments03.html#Formatted tim wrote: How do I change the default setting for the font in an Excel Comment from Tahoma 8 pt.? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
#5
|
|||
|
|||
Default Font Setting in Excel Comments
Tim
Did you try Debra's instructions for changing via PropertiesAppearanceAdvancedItemToolTip? Change to 10 pt. size here will be default size for Excel Comments. Gord Dibben Excel MVP On Tue, 6 Jul 2004 06:06:26 -0700, "tim" wrote: Thank you for the macro. That may be the route I have to take. But first I would like to know if there is any way to change the default setting for the font for "Insert Comment". If it's set to Tahoma 8 pt. right now shouldn't there be a way to make the default be 10 pt.? -----Original Message----- To change the default font size (this will also change the settings for tooltips in Excel and other programs): 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 (Note: selecting a font type here will not affect the default font used in Excel's comments) To insert a comment with a specific font, you can use a macro: http://www.contextures.com/xlcomments03.html#Formatted tim wrote: How do I change the default setting for the font in an Excel Comment from Tahoma 8 pt.? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
#6
|
|||
|
|||
Default Font Setting in Excel Comments
Ah-ha.....thank you. I was thrown off by the note that this would "not"
change the comment font. I should have tried anyway. thanks again --- Message posted from http://www.ExcelForum.com/ |
#7
|
|||
|
|||
Default Font Setting in Excel Comments
In the Desktop properties, you can select a Font and Font Size for
Tooltips. The default Font Size of a new Excel comment is affected by these settings, but the default comment Font will remain as Tahoma. tunz wrote: Ah-ha.....thank you. I was thrown off by the note that this would "not" change the comment font. I should have tried anyway. thanks again -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bar Charts created in Excel 2003 - font resizes when file is reopened | Lucie Harris | Charts and Charting | 0 | June 16th, 2004 05:56 AM |
Setting default date format/Access to Excel conversion | Diann | Worksheet Functions | 1 | February 19th, 2004 12:20 PM |
Default comment font | Frank Kabel | Worksheet Functions | 1 | February 10th, 2004 02:01 PM |
Can't change font default | Scott | Worksheet Functions | 2 | January 9th, 2004 08:28 PM |
Default settings for Comments in Excel 97 | Keith | Setting up and Configuration | 1 | December 12th, 2003 02:45 AM |