Thread: How do I set the default font size in the "comment" feature?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How do I set the default font size in the "comment" feature?
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 type, you can use a macro:

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


Steve wrote:
Does anyone have an approach to changing the "Comments" feature defaults in
Excel?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote