Share via

Missing Delete function in Excel 2016 row / column right click

Anonymous
2018-02-27T11:06:56+00:00

Hi,

My Excel is missing Delete / Insert options from right click menu. See image below. Any ideas? 

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
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2018-02-27T11:08:47+00:00

    Try following one by one as check after every step whether it resolves the issue-

    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)

    1. Open Excel
    2. ALT+F11
    3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window
    4. Type "? application.StartupPath" without quotes and press enter
    5. You will have your path below.
    6. Try repairing your office installation. irst try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

    https://support.office.com/en-us/article/Repair...

    1. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

    To start in Safe Mode -

    Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

    If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

    To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

    47 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-28T20:37:58+00:00

    Thanks! Step 1 worked

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-03-27T17:37:25+00:00

    This fix doesn't work for me. If I open in safe mode, the options reappear leading me to believe it is an add-in. Only non-excel add-in I have is Think-cell, I have disabled and deleted (even removing the dll) but the drop down still does not have the option to delet or insert cells.

    0 comments