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:
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