Table of Contents

Filter

Filter your Excel data to only display records that meet certain criteria. This is page 1 of 10 in our comprehensive filtering course.

1. Click any single cell inside a data set.

2. On the Data tab in the Sort & Filter group click Filter.

Filter Example

Arrows in the column headers appear.

Filter Arrows

3. Click the arrow next to Country.

4. Click on Select All to clear all the check boxes and click the check box next to USA.

Click USA

5. Click OK.

Result: Excel only displays the sales in the USA.

Filter in Excel

6. Click the arrow next to Quarter.

7. Click on Select All to clear all the check boxes and click the check box next to Qtr 4.

Click Qtr 4

8. Click OK.

Result: Excel only displays the sales in the USA in Qtr 4.

Filter in Excel

9. To remove the filter on the Data tab in the Sort & Filter group click Clear. To remove the filter and the arrows click Filter.

Clear Filter

There’s a quicker way to filter Excel data.

10. Select a cell.

Filter by Selection

11. Right click and then click Filter Filter by Selected Cell’s Value.

Filter by Selected Cell's Value

Result: Excel only displays the sales in the USA.

Filtered Data

Note: simply select another cell in another column to further filter this data set.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog