How do I format all comments in an Excel worksheet?

  • Thread starter Thread starter David Ashford
  • Start date Start date
D

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.
 
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.
 
Back
Top