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

"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Ashford" wrote:

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.