
Delete Row
This shortcut will delete rows that are selected.
Windows shortcut
Ctrl-
Mac shortcut
⌘-
Excel 2013
- Shift+Spacebar to select the row.
- Ctrl+-(minus sign) to delete the row.
Excel 2016
- Shift+Spacebar to select the row.
- Ctrl+-(minus sign) to delete the row.
To quickly delete a row in Excel, select a row and use the shortcut CTRL - (minus sign). To quickly delete multiple rows, select multiple rows and use the same shortcut.
To delete a row in Excel, execute the following steps.
1. Select a row.
2. Right click, and then click Delete.
Result:
Note: instead of executing step 2, use the shortcut CTRL - (minus sign).
Delete Rows
To quickly delete multiple rows in Excel, execute the following steps.
1. Select multiple rows by clicking and dragging over the row headers.
2. Press CTRL - (minus sign).
Result:
Delete Cells
Excel displays the Delete Cells dialog box if you don't select a row or multiple rows before using the shortcut CTRL - (minus sign).
1. Select cell A3.
2. Press CTRL - (minus sign).
3a. Excel automatically selects “Shift cells up”. Click OK.
Result:
3b. To delete a row, select “Entire row” and click OK.
Result: