How to delete multiple rows in excel

To delete multiple rows in Excel, follow these steps carefully:

Method 1: Using Mouse Selection

1. Click the row number of the first row you want to delete.

2. Hold the Shift key and click the row number of the last row you want to delete.

3. Right-click any selected row number.

4. Click Delete from the context menu.
   This will remove all selected rows and shift the remaining rows upward.

Method 2: Using Ctrl Key for Non-Adjacent Rows

1. Click the row number of the first row you want to delete.

2. Hold the Ctrl key and click the row numbers of other non-adjacent rows.

3. Right-click any selected row number.

4. Select Delete.
   This deletes only the rows you selected, leaving other rows untouched.

Method 3: Using Ribbon Commands

1. Select multiple rows using Shift or Ctrl.

2. Go to the Home tab.

3. In the Cells group, click Delete.

4. Choose Delete Sheet Rows.

Method 4: Using Keyboard Shortcut

1. Select the rows using Shift (for contiguous rows) or Ctrl (for non-contiguous rows).

2. Press Ctrl + - (minus) on Windows or Command + - on Mac.

3. Confirm the deletion if prompted.

Notes and Considerations

• Deleting rows is permanent unless undone using Ctrl + Z.

• Formulas referencing deleted rows may return errors or adjust automatically depending on the formula type.

• Using filters can make deleting specific rows faster. Filter your data, select visible rows, and delete.

This approach works for large datasets efficiently, especially when combined with filtering or selecting non-adjacent rows.