Excel Comments

V

Vic Abrahamian

Hi,
Is there any way to change the default format settings for the text in
"Excel Comments". For example different type of font or Bold etc..?
Thank you
 
B

Bob Buckland ?:-\)

Hi Vic,

You didn't mention the version of Excel you're using.


In Excel 2007, for Comments inserted via either
Right Click=>Insert Comment or
Review tab=>Comments=>New Comment
you can either right click on the border of a Comment and select
'Format Comment' or use
Home tab=>Cells=>Format=>Format Comment

In earlier versions, right click on the Comment border and chose 'Edit Comment'

The default color/font comes from your Windows color/theme settings.

You can select text within a comment and apply Font, bold/color etc while typing rather thanset these for the entire comment.

===========
Hi,
Is there any way to change the default format settings for the text in
"Excel Comments". For example different type of font or Bold etc..?
Thank you >>
--

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 
V

Vic Abrahamian

Hi Bob,
Thank you for your reply, question is regarding Office 2007.
I needed to find out if there is a way to set a default font style for
comments not how to change the font style.
Is there such thing?
Thank you
 
B

Bob Buckland ?:-\)

Hi Vic,

The default color and font for Comments are from the 'Tooltip' settings in
Windows desktop appearance advanced dialog.

You can use a macro to switch them as you go or in bulk, but you may want to use the link below to also ask the folks in the MS
Office Excel discussion group if there is another way to set a style for the comment box.

===========
Hi Bob,
Thank you for your reply, question is regarding Office 2007.
I needed to find out if there is a way to set a default font style for
comments not how to change the font style.
Is there such thing?
Thank you >>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top