How to Delete a Whole Row in Excel Safely and Cleanly

How-to basics · Updated November 20, 2026

To delete a whole row in Excel for Microsoft 365 on Windows, click its numbered row header, right-click, and choose Delete. You can also select the row and use Home > Delete > Delete Sheet Rows. Deleting a row removes its contents and formatting across the worksheet and shifts the rows below it upward, so check the selection and save a copy first if the data matters.

What You’ll Need

  • An Excel workbook with the worksheet you want to edit.
  • Permission to change the sheet. A protected worksheet may block row deletion.
  • A backup or a saved copy if you might need to restore the deleted information later. Undo is useful, but it is not a substitute for a backup when edits are shared or complex.

Step-by-Step

  1. Open the correct worksheet. Use the sheet tabs at the bottom of the Excel window to find the sheet containing the row. If the workbook has several similarly named sheets, verify the sheet name before making changes.
  2. Identify the row by its number. Look at the numbered headings along the left edge of the grid. If you intend to remove a customer’s record, for example, find that person’s name first, then check the number at the left of the same row. This helps prevent deleting a neighboring record by mistake.
  3. Select the entire worksheet row. Click its row number, also called the row header. The full row should become highlighted across the sheet. You can select several adjacent rows by clicking the first row number and dragging over the others, or by holding Shift while clicking the last row number. To select separate rows, hold Ctrl on Windows while clicking each row header.
  4. Delete the selected row. For the mouse method, right-click a selected row header and choose Delete. For the ribbon method, go to Home > Delete > Delete Sheet Rows. The command removes the selected worksheet row or rows; it does not just empty their cells.
  5. Check the result immediately. The rows below the deleted row move upward. Look at the records above and below the gap you intended to remove and confirm the correct row is gone. If the wrong row disappeared, press Ctrl+Z on Windows right away, then select the intended row and try again.
  6. Save the workbook. Press Ctrl+S on Windows after checking the result. If you are unsure about the change, save a separate copy first using File > Save As, rather than overwriting the only copy of important data.

Keyboard option: Click a cell in the row, then press Shift+Space to select the entire worksheet row. Press Ctrl+- (Ctrl and the minus key) to open Excel’s Delete dialog, choose Entire row, and select OK. If you have already selected the row header, Ctrl+- deletes the selected row without needing to choose a cell range. Check the highlighted selection before confirming.

For a row inside an Excel table: A formatted table has its own row-deletion command. Click a cell in the table row, right-click, choose Delete, then choose Table Rows. You can also use Home > Delete > Delete Table Rows when that option is available. This removes the table record and keeps the table structure; it is different from deleting a worksheet row outside the table.

On Mac or Excel for the web: The row-header method and the ribbon commands work similarly, though the exact menus can vary slightly with the interface. On Mac, use Home > Delete > Delete Sheet Rows or right-click the row header and choose Delete. A keyboard shortcut can vary with the Mac keyboard and Excel version, so use the ribbon if the shortcut is unclear. In Excel for the web, select the row header and use its context menu or the Home tab; browser keyboard shortcuts may interfere with some key combinations.

Common Mistakes

  • Pressing Delete on the keyboard and expecting the row to disappear. The Delete key usually clears the contents of selected cells; it does not remove the worksheet row or pull the rows below upward. Use the row header’s Delete command or Home > Delete > Delete Sheet Rows.
  • Deleting only the cells that contain data. Selecting a few cells and choosing Delete may open options that shift cells up or left. That can misalign values from different records. Select the row header when you mean to remove the entire worksheet row.
  • Removing a worksheet row when you meant to remove a table record. In a table, use Delete > Table Rows to remove the record from the table. Deleting a worksheet row affects the sheet grid, including cells outside the table in that row.
  • Assuming the row is empty because it looks blank. It may contain formulas, spaces, formatting, or values in columns outside the visible area. Click the row header and inspect the formula bar or scroll across the sheet before deleting if the information may matter.
  • Ignoring filters or hidden rows. A filtered list can hide records, and a row number may jump over hidden rows. Check the filter state and confirm which record is selected before removing it. Selecting a worksheet row header can affect the whole row, including cells not currently visible.

