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

God blesses you :)

Answer 2

didn't work for me. I don't understand why they didn't give a quick solution? are they kidding?

Answer 3

didn't work for me. I don't understand why they didn't give a quick solution? are they kidding?

If kidding is laughing all the way to the bank, yes.  I think the only method I found that worked regularly for me was Shift + F2.  Slightly annoying to have to do it every time but it worked.  I don't know exactly when mine started working again but it was probably after an update.

Answer 4

After trying to figure this problem out for some time, I came to the realisation that Microsoft simply changed the word "comment" to "note". In other words, "comments" are now "notes". Right-click on a cell and select "New note". (They went from "Insert comment" to "New note".)

Answer 5

there is no such option on my right-click menu, not on the ribbon, nor in the ribbon settings (commands' list)