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.

 

[JLGWhiz]

I think I had a similar experience when I had xl2003, but unfortunately I do not remember how, or even if, I ever got it fixed. I just tried two or three scenarios trying to replicate the problem with xl2007 and couldn't do it. I also checked the advanced settings for Excel apps and didn't find anything in there. I quit using the keyboard for maneuvering years ago and forgot what most of the keyboard controls do, but I know that it is easy to hit the wrong one and cause a little misery once in a while.

 

[sadyphillips]

I know this is an old thread, but maybe this will be of help to someone else. I recently encountered a similar issue in Excel 2013 -- in one spreadsheet only, the add/edit/delete a comment option was missing. After much googling and scratching my head, I realized that I had previously saved the workbook with multiple worksheets activated, disabling the comments feature. As soon as I deselected all except one sheet, the comments options reappeared.

 

[Atulthakur]

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.

Reply:
Today I encountered same problem and was trying to find solution by googling it. I found this mr. excel forum and saw the comments. I didn't know that the problem of inserting and editing comment is just in the one sheet. When I saw next sheet, I could insert and edit comment. When I came back to same sheet, here was the magic :P Now I could use edit and insert comment. I dont know what happened but just going to the next sheet and checking there, and coming back to same sheet, it worked.
May be it helps someone.
best regards
Atul

 

[Beole]

I know this is an old thread, but maybe this will be of help to someone else. I recently encountered a similar issue in Excel 2013 -- in one spreadsheet only, the add/edit/delete a comment option was missing. After much googling and scratching my head, I realized that I had previously saved the workbook with multiple worksheets activated, disabling the comments feature. As soon as I deselected all except one sheet, the comments options reappeared.

Beole here - I just had the very same issue occur and found the solution by accident: Somehow all of the sheets in the Worksheet were "Grouped". If you right click at the name of any of the sheets at the bottom of your excel workbook and select "Ungroup Sheets" that will give you back your ability to edit comments or delete them or add new comments. Somehow I had accidentally "Selected all Sheets".

 

[rrdodge]

Beole here - I just had the very same issue occur and found the solution by accident: Somehow all of the sheets in the Worksheet were "Grouped". If you right click at the name of any of the sheets at the bottom of your excel workbook and select "Ungroup Sheets" that will give you back your ability to edit comments or delete them or add new comments. Somehow I had accidentally "Selected all Sheets".

If you by chance have more than one sheet selected, then you cannot insert a comment. I somehow fat fingered the process by doing Shift-Ctrl-PageUp, when I only intended to do Ctrl-PageUp. I was then attempting to insert a comment not realizing what I had done just before that thinking maybe I am hitting into some upper limit though the Excel Specifications doesn't say anything about maximum number of comments within a single worksheet or workbook like it does with hyperlinks.

After having read this post and seeing that moving to another sheet than back, I switched back to Excel only to see that two worksheets were selected, which was NOT done on purpose. Once I got it back to just the one worksheet selected was I then able to insert comments again.

 

[Vitosha]

found solution on anothe site, worked for me
http://www.actuary.ca/actuarial_discussion_forum/showthread.php?t=121447

"Go into VBE (Alt-F11)
If you don't already have an "Immediate" window, pull it up (Ctrl-G)
Type in: CommandBars("Cell").Reset"

 

[bparvanov]

Works for me!!!
many thanks.
Actuaries are funny guys

 

[BrunoM]

I have this same issue, unfortunately this fix did not work for me. Do you have another suggestion?

 

[BriGuy385]

I have this same issue, unfortunately this fix did not work for me. Do you have another suggestion?

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!