Share via

Excel insert comment option not available

Anonymous
2019-03-12T13:34:57+00:00

Hi, I have an issue here I'm assisting one of our clients. She's using the Microsoft H&B 2016 and on Windows 10 Pro 64bit OS. When on excel trying to insert comments by right clicking on any cell whether a saved or new worksheet the option is not there. And when I go to the insert tab the comment option is greyed out.

I have checked the protection settings and went as far as to do an online repair. Nothing has helped so far. Please help

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-03-16T12:35:49+00:00

    try Shift +F2. works for me

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-03-12T14:31:02+00:00

    Hi NokuthulaMajola

    I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Please try these options one by one and check after each option.

    1. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

    Now open Excel and see if the problem disappears or not.

    Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

    Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

    1. If above doesn't work - ALT+F11 to open VB Editor

    Press CTRL+G to go to Immediate windows

    Paste the below line in Immediate window and Enter and Restart Excel

    commandbars("Cell").Reset

    Do let me know if you have any more question or require further help. If above didn't work, I will supply more troubleshooting steps to solve this problem.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-03-12T14:55:20+00:00

    Is this a problem with a particular Excel workbook or with all workbooks?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-03-12T14:53:58+00:00

    Good Day Vijay_Verma

    I have tried both solution and they did not work, still cannot insert comment

    Was this answer helpful?

    0 comments