Document Editing Problems

How to Fix Excel Cannot Delete or Insert Rows but Can Clear Contents

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is unable to delete or insert rows in their Excel worksheet, though they can still successfully clear row contents.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to modify the structure of an existing spreadsheet by adding new rows or deleting unneeded ones.
Observed behavior: Excel allows clearing the contents of rows but silently blocks inserting or deleting rows, with the options often being disabled and no warning message appearing.

Before you start

Ensure that your workbook is not marked as 'Shared' and that multiple sheets are not currently grouped together, as these states can restrict structural changes like inserting or deleting rows.

Solution 1Recommended

Remove Worksheet Protection

Use this solution if the worksheet creator has locked the document structure to prevent structural changes.

When a worksheet is protected, the owner can specify exactly what users are allowed to do. Often, 'Select locked cells' and 'Clear contents' are permitted, while structural actions like 'Insert rows' and 'Delete rows' remain disabled by default. Disabling the protection will restore these capabilities.

Navigate to the Review tab

Open your Excel workbook and click on the 'Review' tab in the top ribbon.

Unprotect the sheet

Click on the 'Unprotect Sheet' button. If the worksheet was protected without a password, the restrictions will immediately lift.

Enter the password

If prompted, type in the password provided by the document owner and click 'OK' to regain full editing permissions.

Password Requirement: If you do not know the password, you will need to request it from the original author of the document to remove the protection.

Solution 2

Insert or Delete Within the Data Range Only

Use this method if your worksheet contains formatted tables or adjacent used ranges that prevent whole-row deletion.

Solution 3

Test in a New Workbook or Run Office Repair

Use this troubleshooting method if the issue persists across all files, indicating a potential software glitch.

Free Microsoft Office alternative

Use WPS Office for a Hassle-Free Spreadsheet Experience

If Microsoft Excel continues to restrict your worksheet edits or requires complex application repairs, consider switching to WPS Office. It is a lightweight, highly compatible alternative that lets you seamlessly edit Excel files without persistent structural glitches.

1. Download and Install: Get WPS Office for free from the official website and install it on your PC or Mac.
2. Open Your File: Launch WPS Spreadsheets and open your existing .xlsx or .xls file directly.
3. Edit Without Limits: Enjoy seamless editing, row management, and data formatting without encountering structural restrictions.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Effortlessly insert, delete, and manage rows without unexplained freezing or disabled menus.Free to download with a familiar user interface that requires zero learning curve.Lightweight application that runs smoothly even on older devices without heavy system usage.

Frequently Asked Questions

Why is the Delete or Insert option grayed out in my Excel row menu?

This usually happens when the worksheet is protected. The creator of the document may have locked the sheet's structure, preventing users from adding or removing rows while still allowing them to clear or edit cell contents.

Can I insert rows into an Excel sheet that contains a formatted table?

Yes, but if there are multiple tables or used data ranges adjacent to each other, Excel might prevent full row insertion to avoid breaking the other tables. Instead of clicking the whole row header, right-click inside the specific table and select 'Insert' > 'Table Rows Above'.

Will an Office Quick Repair delete my personal Excel files?

No. An Office Quick Repair only fixes the Microsoft Office application files and system registry settings. Your personal workbooks, spreadsheets, and data will remain completely safe and untouched on your hard drive.

How can I check if my Excel workbook is shared?

Go to the 'Review' tab on the ribbon. If you see 'Unshare Workbook' or if the top title bar says '[Shared]' next to the file name, the workbook is shared. Shared workbooks have limitations on structural changes, including inserting and deleting rows.

Document & File Issues