How to Delete multiple rows in Microsoft Excel at a time

Microsoft Excel is the most used online and offline sheet making system in the world without any doubt. It comes in stock with the licensed Windows. A proud part of Microsoft Office. It is very simple to use. That’swhy almost all large and medium organizations buy it for their record maintainers.

How to delete multiple rows in Excel:

But, you know noobs don’t pick anything easily even if it is easy. Like, many Excel users still can’t figure out how to delete Microsoft Excels multiple rows at a time. Even there are many ways to do it. In order to simplify the procedure, we are here with a guide infact multiple guides. Through these guides, Excel users can delete multiple rows at a time.

Method 1 >> Using Contextual Menu:

  1. Open the Excel sheet in which you want to amendments.
  2. sNow select the rows that you intend to delete
  3. Right-click the selection and click Delete or Delete rows from the list of options.
  4. A drop-down menu will get opened.
  5. Select Delete Sheet Rows to delete the selection.

Method 2 >> Through cell selection:

  1. Select all the cells in the corresponding rows that you want to delete.
  2. Right-click the selections and click on the Delete option.
  3. Click Entire Row from the delete dialogue box.
  4. Click the OK button.

Method 3>> Running a Macro:

  1. Select all those rows which you want to delete.
  2. Open the VBA editor (Pressing Alt+F11 keys on your keyboard).
  3. Click the first project from the left-hand pane.
  4. Navigate to the menu bar and select Insert >> Module.
  5. Paste the following code in the new window to select multiple cells for deletion:
    Sub Delete_Rows()
    ‘delete multiple rows (rows 4, 5 and 6)
    Worksheets(“Sheet1”).Range(“C4:C6”).EntireRow.Delete
    End Sub

Method 4>> Using a Shortcut key:

It is the easiest method to delete multiple rows at a time in Excel. Because it involves fewer steps than alternative methods.

  1. Select the targetted rows from your excel sheet.
  2.  Now you need to press Ctrl and – keys to delete the selected rows.
  3. This method is applicable to both multiple consecutive and non-consecutive rows.

Leave a Comment