Filter in Excel

If you want Excel to display only records that meet certain criteria, then use a filter. For this:

1. Click on any cell in the dataset.
2. On the Advanced tab Data (Data) click Filter (Filter). Arrows appear in the column headings.
3. Click on the arrow next to the title Country.
4. Click on the line Select all (Select All) to clear all checkboxes, then check the box USA.
5. Press OK.Result: Excel only shows US sales data.
6. Click on the arrow next to the title Quarter.
7. Click on the line Select all (Select All) to clear all checkboxes, then check the box Qtr 4.
8. Press OK.Result: Excel only shows fourth quarter US sales data.
9. To cancel filtering, on the tab Data (Data) click Clean (clear). To remove the filter completely, i.e. remove the arrows, press the button again Filter (Filter).