Excel Protected Sheet: Why You Can’t Delete Rows in Excel

Excel Protected Sheet: Why You Can't Delete Rows in Excel

If you can’t delete rows in an Excel worksheet, the sheet is probably protected and its protection settings do not allow row deletion. In Excel for Microsoft 365 on Windows, choose Review > Unprotect Sheet to remove protection, or have the sheet owner unprotect it and then protect it again with Delete rows enabled.

Why sheet protection blocks row deletion

Worksheet protection is designed to stop changes to a sheet’s structure or contents. When protection is on, Excel can allow some actions while blocking others: a user might be able to select cells, enter data in unlocked cells, or sort a range, but still be unable to delete an entire row. Being able to edit one cell is not proof that row deletion is permitted.

Deleting a row is a structural change. It removes the cells in that row and shifts the rows below upward, so it is different from clearing the contents of a cell. Excel treats these as separate permissions. On a protected sheet, the Delete rows option in the protection settings controls whether users can use the row-deletion command.

There are also two different kinds of protection that can be confused:

Worksheet protection controls what users can change on a particular sheet, including whether they can delete rows.
Workbook structure protection controls actions such as adding, deleting, moving, or renaming worksheets. It does not itself grant permission to delete rows inside a sheet.

If Excel’s message says the sheet is protected, check worksheet protection. If the problem is that a worksheet tab cannot be deleted or renamed, check workbook structure protection instead.

Check whether the worksheet is protected

Select the sheet where the deletion fails and look at the Review tab. If the ribbon shows Unprotect Sheet, that sheet is protected. Choose the command; if the sheet has a password, Excel asks for it. If the ribbon instead shows Protect Sheet, the sheet is not currently protected, so the cause lies elsewhere.

Protection applies separately to each worksheet. A workbook can have one protected sheet and several unprotected sheets, so check the tab where the rows are located rather than assuming the whole file has the same settings. Also check whether the workbook’s structure is protected if you are trying to remove a worksheet tab rather than rows within it.

On Excel for Mac, the protection commands are also on the Review tab, although ribbon layout and dialog details can differ by release. Excel for the web has its own interface and may not expose every desktop protection option in the same way; if you need to change the permission settings, open the workbook in the desktop app when available.

Allow row deletion on a protected sheet

If you own the workbook or have permission to change its settings, you can configure the sheet to permit row deletion while keeping other restrictions in place. In Excel for Microsoft 365 on Windows, use this sequence:

Open the correct worksheet and select Review > Unprotect Sheet. Enter the password if Excel requests one.
Select Review > Protect Sheet.
In the Protect Sheet dialog, review the permitted actions and select Delete rows. Leave other actions unchecked unless users should be allowed to perform them.
Set a password if appropriate, confirm it, and select OK. Store the password somewhere the workbook owner can access.
Test the setting on a disposable row or a copy of the workbook, then confirm that users can still do only the other actions you intended to allow.

Excel’s Protect Sheet dialog also has a list of actions, such as selecting locked or unlocked cells, formatting cells, inserting rows, and sorting. Enabling Delete rows does not automatically enable every other action. Choose permissions deliberately: for example, a sheet designed for data entry may allow users to select unlocked cells and delete rows without allowing them to format locked cells.

If the sheet is already protected and you do not know the password, you cannot simply change its permissions from the dialog. Ask the workbook owner or the person who set the protection to unprotect the sheet and update the settings. Avoid editing a live shared workbook without authorization, because deleting a row changes the data and may affect formulas, references, reports, or other users’ work.

Check whether cells in the row are locked

Even when Delete rows is selected, Excel may refuse to delete a row if the row contains protected cells. The permission is intended for rows that can be deleted without removing locked cells. A cell’s Locked setting matters only while the worksheet is protected; locking or unlocking a cell by itself does not protect it.

To inspect the setting, first unprotect the sheet if needed. Select the cells in question, press Ctrl+1 on Windows to open Format Cells, and look on the Protection tab. The Locked box indicates whether those cells are marked as locked. If the whole row includes locked cells, ask the sheet owner whether those cells should be unlocked or whether the row should be removed by an authorized person while the sheet is unprotected. Do not unlock formulas or control cells casually: protection may be there to prevent accidental changes to them.

For a quick test, use a copy of the workbook and try deleting a row known to contain only unlocked cells. If that works but another row does not, the difference in the cells’ protection settings is a useful clue. It is safer to test on a copy than to alter the permissions of a production sheet just to discover why a particular deletion fails.

