This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
You need to right click the cell and then check on edit objects and edit scenarios before protecting the cells you want to protect.
I don't have " Set print area" button when rt click?
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 ?
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 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.