Fix Disabled Insert, Delete, Clear Contents, and Paste Options in Excel
Question details
The user needs to restore unavailable Insert, Delete, Clear Contents, and Paste commands in an Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is working in an Excel worksheet that does not appear to be protected and wants to edit cells, rows, columns, or pasted content.
- Observed behavior
- Excel editing commands, including Insert, Delete, Clear Contents, and Paste options, are disabled or unavailable.
Click a cell once and press Esc to exit cell-editing mode before testing the commands. Close any open Excel dialog boxes, as an active dialog can prevent worksheet commands from being used.
Check worksheet restrictions, shared mode, filters, and read-only status
Use this method first when editing commands are disabled only in one workbook or worksheet.
Excel disables some editing commands when the workbook is protected, opened as read-only, in legacy shared-workbook mode, or restricted by the current selection. Filtering can also affect actions involving rows and columns.
Press Esc, then click a normal worksheet cell. To insert or delete a full row or column, click the row number or column letter to select the entire row or column.
On the Review tab, select Unprotect Sheet if it is available. Also select Review > Protect Workbook and check whether workbook structure protection is enabled; enter the password if one is required.
Go to File > Info and look for a read-only or protected-file notice. If Excel shows an Enable Editing button in the message bar, select Enable Editing. You can also use File > Save As to save an editable copy.
Select Review > Share Workbook (Legacy), if that command is available, and clear the option that allows changes by more than one user at the same time. Save the workbook and reopen it.
Go to Data > Filter to turn filtering off temporarily, or use Data > Clear to clear the current filter. Then try Insert or Delete again from Home > Insert or Home > Delete.

Restart Excel and test whether the issue is limited to one workbook
Use this method when the worksheet is not protected or when commands remain disabled after checking file restrictions.
Edit Excel Workbooks with WPS Spreadsheets
If Excel commands remain unavailable because of an Office-specific issue or you need a lightweight alternative, WPS Office provides a free and familiar spreadsheet workspace for opening, reviewing, and editing compatible workbooks. Its ribbon-style interface helps you move from Excel with minimal adjustment.

Frequently Asked Questions
Why are Insert and Delete disabled in only one Excel workbook?
The workbook may be protected, read-only, or using legacy shared-workbook mode. Check Review > Unprotect Sheet, Review > Share Workbook (Legacy), and File > Info for editing restrictions.
Why is Clear Contents unavailable in Excel?
Clear Contents can be unavailable when you are editing a cell, a dialog box is open, or the worksheet is protected. Press Esc, click a worksheet cell, then use Home > Clear > Clear Contents.
Can a filter prevent me from inserting or deleting rows in Excel?
A filter can limit row operations in a selected range. Go to Data > Filter to turn it off temporarily, or select Data > Clear to remove the current filter before trying the command again.
How do I tell whether an Excel file is read-only?
Open File > Info and check for a read-only or protected-file notification. If an Enable Editing button appears above the worksheet, select it; otherwise, use File > Save As to create an editable copy.
What does it mean if the commands work in a new Excel workbook?
It usually means the Excel application is working correctly and the problem is specific to the original file, such as protection, sharing settings, corruption, or restricted permissions.




