Default settings for all comment tags in Excel

0

0-0 Wai Wai ^-^

Hi.
Does anyone know how to set the default setting for all properties about
comments tags in Excel?
Eg:
- font type
- font size
- background color
- default size of the comment
- and so on

Thanks.
 
D

Debra Dalgleish

You can change some of the default settings, but not all.

--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)
You can also set the font to Bold or italic, and select a colour for the
font and/or Tooltip.

--To insert a comment with a specific font, you can use a macro:


http://www.contextures.com/xlcomments03.html#Formatted
 
0

0-0 Wai Wai ^-^

--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)
You can also set the font to Bold or italic, and select a colour for the
font and/or Tooltip.

--To insert a comment with a specific font, you can use a macro:


http://www.contextures.com/xlcomments03.html#Formatted
Click to expand...


Thanks.
Your answer is very helpful. :p
 
Top