Insert Comment disappeared from Insert menu

[AChimpNamedCornelius]

You can right click on a cell and choose Insert Comment and it adds a yellow sticky note type thing.

If a cell has a comment, this right click shows Edit Comment and Delete Comment.

I had created a comment and was still editing it, then my fat fumble fingers did...something...and I suddenly found myself on a different tab. I went back to the other tab. The comment was still there (a little red triangle I could hover over) but right-clicking no longer showed Edit Comment.

Right clicking on an empty cell no longer showed Insert Comment.

Cells with comments do show Delete Comment, which works, but then I can't re-add it since it no longer shows Add Comment.

I tried quitting Excel and restarting, but it's just gone from the menu now.



I created a new spreadsheet, and Insert Comment is there properly. So somehow it is turned off just for this sheet? There is a magical keystroke that does all this:

1. Switches to another tab
2. Turns off adding of comments

???

I'm still grappling with changes to 2010's layout. Does anyone know the magical keystroke (or option) to turn back on allowing inserting of comments?


To pre-answer questions:

1. Excel 2010
2. Yes, I can edit and save the document otherwise.
3. No, other tabs in that document do not show Insert Comment, either.
4. Yes, other spreadsheets, Insert Comment appears and operates normally.

 

[BriGuy385]

Hey all, I am also still having this issues, even after doing the suggestions above (ungrouping, VBA change, trying a different tab as well as worksheet, closing and re-opening), and still nothing. I even tried to install an addon to customize the right click menu, found to work on other forums, but still nothing. I also tried adding a command into the quick Access Toolbar, but there were no options for adding, inserting, or copying comments.

My only current workaround is to copy another cell that has a comment, then paste special that comment into the cell I want a comment in, and then change that comment. Many many more steps than I would like.

Any help would be appreciated!

One other comment, I can still use the keyboard shortcut of Shift+F2 to insert a comment, but I am just so used to using the right click and selecting it from the menu. That really is muscle memory for me and I'd rather not retrain my brain!

Thanks again

 

[sazie48]

I am also not having any luck correcting the problem. You can go to the REVIEW tab in your ribbon and click on New Comment or try Shift+F2. It's a little easier than copying and pasting.

 

[Fstick546]

What I do to fix the the problem is to duplicate that very same tab/sheet that did not show the the edit comment feature when right click. When the duplicate sheet is created, the edit comment feature will reappear. This works on mine.