Change default font and size for comments?

[Anita]

Does anyone know how to do the above?

Many thanks

Anita

 

[Norman Harker]

Hi Anita!

Right-click on the desktop > Properties
Appearance tab > Item dropdown, select Tooltip
Choose a font Size, click OK

You'll see that you can change the font and colour as well.

 

[Debra Dalgleish]

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

 

[Guest]

Hello

thanks for your reply - that does seem to change the size
of the font when you type text into the comment but it
doesn't change the font style (I'm using XP) - can you
help?

Thanks again

Anita

 

[tghcogo]

Hi Anita

If you only want to change the font in the comment box:-

Highlight the cell with the comment and right click, choose "edi
comment", then place the mouse cursor inside the comment box and righ
click again. Choose "format comment" and ....voila... you get all th
normal choices if fonts, sizes, bold, italics etc

Cheers

TGHCOG