How do I format all comments in an Excel worksheet?

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change default font/pitch of text in Excel's comments? 1
How do you format a larger font for cell comments ? 1
Can't Edit Worksheet Comments 1
Excel Default Text Size in Comments box 1
How do I color code comments in cells on Excel spreadsheet? 1
CONDITIONAL FORMATTING IN EXCEL 2010 1
how to change font for all existing comments at once? 1
Word to Excel: Export comments with text and line number 0

Top