Tips & Tricks‎ > ‎Excel Tips‎ > ‎

Filter by the Selected Cell

posted Jan 30, 2011, 6:52 AM by Ayush Jain
Excel 2007 added the feature to filter table fields by the selected cell.

What does this mean?

Focus on analyzing data instead of defining filter criteria each time.

This quick filter method is ideal for selecting categories, for example: cities, products, subjects, suppliers, etc.

You can filter by:
  • Cell's value
  • Cell's color
  • Cell’s font color
  • Cell's icon
How to…

1. Select the cell on which you want to apply the filter or right click directly on it.

2. Go to: Filter>Filter by Selected Cell’s value

3. Click