Changing the default format of comments

G

GraphicsGirl

Dear Reader,

I am unable to remember how I changed the format of comments I add to cells.
Some comment windows automatically open with a larger area and larger font
size, while others are opening much smaller. It is time consuming to right
click and reformat each comment I enter. I'm sure I changed the smaller
default format previously, but cannot recall how. Thanks in advance if you
can help!

GraphicsGirl
Kris
 
S

ShaneDevenshire

Hi GraphicsGirl,

Sad to say, there is no control of this without using VBA. You can achieve
some result by change the computers font sizes but I don't suggest that.

If you need to do this to a lot of comments at one time then -
1. Choose Tools, Options, View, Comments & indicators
2. Format one comment the way you want it
3. Click its border and then double-click the Format Painter tool and click
on 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

Text in note pane of "normal" display suddenly much larger 1
Default font for comments 2
formatting comments with shared workbook 2
how to change multiple cell comment properties? 1
How do I change the comment default format to include date? 4
Problem with MS Word paragraph and character styles: format getting messed up 2
Default font/Size in Comments Box 3
Opening the Comments Window 0

Top