How do I set the default comment format and view in Excel

G

Guest

I have a very large file containing several worksheets. Many of the cells
have comments which I don't want displayed all the time (only on mouse
rollover). I would like to set the default format and view for future
comments as well as discover a quick way to reformat all the existing ones
within the file.

Also, there seems to be an issue with some of the existing comments in the
file. When attempting to edit them, Excel can't seem to locate them. They
appear on mouse rollover, but the Edit Comment function does not allow you
into the comment box anymore. It doesn't happen on every cell with a
comment, only some of them.
 

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 the comment default format to include date? 4
How DO I Increase The Excel Cell Comment Data Capacity? 1
How can I set the show/hide default for comments in Excel? 1
How do I make make comment format default? 1
excel comment issue 7
How do I view complete text content in an Excel Comment box? 1
Set properties in Excel comments 3
Excel, how do I set up default comment containing picture? 10

Top