In Excel 2000, where is the default comment font stored? I'd like all my
comments to have a Times New Roman 10 pt font. Is there somewhere I can
change the default comment font? I don't want to have to change each comment
individually. Thanks!

From: Debra Dalgleish
Newsgroups: microsoft.public.excel.misc
Date: Sun, 14 Nov 2004 11:34:33 -0500
Subject: change default font on comments

You can change the default font size, but not the default font type.

--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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Mary Fetsch" wrote:

In Excel 2000, where is the default comment font stored? I'd like all my
comments to have a Times New Roman 10 pt font. Is there somewhere I can
change the default comment font? I don't want to have to change each comment
individually. Thanks!

Thanks so much for this information. That solves my problem!

"Gary L Brown" wrote:

From: Debra Dalgleish
Newsgroups: microsoft.public.excel.misc
Date: Sun, 14 Nov 2004 11:34:33 -0500
Subject: change default font on comments

You can change the default font size, but not the default font type.

--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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Mary Fetsch" wrote:

In Excel 2000, where is the default comment font stored? I'd like all my
comments to have a Times New Roman 10 pt font. Is there somewhere I can
change the default comment font? I don't want to have to change each comment
individually. Thanks!