hidden comments

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

Guest

How can I make all comments editable without first having to click on "show"? Some comments on my worksheet seem to be hidden while others are not. Thanks.
 
To show all comments in all open workbooks, choose View>Comments.
 
Thanks but I didn't want to view ALL the comments. I just want to be able to edit a comment in a particular cell without have to first show the comment. Usually if I'm on a cell that contains a comment the comment will show then if I right click I can "edit". However some & only some of my comments do not show up unless I first right click than click "show" then I'm able to edit.

----- Debra Dalgleish wrote: -----

To show all comments in all open workbooks, choose View>Comments.
 
I'm not sure if this fits, but when you say you're in the cell, does that mean
the cell is selected?

Comments show up when you hover the mouse over the cell--not when you select the
cell.

Are the comments not showing up when you hover the cursor over the cell?
 
If the cell contains a comment, you should be able to right-click on the
cell, and choose Edit Comment, even if the comment is not visible.
 
Some of the comments were NOT showing up when hovering. Think I may have it fixed now...some cells had "locked" under protection. I've highlighted whole worksheet & set cell, protection, locked as unchecked.
Thanks for all the help and sorry for confusion in my questions

----- Dave Peterson wrote: ----

I'm not sure if this fits, but when you say you're in the cell, does that mea
the cell is selected

Comments show up when you hover the mouse over the cell--not when you select th
cell.

Are the comments not showing up when you hover the cursor over the cell

tami wrote
 
Glad you got your problem fixed--but I'm surprised that was the answer.

I get the comment to appear on both locked cells and unlocked cells in both
protected and unprotected worksheets.

(Maybe it was a coincidence that the problem disappeared????)
 
You must log in or register to reply here.

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

Comments disappeared 2
Can't Edit Cell Comments 1
Is there a way to move a hidden comment on a worksheet? 2
Edit Comment Function 3
How can I set the show/hide default for comments in Excel? 1
Some comments stay hidden even after picking show/hide all why? 2
Edit Comment in Excel 2002 randomly doesn't respond 1
Comments partially hidden due to "frozen" columns 2

Back
Top