Fast Way to Find and Delete Excel Rows

It’s finally summer, and you need to stay cool, even when you’re using Excel. Here’s an energy efficient way to select several rows that contain similar data, and delete them all at the same time.

Find All the Data

In the worksheet shown below, there are products sales, and a few of the records are for paper sales. I’d like to delete those rows, without having to sort the worksheet, or spend a long time manually selecting the rows.

FindAllDelete00

To find all the Paper sales rows, I can use the Find command.

  • On the Ribbon’s Home tab, click Find & Select, and then click Find.

FindAllDelete01

  • In the Find and Replace dialog box, type "paper" in the Find What box.
  • Click Find All, to see a list of cells with "paper"
  • Select an item in the list, and press Ctrl+A, to select the entire list, and to select all the "paper" cells on the worksheet.

FindAllDelete02

Delete the Selected Rows

To delete the entire row for each "paper" cell that was found:

  • On the Ribbon’s Home tab, click Delete, and then click Delete Sheet Rows.

All the selected rows are deleted, and the other product orders remain on the worksheet.

FindAllDelete03

Watch the Video

To see the steps to find all the instances of a word, and delete the selected rows, please watch this short Excel video tutorial.

___________