How to Filter your data in Excel?

  Excel tutorials

Do you know How to Filter your data in Microsoft Excel?

Today, we are going to show you How to Filter your data in Microsoft Excel?

Filter your Excel data if you only want to display records that meet certain criteria.

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 Arrrows

3. Click the arrow next to the Country.

4. Click on Select All to clear all the check boxes, and click the check box next to the 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

LEAVE A COMMENT