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

I had to chat with 3 support technicians including one supervisor for 4hours to successfully Uninstall and reinstall all the Microsoft apps.

Not sure what is the problem...

Both support technicians updated the apps to the latest version and supervisor acknowledged it but apps installed is still the old version...

So Supervisor had to Uninstall and reinstall to get most updated version...

Once the most updated version is installed, I can get both comment and note from 1.review tab, 2.mouse right click and short cut.

Thank you Jazfin for replying. Hope this chat can continue to help others with the same problem.

Jackie

Answer 2

I had this - New Note disappeared from the right hand menu on a workbook I use for my home accounts. On further inspection I saw I had two worksheets selected simultaneously for some reason. I clicked both worksheet tabs so only one was selected and the missing feature reappeared.

Answer 3

I just found that if you copy a cell that had a comment into a blank cell, you can edit the comment to enter new info.

Answer 4

I just found that if you copy a cell that had a comment into a blank cell, you can edit the comment to enter new info. 

I have found another solution ! None of the above were working, not even [SHIFT + F2]. Go to any empty cell that does not have any comment at present. Right click, select "Set Print Area", left click. Now press the [cancel] button.

Hey presto - the facility to enter / edit / delete comments has returned to the whole sheet ! I suspect that the facility to add / edit comments was accidentally turned-off by pressing the "Set Print Area" option in error previously ?

Answer 5

I don't have " Set print area" button when rt click?