Common reasons deletion still fails

If the sheet is protected and deletion is supposed to be allowed, check these common causes before changing more settings:

The permission was not enabled. Unprotect the sheet and reopen Review > Protect Sheet to confirm that Delete rows is selected. A permission cannot usually be changed while the sheet remains protected.
The selected row contains locked cells. Check the cells’ Locked settings, as described above, and confirm the intended design with the workbook owner.
You are clearing cells, not deleting a row. The Delete key removes cell contents; it does not remove the worksheet row. To delete a whole row, select its row number at the left edge, then use Home > Delete > Delete Sheet Rows, or right-click the row heading and choose Delete.
You have selected cells instead of the row heading. Selecting only a few cells and choosing Delete can open options for shifting cells. Select the row number to make the intended operation clear.
You are working inside a table. A table has its own row commands. Right-click a cell in the table row and choose Delete > Table Rows when that is the intended operation. Protection can still limit structural edits, and table-specific options may differ from deleting a worksheet row.
The issue is workbook structure, not sheet rows. Workbook structure protection affects worksheet tabs; it is not the same permission as deleting rows on a worksheet.

Also note that a filter only hides rows that do not match the current criteria; it does not delete them. If your goal is to remove only the visible filtered records, confirm which rows are selected before deleting. Deleting rows in a filtered range can have consequences for the underlying list, so make a copy or verify the selection when the data is important.

Delete rows, clear contents, or remove table records?

Choose the operation that matches what you want to happen. Delete Sheet Rows removes entire worksheet rows and shifts the remaining rows up. Clear Contents leaves the row in place but removes values or formulas from the selected cells. In a table, deleting a Table Row removes a record from the table; it may not mean the same thing as deleting the entire worksheet row if other data sits beside the table.

For example, suppose a protected sheet has an order table in columns A through F and notes in column H. If you intend to remove one order, deleting only the table row is usually the relevant action. Deleting the entire worksheet row would also remove the note in column H. If you only need to correct a quantity, editing the unlocked quantity cell or clearing its contents may be more appropriate than deleting anything.

On a protected sheet, these alternatives are still subject to the permissions and cell-lock settings. If the operation is blocked, ask the owner to make the necessary change or grant the minimum permission needed. Don’t treat clearing contents as a workaround for protection: it can still remove important data if the selected cells are editable.

Protection, passwords, and safe handling

Worksheet protection is useful for preventing accidental edits, but it is not the same as encrypting a workbook or securing confidential information. It should not be relied on as a confidentiality boundary. Use the appropriate file-access and encryption controls for sensitive information, and share only with people who are authorized to see it.

Before changing protection or deleting records, save a separate copy of the workbook. Deleting a row can alter formulas, named ranges, charts, tables, and references elsewhere in the file. Excel may adjust many references automatically, but that does not guarantee that every dependent report or process will still behave as intended. For a shared or business-critical file, confirm the change with its owner and check any relevant totals or downstream outputs afterward.

If you protect the sheet again, keep the password in an approved password manager or another controlled location. If a password is forgotten, contact the person or team responsible for the workbook. Excel does not provide a supported password-recovery command that reveals a forgotten worksheet-protection password.

Frequently Asked Questions

Why can I edit cells but not delete rows in Excel?
Cell editing and row deletion are separate permissions. The cells you can edit may be unlocked, while the protected sheet does not permit deleting rows or the row contains locked cells.

How do I delete rows without unprotecting the whole sheet?
Ask the owner to unprotect the sheet, enable Delete rows in the Protect Sheet dialog, and protect it again. If the relevant row contains locked cells, its cell settings may also need to be reviewed.

Can I delete rows on a protected sheet without the password?
If the sheet requires a password to unprotect, ask the workbook owner or administrator for help. There is no supported Excel command that bypasses the password or reveals it.

Does pressing Delete remove a worksheet row?
No. The Delete key normally clears the contents of selected cells. Select the row heading and use Home > Delete > Delete Sheet Rows to remove an entire worksheet row, if protection permits it.

Why is Delete rows greyed out in Protect Sheet?
The option is configured when you set up sheet protection, so you may need to unprotect the sheet before changing it. If you cannot unprotect it, you need the password or help from the workbook owner.

Does Protect Workbook control deleting rows?
Workbook structure protection controls worksheet-level actions such as deleting or renaming tabs. Deleting rows inside a worksheet is governed by that worksheet’s protection settings.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.