METHOD 1. Delete multiple rows by selecting entire rows
EXCEL Select the number of rows you want delete > Right-click anywhere on the selected rows > Click Delete
| 1. Select the number of rows you want to delete. Note: in this example we are deleting three row (rows 2, 3 and 4). To select entire rows, either click on the first row number and drag down until you reach the number of rows you want to delete or select the first cell of the row, press and hold the Ctrl and Shift keys and press the Right key, then release the Ctrl key (still holding the Shift key) and press the Down key to select the number of rows you want to delete. |  |
| 2. Right-click anywhere on any of the selected rows and click Delete. |  |
METHOD 2. Delete multiple rows using the ribbon option
EXCEL Select multiple cells > Home tab > Cells group > Delete > Delete Sheet Rows
| 1. Select the cells where you want to delete rows. Note: in this example we are deleting three rows (rows 2, 3 and 4). You can select multiple cells across separate rows and columns (e.g. B4, E7, G9) which will delete rows 4, 7 and 9. |  |
| 2. Select the Home tab. |  |
| 3. Click Delete in the Cells group. 4. Click Delete Sheet Rows. |  |
METHOD 3. Delete multiple rows using the cell option
EXCEL Select multiple cells > Right-click on any of the selected cells > Delete > Entire row > OK
| 1. Select the cells where you want to delete rows. Note: in this example we are deleting three rows in rows 2, 3 and 4. You can select multiple cells across separate rows and columns (e.g. B4, E7, G9) which will delete rows 4, 7 and 9. | |
| 2. Right-click on any of the selected cells. 3. Click Delete |  |
| 4. Select the Entire row option and click OK group. |  |