Delete rows in Excel shortcut

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

To delete a row in Excel, you need to right-click or select Delete Row from the Home tab, but you can use the shortcut keys to delete rows smoothly. You can also quickly delete multiple unwanted rows with the shortcut keys. By using the useful shortcut keys I am about to share with you, you can drastically cut down the time you spend on deleting rows and work more efficiently.

Delete row shortcut

Windows
Ctrl + – (minus)
Access Key: Alt + H + D + R

Mac
command + – (minus) or control + – (minus)

Delete single row

This is a way to delete a single row using a shortcut key.

Total Time: 1 minute

Select a cell

Select the cell in the row you want to delete.

Select a row

Press Shift + Space to select the entire row.

Delete sheet row

Press Ctrl + - (minus) or Alt + H + D + R to delete a row.

Delete a row from the Delete dialog box

Select the cell in the row you want to delete. Press Ctrl + – (minus).

The Delete dialog box will appear.

Use the ↓ (Down Arrow key) to select the Entire row, and press Enter.

The selected row has been deleted.

Delete multiple rows

Select the cell in the row you want to delete.

Press Shift + Space to select the entire row.

Press Shift + ↓ (Down Arrow key) to select multiple rows.

Press Ctrl + – (minus) or Alt + H + D + R to delete multiple rows.