Excel Won’t Let You Delete a Row? Try These Fixes

Excel Won't Let You Delete a Row? Try These Fixes

To delete a worksheet row in Excel for Microsoft 365 on Windows, select its numbered heading, then choose Home > Delete > Delete Sheet Rows. If that command is unavailable or Excel refuses the action, the most common cause is sheet protection; otherwise, check whether you are working in a table, a filtered range, or a read-only file.

Make sure you are using a row-delete command

Excel has more than one kind of delete action, and they do different things. Pressing the Delete key usually clears the contents of selected cells; it does not remove their worksheet row. The row remains in place, so the data below it does not move up. To remove the row itself, select the row heading at the far left, right-click it, and choose Delete, or use the ribbon command above.

You can also select a cell in the row and press Ctrl+- (the minus key) on Windows. Excel opens a Delete dialog; choose Entire row and confirm. On a Mac, Control+- is the usual equivalent, although keyboard layouts can vary. If the shortcut does not open the dialog, use the ribbon or context menu instead. In Excel for the web, select the row heading, right-click, and choose Delete Row; the wording and available commands can differ slightly from the desktop app.

Before confirming, check that the row heading—not just a cell—is selected if you intend to remove the entire worksheet row. Deleting an entire row shifts the rows underneath it upward and can affect formulas, references, charts, or other data farther down the sheet. If you only want to remove a value, select the cell and use Delete instead.

Check whether the worksheet is protected

A protected worksheet can prevent row deletion even when you can select cells and edit some of their contents. Look at the Review tab for an Unprotect Sheet command. If it is available, select it; Excel may ask for the password used to protect the sheet. After protection is removed, try deleting the row again.

If you are responsible for the workbook, you can change the permissions rather than leave the sheet unprotected. First unprotect it, then choose Review > Protect Sheet and allow users to delete rows in the protection options. The exact available permissions depend on the Excel version. If you do not know the password, ask the workbook owner or administrator. There is no ordinary Excel command that safely bypasses a forgotten protection password.

Do not confuse sheet protection with workbook-structure protection. Protect Workbook is intended to restrict structural changes such as adding, deleting, moving, hiding, or renaming worksheets; it does not normally govern deleting a row within an unprotected sheet. If the problem is on a worksheet, check its sheet-protection status first.

Determine whether the row belongs to an Excel table

An Excel table has its own row and column commands. If the row is inside a table, right-click a cell in that table row and choose Delete, then Table Rows. This removes the table record while keeping the table structure intact. You can also use the Table Design tab, but the right-click menu is often the clearest route when the selection is inside a table.

Choosing Delete Sheet Rows instead removes the worksheet row, not just a table record. That can affect cells beside or below the table, so use it only when you really intend to remove the whole worksheet row. Conversely, clearing a table row’s contents with the Delete key leaves an empty table record; it does not remove that record from the table.

If the menu does not show a table-row option, click inside the suspected table and check whether a Table Design tab appears. A formatted range can look like a table without being one. If it is an ordinary range with filters or colored formatting, use the regular worksheet-row command.

Take care with filters and hidden rows

Filters hide records that do not match the current criteria; they do not delete them. A row that appears to be missing may simply be filtered out. Clear the filter or inspect the filter criteria before deciding that a row needs to be removed. In a table, use the filter arrow in the relevant column and choose Clear Filter, or use the Data tab’s filter controls.

Filtering matters when deleting, too. If you select a block of worksheet row numbers that includes hidden rows, you may remove more records than the visible ones you meant to delete. Check the selection carefully and, when possible, remove unwanted records through the table’s row controls or adjust the filter so the intended records are easy to identify. If the task is to delete every record meeting a condition, verify the criteria and the selected rows before confirming.

Manually hidden rows and collapsed outline groups can also make a sheet look incomplete. Unhide or expand the relevant rows if you need to inspect what is there. Hidden or collapsed rows are not protected from deletion simply because they are out of sight.

Check file permissions and editing mode

A workbook opened as read-only cannot be changed in place. Look for a Read-Only label in the title bar, an editing notice, or a Protected View banner. If Excel offers Enable Editing and you trust the file and its source, select it. Protected View is a security feature for files that may be unsafe; do not enable editing simply to get past a warning when you are unsure where a file came from.

If the file is read-only because of its location or permissions, save an editable copy with File > Save As, provided you have permission to do so. A file may also be locked for editing by another person, another Excel session, or a shared storage service. Close duplicate copies and ask the other editor to release the file if needed. In a work or school environment, an administrator may need to change access rights.

Excel for the web and coauthored workbooks can show that another person is editing the file. That alone does not always prevent deleting rows, but access restrictions or a temporary sync problem can. Wait for the workbook to finish saving, confirm you have edit permission, and try again. If the command remains unavailable, open the file in desktop Excel if your account and file permissions allow it.

Look for merged cells and unusual selections

Merged cells can complicate row operations because one merged area may span several rows or columns. If Excel reports that the operation cannot be performed on a merged cell, inspect the nearby merged areas before trying again. Select the affected range and use Home > Merge & Center to review the merge options; unmerge only if doing so fits the sheet’s layout. Unmerging can change how content appears, so make a copy first when the design matters.

Also check that the active selection is what you think it is. Clicking a row number selects a whole worksheet row, while dragging across cells selects only those cells. A multi-area selection, a selected range that intersects merged cells, or a selection that includes an unintended block can produce a confusing result. Press Esc to cancel an active selection or dialog, click a single cell, and retry with the row heading.

If the row appears selected but the command is greyed out, check protection and file permissions before assuming the worksheet is damaged. Excel commonly disables editing commands when the current sheet or file cannot be changed.

Recover if you deleted the wrong row

If you have not made later changes you need to keep, press Ctrl+Z on Windows immediately to undo the deletion. On Mac, use Command+Z. Excel’s Undo command can restore a deleted row in an ordinary editing session, but it may not be available after certain actions, after closing the workbook, or when changes have been made through some external or automated processes.

For a workbook stored in OneDrive or SharePoint, version history may provide another recovery route. Open the file’s version history through the file menu or the storage service, review an earlier version, and restore it only if that will not discard other people’s newer work. For important workbooks, make a copy before bulk deletion or structural changes. A backup is especially useful when a filter or table selection makes it difficult to judge exactly which records are selected.

Prevent row-deletion problems next time

Before deleting, identify whether your target is a worksheet row, a table record, or just the contents of a cell. Those choices have different effects. A short checklist helps avoid accidental data loss:

Confirm the correct worksheet and inspect the row’s contents.
Check whether the row is in a table, filtered range, or merged area.
Use Delete Sheet Rows for a worksheet row, or Delete > Table Rows for a table record.
Review the selected row numbers, especially when some rows are hidden.
Save a copy first if the deletion affects many records or a shared workbook.

If you regularly need to remove records that meet a condition, consider filtering the table and reviewing the visible matches before deletion. For a repeatable cleanup task, keeping an untouched source copy is safer than relying on Undo. On a protected template, ask its owner to grant the needed permission rather than changing protection without approval.

Frequently Asked Questions

Why does the Delete key clear a row instead of removing it?

The Delete key clears cell contents; it does not delete worksheet structure. Select the row heading and use Home > Delete > Delete Sheet Rows, or right-click the heading and choose Delete.

Why is Delete Sheet Rows greyed out?

The sheet may be protected, the file may be read-only or in Protected View, or the current selection may not allow that operation. Check Review for Unprotect Sheet, confirm editing is enabled, and select a row heading.

Can I delete a row from a protected Excel sheet?

Only if the sheet’s protection settings permit row deletion. Otherwise, someone with permission must unprotect the sheet or change its allowed actions. Excel may request the protection password.

How do I delete a row from an Excel table without shifting other cells?

Right-click a cell in the table record and choose Delete > Table Rows. This removes the record from the table; deleting the whole worksheet row can also shift cells outside the table.

Will deleting a row remove the data below it?

It does not erase the data below, but it shifts that data upward to fill the gap. Check formulas and references afterward, particularly in sheets where row positions have a specific meaning.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.