how do I set default font size in Excel comments?

G

Guest

as title - I want deafult font size to be 12 not 8. I am on XP SP1 /
Excel2003, but right click / set auto defaults does nothing; in help, about
comments shows nothing; troubleshoot comments shows nothing; other help
unhelpful.
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default font/Size in Comments Box 3
How can I increase default font size of comments in Excel? 1
Comments Defaults 1
default font size on comments 3
default font size of comment 3
how to change default font size when inserting comments 3
excel 2000 how to format the comments font all comments 1
how can i set as default my comments to always show 12 font size? 1

Top