Changing the default format of comments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

formatting comments with shared workbook 2
How do I change the comment default format to include date? 4
Default Comment Format 1
can you change the default format for a "comment" in excel? 2
how to change multiple cell comment properties? 1
How to change comment format? 3
Default format of cell comments 4
Can I change the default font for a comment box in excel globally 2

Back
Top