How To Delete Multiple Rows In Excel At Once (5 Methods)

Home » How To Delete Multiple Rows In Excel » How To Delete Multiple Rows In Excel At Once (5 Methods)

Maybe your like

The dataset below, Sales of “ABC” Company, shows sales information for products on various dates. It has four columns: Order ID, Product, Amount, and Date.

Dataset of how to delete multiple rows in Excel at once

Method 1 – Using the Context Menu

Steps:

  • Highlight the rows by dragging the mouse over those we want to delete at once.

OR

  • Hold CTRL and select the rows you want to Delete.

Use Context Menu to Delete Multiple Rows at Once

  • Right-click on the selection to open the Context menu.
  • Click Delete.

Use Context Menu to Delete Multiple Rows at Once

A dialog box of Delete will appear.

  • Select the Entire row and click OK.

Use Context Menu to Delete Multiple Rows at Once

The result will look like the image below.

Use Context Menu to Delete Multiple Rows at Once

Method 2 – Using a Keyboard Shortcut

The shortcut is CTRL + Minus(-).

Steps:

  • Select the required rows using the mouse and pull across or separately with the CTRL key.

Use of Keyboard Shortcut to Delete Multiple Rows

  • Hit the  CTRL + Minus(-) buttons.
  •  A dialogue box for deletion will appear.
  • Select the Entire row and press OK.

Use of Keyboard Shortcut to Delete Multiple Rows

The result will look like the image below.

Use of Keyboard Shortcut to Delete Multiple Rows

Method 3 – Applying Conditional Formatting

Steps:

  • Select all the rows. (i.e., range B5 to E11)

Apply Conditional Formatting to Delete Multiple Rows at Once

  • Open the Home tab >> from the Conditional Formatting >> select the New Rule option.

Apply Conditional Formatting to Delete Multiple Rows at Once

  • From the Select a Rule Type box, select Use a formula to determine which cells to format.
  • Enter the following formula in the Format values where this formula is true:
=$D5 > 5000

Here, it will Highlight the values greater than 5000.

  • Select Format.

Apply Conditional Formatting to Delete Multiple Rows at OnceA dialogue box named Format Cells will appear.

  • Click on the Fill.
  • Select a color of your choice.
  • Press OK.

Apply Conditional Formatting to Delete Multiple Rows at OnceA New Formatting Rule box will appear.

  • Hit the OK button.

Apply Conditional Formatting to Delete Multiple Rows at OnceYou can now see the colored rows according to the condition.

  • Go to the Data option.
  • Select Filter from the Sort & Filter.

Apply Conditional Formatting to Delete Multiple Rows at Once

We will be able to see the Filtered data.

  • Go to the column according to the condition and select the Filter.
  • Select Filter by Cell Color and press OK.

Apply Conditional Formatting to Delete Multiple Rows at Once

We will be able to see the Colored rows only.

Apply Conditional Formatting to Delete Multiple Rows at Once

  • Select the rows that you want to delete (i.e., the range B5:E11).
  • Right-click on the mouse and select Delete Row.

Apply Conditional Formatting to Delete Multiple Rows at Once

A warning message will appear.

  • Press OK.

Apply Conditional Formatting to Delete Multiple Rows at Once

  • The selected row will be deleted.
  • Click on the Filter icon to remove Filter from the dataset.

Apply Conditional Formatting to Delete Multiple Rows at Once

You now have the desired result.

Apply Conditional Formatting to Delete Multiple Rows at Once

4. Using Excel VBA

Steps:

  • Go to the Developer tab and select Visual Basic.

OR

  • Press  Alt + F11 .

Delete Multiple Rows Using VBA

  • From the Insert option, select Module.

Delete Multiple Rows Using VBA

  • Enter the following code in the Module:
Sub Delete_Multiple_Rows() Worksheets("VBA").Range("B6:E8").EntireRow.Delete End Sub

Delete Multiple Rows Using VBA

  • Here, I’ve created a Sub procedure Delete_Multiple_Rows, then used the Worksheets object to mention my sheet name.
  • Next, I used the Range.EntireRow property to select the Entire row, then used the Delete method to delete multiple rows.
  • Save the code.
  • Press F5 or select Run Sub/UserForm (F5) to Run the code.

Delete Multiple Rows Using VBA

The Code will be applied. The results should look like the image below.

Delete Multiple Rows Using VBA

Method 5 – Applying Delete Command

Steps:

  • Select the rows that need to be deleted by pressing the CTRL key and using the mouse simultaneously.

Apply Delete Command to Delete Multiple Rows at Once

  • Open the Home tab >> go to Cells >> from Delete >> select Delete Sheet Rows.

Apply Delete Command to Delete Multiple Rows at Once

The selected rows will be deleted.

Apply Delete Command to Delete Multiple Rows at Once

Download the Practice Workbook

Delete Multiple Rows at Once.xlsm

Related Articles

  • [Fixed!] Not Enough Memory to Delete Rows Error in Excel
  • How to Delete Every Other Row

<< Go Back to Delete Rows | Rows in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tag » How To Delete Multiple Rows In Excel