Insert Comment option is missing from right-click menu

Question

I am using Excel 2016 on Windows 10. Today, the "Insert comment" option disappeared from the right-click pop-up context menu. When I right-click on a cell with no comment, there is no option to add one. If I right-click on a cell with a comment, I can edit or delete the comment. On the Insert tab of the ribbon, the Comments section is grayed out. This problem is affecting all spreadsheets that I have tried.

I googled the problem and tried every solution offered but none of them worked. How can I add comments to cells again?

Thank you

Answer 1

That work-around by using shift F2 to insert a comment does work, but is not convenient.  So Microsoft..... please restore the functionality of right click to insert a comment in a cell.  The right click to insert a comment stopped working for me a couple of days ago, coincidentally??? right after Microsoft's last "update" was installed a couple of days ago.  Hmmm, I usually find that these forced updates do not improve things.

Answer 2

It works now.

Suddenly I have two new options in the right click menu (new comment and new note).

The thing that works like the old insert comment is new note.

I don't know if it help anyone but I changed the Account > Office Insider level to Insider.

Good luck.

Answer 3

It works now.

Suddenly I have two new options in the right click menu (new comment and new note).

The thing that works like the old insert comment is new note.

I don't know if it help anyone but I changed the Account > Office Insider level to Insider.

Good luck.

Thanks!  This morning I suddenly have "Insert Comment" as an option when I right-click.  Yay!!!

I don't have  a "new note" option, but that's okay, now that the insert comment is back.  How weird is all this.

I have had a lot of experience with programmers"tweaking" things, and the one step they usually miss is testing and probably even more importantly, is asking a non-techie user if everything works!!!!

Thanks again.

Answer 4

I have the same issue. Shift+f2 will insert a comment, but the option is now missing from the right click menu.

Answer 5

It works now.

Suddenly I have two new options in the right click menu (new comment and new note).

The thing that works like the old insert comment is new note.

I don't know if it help anyone but I changed the Account > Office Insider level to Insider.

Good luck.

Thanks!  This morning I suddenly have "Insert Comment" as an option when I right-click.  Yay!!!

I don't have  a "new note" option, but that's okay, now that the insert comment is back.  How weird is all this.

I have had a lot of experience with programmers"tweaking" things, and the one step they usually miss is testing and probably even more importantly, is asking a non-techie user if everything works!!!!

Thanks again.

Obviously this is only working for certain people. as I still have to use Shift + F2.