Permission & Access Issues

Fix Excel Cannot Delete or Insert Rows (Worksheet Protected)

Huma Ashraf Ch Sep 29, 2026 869 views

Question details

The user is unable to delete or insert rows in an Excel worksheet, frequently experiencing disabled commands caused by worksheet protection or sheet link issues.

How to Fix Excel Cannot Delete or Insert Rows Because the Worksheet is Protected

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to delete rows, insert cut cells, or modify the layout of an existing worksheet.
Observed behavior: The Delete Rows and Insert Cut Cells options are greyed out or fail to execute, while some other editing features might still function normally.

Before you start

Before proceeding, press the Esc key on your keyboard to ensure you are not currently in Edit, Cut, or Copy mode, which temporarily disables structural changes to the worksheet.

Solution 1Recommended

Unprotect the Worksheet and Workbook Structure

Use this solution if the worksheet has been intentionally protected, which restricts structural modifications like inserting or deleting rows.

Worksheet protection is a common feature used to prevent accidental changes to data. When enabled, it often disables the ability to insert or delete rows and columns. You must remove this protection to restore full editing capabilities.

Navigate to the Review Tab

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

Unprotect the Sheet

Click on 'Unprotect Sheet' in the Protect group. If a password was set, you will be prompted to enter it.

Check Workbook Protection

Next to the sheet protection option, click 'Protect Workbook'. If it is highlighted, click it again to disable workbook structure protection.

Unprotect the Worksheet and Workbook Structure

Password Requirement: If you do not know the password used to protect the worksheet, you will need to request it from the document's original creator.

Solution 2

Restore Moved Sheets to Original Workbooks

Use this if the problem started after moving a worksheet to a different workbook containing external references.

Solution 3

Start Excel in Safe Mode and Disable Add-ins

Use this method if the issue affects multiple workbooks, indicating a potential conflict with third-party Excel add-ins.

WPS Spreadsheet Alternative

Easily Manage and Edit Protected Worksheets in WPS Office

WPS Spreadsheet offers high compatibility with Microsoft Excel files. You can effortlessly open your protected workbooks, remove sheet protection, and insert or delete rows with a familiar interface.

1. Open Your File in WPS Spreadsheet: Launch WPS Office and open your .xlsx or .xls file that is experiencing the row deletion issue.
2. Access the Review Options: Navigate to the 'Review' tab on the top ribbon.
3. Unprotect the Worksheet: Click 'Unprotect Sheet' and enter the password if prompted. You will now be able to insert and delete rows seamlessly.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Familiar user interface requiring zero learning curve.Free, lightweight, and fast alternative to heavy Office suites.Built-in robust file protection and management tools.

Frequently Asked Questions

Why is the 'Delete Row' option greyed out even when my sheet isn't protected?

The option can be greyed out if you are actively editing a cell, if multiple sheets are grouped together, or if you are working within a shared workbook with restricted permissions. Press Esc to exit cell editing mode and right-click a sheet tab to ensure 'Ungroup Sheets' is selected.

Can external workbook links prevent me from inserting or deleting rows?

Yes. If your worksheet contains complex array formulas or linked cells referencing another workbook, moving the sheet can temporarily lock structural modifications. Moving the sheet back to its original workbook often restores full functionality.

How do I unprotect an Excel sheet if I forgot the password?

If a worksheet is password-protected and you have forgotten the password, you cannot natively unprotect it within Excel. However, you can often bypass the restriction by highlighting all the visible data, copying it, and pasting it into a completely new workbook.

Document & File Issues