Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
Excel has a filtering tool that allows you to easily filter a data list while working with large amounts of data. Knowing how to properly use this tool is central to fully utilizing Excel's capabilities. The following articles about the filtering tool will help you determine how to best use it in Excel.
The following articles are available for the 'Filtering' topic. Click the article's title (shown in bold) to see the associated article.
Counting Filtered Rows
The filtering capabilities of Excel are indispensable when working with large sets of data. When you create a filtered list, you might want to know how many rows are displayed in that list. Here's a variety of methods you can use.
The filtering tools provided in Excel make it easy to filter a data list so that only certain rows are displayed. What if you want to filter your information so that only certain columns are displayed, however? Excel doesn't provide a direct way to do this, but there are several workarounds you can adapt to your needs.
Filtering for Comments
Excel makes it easy to filter a data table based on various values in that table. It isn't so easy to filter according to whether a cell contains comments or not. Here's a few ways you can make the filtering easier.
Hiding Graphics when Filtering
Excel allows you to set up graphics so that they are associated with cells and even stay with the cells when the cells are sorted. But what about when you filter the list? Here's how to make sure that the graphics are no longer visible when the list is filtered.
Recalculating when Filtering
Filter a large worksheet, and Excel will helpfully recalculate every time you apply a different filter. This can get bothersome, particularly if the recalculation stops you from doing what you want to do in the worksheet. There is a way to handle this, involving turning the calculation on and off, as desired.
Removing Duplicates Based on a Partial Match
Some types of data may have certain fields that contain partially identical information. In such cases you may want to delete cells where those matches occur. Here's some ideas on how to approach the problem.
Sorting or Filtering by Conditional Format Results
Conditional formatting is a great feature in Excel. Unfortunately, you can't sort or filter by the results of that formatting. Here's why.
The following are additional topics related to the subject of Filtering. A bracketed number after the topic indicates how many articles are related to that subject.