Excel.Tips.Net ExcelTips (Menu 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.

Tips, Tricks, and Answers

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.

Filtering Columns
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.


More Information

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.




Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.