|
|
|
Author |
Message |
idriz
|
Posted: Thu Jul 28 20:36:38 CDT 2005 |
Top |
worksheet functions >> Font in Comment Box
Good morning there, I want to change the default font style and size in the
comment box. How can I do it? Many thanks!! =)
Excel487
|
|
|
|
|
Debra
|
Posted: Thu Jul 28 20:36:38 CDT 2005 |
Top |
worksheet functions >> Font in Comment Box
You can change the default font size, but not the default font type.
To change the default font size (Note: this will 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)
You can also set the font to Bold or italic, and select a colour
To insert a comment with a specific font, you can use a macro:
http://www.contextures.com/xlcomments03.html#Formatted
> Good morning there, I want to change the default font style and size in the
> comment box. How can I do it? Many thanks!! =)
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
|
|
|
|
|
annie
|
Posted: Thu Jul 28 23:24:02 CDT 2005 |
Top |
worksheet functions >> Font in Comment Box
Thanks Debra =)
You can change the default font size, but not the default font type.
To change the default font size (Note: this will 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)
You can also set the font to Bold or italic, and select a colour
To insert a comment with a specific font, you can use a macro:
http://www.contextures.com/xlcomments03.html#Formatted
> Good morning there, I want to change the default font style and size in
the
> comment box. How can I do it? Many thanks!! =)
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
|
|
|
|
|
|
|