How To Mass Delete Multiple Rows Of Data In Excel

Home » How To Delete Multiple Rows In Excel » How To Mass Delete Multiple Rows Of Data In Excel

Maybe your like

  • Facebook
  • X
  • Pinterest
  • Reddit
  • Microsoft Teams
  • Email
  • LinkedIn
  • Copy Link
  • Print

In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there are several ways you can delete individual rows as well as thousands. Here we are going to demonstrate several ways this can be done.

Mass Delete Data after row using shortcuts

Let’s say you have a data set in which you want to delete all data past row 10. This can easily be done by using the following shortcut.

CTRL Shift ↓

Mass Delete Rows in Excel

Filter then Delete Rows

Sort the data

Uncheck the Data you want to keep. Click OK

Now you can delete the remaining data.

  • Facebook
  • X
  • Pinterest
  • Reddit
  • Microsoft Teams
  • Email
  • LinkedIn
  • Copy Link
  • Print

Tag » How To Delete Multiple Rows In Excel