Filter in Excel

You can filter your data in Excel if you only want to display records that meet certain criteria. To filter your data, execute the following easy steps.

1. Click any single cell inside the data set.

2. Click on the Data tab and then click Filter.

Arrows in the column headers appear.

3. Now for example, click on the arrow next to Country.

4. Click on Select All, to clear all the checkboxes. Next, click the checkbox next to USA.

5. Click on OK.

Result. Excel only displays the sales in the USA.

6. You can go one step further. To display the sales in the USA in a specific quarter, click on the arrow next to Quarter and select a quarter.

7. To remove the arrows (which will remove the filter as well), click on Filter from the Data tab again.

Did you like this free Excel tutorial? Show your appreciation, vote for us.

Thank you very much! We've got many more free Excel tutorials for you. Read on, learn, and enjoy!

Go to Top: Filter in Excel    |    Go to Next Tutorial: Hide Columns or Rows