Keyboard Shortcut to Delete Row in Excel: Quick Guide

Master the fastest keyboard shortcut to delete a row in Excel and learn repeatable workflows with code samples. This Shortcuts Lib guide covers Windows and macOS, safety tips, and best practices for reliable data management.

Shortcuts Lib Team

February 28, 2026·5 min read

Keyboard Shortcuts Excel Shortcuts Windows Shortcuts Mac Shortcuts

Delete Row Shortcut - Shortcuts Lib — Photo by Sora Shimazaki via Pexels

Quick AnswerSteps

To delete a row in Excel using keyboard shortcuts, first select the target row with Shift+Space. Then press Ctrl+- on Windows or Cmd+- on macOS to delete the row. If a prompt appears, confirm with Enter; to undo, press Ctrl+Z or Cmd+Z. For multiple rows, select a range and repeat. Save your workbook to commit changes.

Why this matters: speed, accuracy, and consistency

In Excel, deleting a row by keyboard shortcut is faster, less error-prone, and preserves your workflow rhythm. According to Shortcuts Lib, consistent keyboard sequences reduce cognitive load and help avoid accidental deletions. The Shortcuts Lib team found that adopting repeatable keystrokes boosts productivity for data-editing tasks across teams. This section shows practical, code-enabled ways to delete a row without touching the mouse.

Python

# Open-source example: delete a specific row using openpyxl
from openpyxl import load_workbook
wb = load_workbook("data.xlsx")
ws = wb.active
ws.delete_rows(5, 1)  # delete row 5 (one row)
b w

PowerShell

# PowerShell example: delete a row using Excel COM
$excel = New-Object -ComObject Excel.Application
$wb = $excel.Workbooks.Open("C:\path\data.xlsx")
$ws = $wb.Sheets.Item(1)
$ws.Rows.Item(5).Delete()
$wb.Save()
$excel.Quit()

Line-by-line, the script loads the workbook, targets the sheet, deletes the specified row, and saves the workbook. If you want to delete multiple rows, call delete_rows with a different amount. Variations include pandas-based batch deletions or VBA macros (shown in separate snippets below).

Steps

Estimated time: 10-15 minutes

1
Open the workbook
Launch Excel and open the file containing the data. Ensure you’re in a worksheet that contains the target row.
Tip: Use Ctrl+O to open quickly.
2
Navigate to the row
Use keyboard to reach the row you want to delete, staying on the same worksheet.
Tip: Use Ctrl+Arrow keys to move quickly.
3
Select the row
Press Shift+Space to select the entire row under the active cell.
Tip: Double-check the selection before deletion.
4
Delete the row
Press Ctrl+- (Windows) or Cmd+- (Mac) to delete. A confirmation may appear; press Enter or choose Delete.
Tip: If a dialog appears, confirm only after you verify the row.
5
Save changes
Save the workbook to commit the deletion. Use Ctrl+S / Cmd+S.
Tip: Consider saving a backup first.
6
Undo if needed
If you deleted the wrong row, press Ctrl+Z / Cmd+Z immediately.
Tip: Undo is your safety net.

Pro Tip: Always select the correct row with Shift+Space to avoid accidental deletions.

Warning: Deletions cannot be undone after saving unless you have a backup or version history.

Note: In large spreadsheets, deleting rows can affect formulas and references; review affected cells.

Prerequisites

Required

Microsoft Excel (Windows or macOS) with current updates↗
Required
Basic keyboard knowledge (Shift, Ctrl, Cmd)
Required
Backups or version history enabled
Required

Optional

Optional: Python 3.8+ or PowerShell 5.1+ for automation
Optional

Keyboard Shortcuts

Action	Shortcut
Select current rowActive cell's row	`⇧`+`␣`
Delete selected rowRow is highlighted	`Ctrl`+`-`
Undo last deletionIf you deleted the wrong row	`Ctrl`+`Z`

Questions & Answers

What keyboard shortcut deletes a row in Excel on Windows versus macOS?

On Windows, Shift+Space selects the row and Ctrl+- deletes it. On macOS, Shift+Space selects the row and Cmd+- deletes it. After deletion, save to commit changes.

How do I delete multiple consecutive rows with the keyboard?

Select the first row with Shift+Space, then hold Shift and use the Arrow keys to extend the selection. Press Ctrl+- or Cmd+- to delete the entire block of rows. Undo with Ctrl+Z / Cmd+Z if needed.

Can I undo a row deletion after saving?

Undo is typically only available before saving or if you have version history or backups. If you saved, use Version History in Excel or restore from backup.

Will deleting a row affect formulas or references?

Yes, deleting a row shifts ranges and may affect formulas referencing that row. Check affected cells and adjust formulas as needed.

Is there a difference between Delete Row and Clear Content via keyboard?

Delete removes the entire row. Clear Content only clears cell values without removing the row, which leaves gaps and shifts in your data. Use Delete for removals and Clear for data cleanup.