Tips

  • Use Undo promptly. Ctrl+Z on Windows reverses the most recent deletion in the current editing session. On Mac, use Command+Z. If you have made several changes since the deletion, undo may reverse more than you intend; check each step and stop once the row is restored.
  • Delete several consecutive rows together. Drag across their row headers, or select the first header and Shift-click the last. Then use Delete once. For separate rows, use Ctrl-click on Windows to select their headers, but double-check every highlighted row before deleting.
  • Consider clearing instead of deleting. If you need to preserve row positions for a template, formulas, or references, select the cells and use Home > Clear > Clear Contents. This removes values and formulas without shifting lower rows. It does not remove the row or necessarily remove formatting.
  • Know what happens to formulas and references. Excel adjusts many formulas when rows are deleted, but the result depends on the formula and workbook structure. Review totals, charts, and linked sheets after a deletion, especially in a workbook used for reporting.
  • Save a working copy before a large cleanup. Use File > Save As and give the copy a clear name. This provides a fallback if you delete many rows, discover that records were needed, or cannot use Undo after closing the workbook.

Troubleshooting

The Delete command is unavailable or Excel will not remove the row. The worksheet may be protected. Check Review > Unprotect Sheet; if Excel asks for a password, you need the password or help from the workbook owner. Shared permissions or an organizational policy can also prevent edits. Do not try to bypass protection; ask the owner for access.

The row disappears but the data seems misaligned. You may have deleted cells rather than the whole worksheet row, or used a shift-cells option. Press Ctrl+Z on Windows (Command+Z on Mac) immediately, then click the row number and use Delete Sheet Rows. Confirm that related fields, such as a name and email address, remain on the same row.

Only part of a table record was removed. Undo if possible, then select a cell in the table record and choose Delete > Table Rows. If the command is missing, confirm that the selected cell is inside the table rather than in the worksheet area next to it. A table filter may also hide other records, so check which entry is selected.

The wrong row was deleted, or Undo is no longer available. If the workbook is still open and the deletion is recent, use Undo before making further edits. If you already saved, closed, or made many subsequent changes, restore the row from a backup or an available version history. In OneDrive or SharePoint, check the file’s version history if your account and permissions provide it. Otherwise, you may need to recreate the row from the original source.

You cannot tell which row is selected. Click the row number again and look for the selection highlight across the grid. Zoom out or scroll horizontally if the highlight is hard to see. If the sheet contains hidden rows, temporarily unhide or clear filters where appropriate, then confirm the row’s identifying values before deleting.

Frequently Asked Questions

Does deleting a whole row delete data in every column?
Yes. Deleting a worksheet row removes its cells across the full row, not just the columns currently visible or filled. The rows below move up. A table-row deletion removes that table record, while leaving unrelated worksheet cells outside the table alone.

What is the difference between Delete and Clear Contents?
Delete removes the selected worksheet row or cells and can shift other cells or rows. Home > Clear > Clear Contents removes values and formulas from the selected cells but leaves the cells and row in place. Choose Clear Contents if keeping the worksheet layout fixed is important.

Can I delete more than one row at a time?
Yes. Select adjacent row headers by dragging or using Shift-click, then choose Delete. On Windows, Ctrl-click row headers to select separate rows. Review the highlighted selection carefully; a mistaken multi-row selection can remove more records than intended.

How do I delete a row without a mouse?
Click a cell in the row, press Shift+Space to select the entire row, then press Ctrl+- on Windows. In the Delete dialog, choose Entire row and select OK. If your keyboard layout does not make the shortcut convenient, use the Home tab’s Delete menu.

Can I recover a deleted row after saving?
Often, if the workbook is still open, Undo may restore it. After closing the workbook or clearing the Undo history, recovery depends on a backup or version history, such as one available through OneDrive or SharePoint. Saving alone does not guarantee that Excel can recover a deleted row later.

Why did the row numbers change after deletion?
Worksheet row numbers identify positions, not permanent record IDs. When you delete a row, the rows beneath it move up and receive new row numbers. If you need a stable identifier for each record, keep a separate ID value in a column instead of relying on the worksheet’s row number.

Related

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.