To apply filters to a range, select the dataset and go to the Home tab > Editing group > Sort and Filter icon > Filter or press the Ctrl + Shift + L keys. With non-Excel Tables, the filters will have to be added. You can apply any of the methods in this guide for deleting rows whether the data is in an Excel Table or not. If your dataset is in the form of an Excel Table (can be applied from the Format as Table options in the Styles group from the Home tab), the columns will automatically have filter controls. The data may need to be filtered for analysis. Let’s go through an example and see what presets make it usable:Ībove we have sample data from a superstore. Deleting Hidden Filtered Rows Using VBA.Deleting Hidden Filtered Rows Using Inspect Document.Deleting Hidden Filtered Rows Using a Temporary Column.Deleting Visible Filtered Rows Using VBA.
But before the big works, we need to get easy with filtering. The flip side of that is deleting hidden filtered rows using a temporary column, the Inspect Document feature, and VBA. On agenda is deleting visible filtered rows using filters and VBA. In this tutorial, we look at deleting filtered rows. For any of these, you may find that you need to filter and delete data. Preparing an extract, dealing with a ceased product or location, analysis, and comparison, specific calculations. Or maybe you applied a million filters to sift your required data and want to delete the rest. Once you’ve sifted the redundant data, you might want to delete it. Now how do you divide what is relevant from what is not from a sea of data? You filter it, that’s right! Excel filters provide a decent range of preset text and number filters and you can explore it all if you’re interested but today our focus is on one step ahead of filtering. Data is something very crucial and you may need to keep logs of everything for some very rainy day but sometimes you need to sift the irrelevant material out.