How To Delete Multiple Rows in Excel Sheet at Once

Delete multiple rows in Excel is a task that is done while performing data cleanup. The data cleanup process may be required when we get a dataset from the team we are working with or the vendor with whom we have corporate relations or we ourselves want to perform some predictive analysis in Excel

Why do you need to delete rows in excel?

You need to remove a certain segment of data that is not important or there are endless blank cells that you need to delete to evaluate the data or cleaning up the datasheet and making it ready to structure the data. 

When you bring data from another source to the Excel worksheet, the imported data contains unwanted blank rows / columns in between and you want to erase them. 

You may want to delete multiple rows in Excel which are irrelevant data. When dealing with large data sets, you will need to delete multiple rows quickly to save time. As working with large data in the Excel sheet requires a lot of time performing the steps. It is necessary to know shortcuts and perform the steps faster to finish the task quickly.

Delete Multiple Rows in Excel at Once

1. Delete Multiple Rows in Excel Using Shortcut

  1. Open a Microsoft Excel sheet containing a dataset.
  2. Filter the data to get the subset. 
  3. Once filtered, you can select the unwanted rows.
empty cells
  1. Press CTRL + – to remove the selected rows.

2. Delete Multiple Rows in Excel by Right-Click

  1. Open a Microsoft Excel sheet containing a dataset.
  2. Filter the data to get the subset. 
  3. Once filtered, you can select the unwanted rows.
  4. Right-click and select Delete.
delete

2. Delete Multiple Rows in Excel by Go To Special

  1. Open a Microsoft Excel sheet containing a dataset.
  2. On the icon toolbar, click Find & Select.
Find Select.
  1. A menu appears with the list of options. Choose Go To Special.
go to special
  1. From the dialog box, choose Blanks and OK.
blanks in excel
  1. Blank cells are selected choosing the above option. 
blanks
  1. Choose Delete.
delete sheet rows
  1. From the list of options that appear, choose Delete Sheet Rows.
delete sheet rows
  1. All blanks with rows are deleted. The sheet will be cleaned up as shown below.
Data on Sheet

FAQ:

  • What is Data Filtration?

Filtering is a fast and simple way to locate and run a subset of data within a range.

  • What is Data Sorting?

Data sorting is the method of organizing data in a logical order. MS Excel helps you to sort data in ascending or descending order. You can also define the order of sorting the data. 

  • What is Formula Auditing?

Using formula auditing, we can graphically view or trace the relationship between cells and formulas with blue arrows. 

  • What is Add-ins and Macros?

Excel offers a variety of add-ins to use certain tasks and calculations. One of them is Analysis ToolPack. For doing calculations of mathematical formulas and running regressions, this add-in is very useful. Running Macros using VBA editor in Excel works as a programming application. You can perform some repeated actions in your dataset using Macros. It is just awesome.