How do I format all comments in an Excel worksheet?

[David Ashford]

I am using Excel 2007 and want to change the font and pitch of all comments
in one go rather than doing so one by one.

 

[Shane Devenshire]

Hi,

A macro is probably your best bet. However, here is a manual method, which
is probably faster than the method you are using:

1. Choose View, Comments
2. Modify one of the comments.
3. Select the border of the comment
4. Double-click the Format Painter
5. One at a time single click each of the other comments.

 

[Gord Dibben]

See Debra Dalgleish's site for a macro.

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


Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 06:08:02 -0800, David Ashford <David

 

[Sheeloo]

If you prefer a macro soution then visit Debra Dalgleish's wonderful site and
read
http://www.contextures.com/xlcomments03.html#Format