Here is a link to the page More Find and Replace Examples To see the steps to find all the instances of a word, and delete the selected rows, watch this short Excel video tutorial. On the Ribbon’s Home tab, click Delete, and then click Delete Sheet Rows.Īll the selected rows will be deleted, and the other product orders remain on the worksheet.To delete the entire row for each “paper” cell that was found, follow these steps: That will also select all the “paper” cells on the worksheet. Select an item in the list, and then press Ctrl+A, to select the entire list.Click Find All, to see a list of all the cells that contain the text, “paper”.In the Find and Replace dialog box, type “paper” in the Find What box.On the Ribbon’s Home tab, click Find & Select, and then click Find.To find all the Paper sales rows, I can use the Excel Find command. I’d like to delete those paper sales rows, without having to sort the worksheet, or spend a long time manually selecting the rows.
In the worksheet shown below, there is a list of products sales, and a few of the records are for paper sales. You can select several rows that contain similar data, and delete them all at the same time. Here’s an energy-efficient and fast way to find and delete Excel rows.
It’s finally summer, and you need to stay cool, even when you’re using Excel.
