Excel Hack

Delete rows in Excel shortcut

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 a cell

Select the cell in the row you want to delete.

Select a row

Select a row

Press Shift + Space to select the entire row.

Delete sheet 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 a cell

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

Press R, press Enter

The Delete dialog box will appear.

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

Delete a row

The selected row has been deleted.

Delete multiple rows

Select a cell

Select the cell in the row you want to delete.

Select a row

Press Shift + Space to select the entire row.

Press Shift + ↓

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

delete multiple rows

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

Articles related to Delete & Row & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments