Insert Comment option is missing from right-click menu

Anonymous
2019-03-09T21:28:27+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

71 answers

Sort by: Most helpful
  1. Anonymous
    2020-11-04T09:13:54+00:00

    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

    I too have this problem - even today 4th Nov 2020.

    It is very convenient to use right click than remembering the function keys.

    Please resolve the issue.

    Thank you.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-10-24T07:11:42+00:00

    I used all provided way to solve the problem but I can't comment still.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-10-06T17:42:20+00:00

    You need to right click the cell and then check on edit objects and edit scenarios before protecting the cells you want to protect.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-08-04T16:03:16+00:00

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

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2020-08-03T16:35:50+00:00

    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 ?

    Was this answer helpful?

    0 comments No comments