This will show you all the number related filter options in Excel. Hover the cursor over the Number Filters option.Click on the Filter icon in the Sales header cell (this is a small downward-pointing triangle icon at the top-right of the cell).Just as I used the filter method to delete all the rows that contain the text Mid-West, you can also use a number condition (or a date condition).įor example, suppose I have the below dataset and I want to delete all the rows where the sale value is less than 200. You can use the methods shown later in this tutorial (using the Sort method or the Find All Method) Delete Rows Based on a Numeric Condition Once done, copy it back in place of the original data. One way to get around this is to create a copy of the data in another worksheet and delete the rows in the copied data. Note that when you delete a row, anything that you may have in other cells in these rows will be lost. Once you have the text based on which you want to filter, hit the Enter key.
![how to clear formatting in excel and leave the content how to clear formatting in excel and leave the content](https://cdn.extendoffice.com/images/stories/doc-excel/protect-sheet-format/doc-protect-format-02.png)
In case you have a lot of categories/regions, you can type the name in the field right above the box (that has these region names), and Excel will show you only those records that match entered text (as shown below). In the above example, I had only four distinct regions and I could manually select and deselect it from the Filter list (in steps 5 above).
![how to clear formatting in excel and leave the content how to clear formatting in excel and leave the content](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/06/21152009/563.png)
Suppose you have a data set as shown below and you want to delete all the rows where the region is Mid-west (in Column B). Let’s see two examples where you can filter the rows and delete them. Once you have the filtered data, you can delete all these rows (while the remaining rows remain intact).Įxcel filter is quite versatile and you can filter based on many criteria (such as text, numbers, dates, and colors) One of the fastest ways to delete rows that contain a specific value or fulfill a given condition is to filter these. Filter and Delete Rows Based On Cell Value (using VBA)įilter Rows based on Value/Condition and Then Delete it.Find and Select the Cells Based on Cell Value and Then Delete the Rows.Sort the Dataset and Then Delete the Rows.Delete Rows Based on a Numeric Condition.Delete Rows that contain a specific text.Filter Rows based on Value/Condition and Then Delete it.