"Delete" in the EXCEL right-click menu is grayed out

Article
2019-09-27

Question

_{Friday, September 27, 2019 8:01 AM}

"Delete" in the EXCEL right-click menu is grayed out and cannot be used. But select the line you want to delete, you can delete it with the shortcut key.

How can this be solved?

Version EXCEL2010.

All replies (3)

_{Friday, September 27, 2019 8:37 AM ✅Answered | 3 votes}

Hi CZ_WEB1230,

Does it happen with a specific Workbook or all Excel files? Please provide more information, if the steps below don't solve the problem.

1. Check if any worksheets are grouped. If so, ungroup them and try again:
https://support.office.com/en-us/article/group-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0

2. Check if the corresponding file is shared. If so, turn off sharing:
https://support.office.com/en-us/article/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

3. Try disabling any 3rd party COM add-ins. They might cause such unexpected issues.

In Excel, navigate through "File > Options > Add-ins > Manage: COM Add-ins > Go..."
Uncheck/disable all add-ins there
Click OK.

Repair Office.
https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

5. Rebuild/recreate the Excel configuration file.

Close all Excel windows.
Launch Run dialog box (press Windows key + R)
Type %appdata%/Microsoft/Excel in there and click OK.
In the opened folder, find any files named "Excel**.xlb" and rename them like "Excel12.old", "Excel15.old", etc.
Restart Excel.

Regards,
Burak V.

_{Friday, September 27, 2019 9:04 AM}

Hi,

Just checking in to see if the information Burak V. was helpful. Please let us know if you would like further assistance.

Regards,

Emi Zhang

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Thursday, October 10, 2019 9:53 AM}

Hi CZ_WEB1230,

Thanks for marking the reply of Burak V. as answer, it's pleasure that the information will help you. Here I will provide a brief summary of this post for your information.

==================

Issue Symptom:

"Delete" in the EXCEL right-click menu is grayed out.

(Possible) Cause:

The option is disabled in Excel, maybe related to GPO, ADD-INS etc.

Solution:

The solution provided by Burak V.

1. Check if any worksheets are grouped. If so, ungroup them and try again:
https://support.office.com/en-us/article/group-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0

2. Check if the corresponding file is shared. If so, turn off sharing:
https://support.office.com/en-us/article/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

3. Try disabling any 3rd party COM add-ins. They might cause such unexpected issues.

In Excel, navigate through "File > Options > Add-ins > Manage: COM Add-ins > Go..."
Uncheck/disable all add-ins there
Click OK.

Repair Office.
https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

5. Rebuild/recreate the Excel configuration file.

Close all Excel windows.
Launch Run dialog box (press Windows key + R)
Type %appdata%/Microsoft/Excel in there and click OK.
In the opened folder, find any files named "Excel**.xlb" and rename them like "Excel12.old", "Excel15.old", etc.
Restart Excel.

Reference Links:

https://support.office.com/en-us/article/group-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0

https://support.office.com/en-us/article/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b