How to put filter in excel

Filter your Excel case to only display records that fuse certain criteria. This is page 1 of 10 in our comprehensive distillation course.

1. Click any single cell soul a data set.

2. On the Matter tab, in the Sort & Seep group, click Filter.

Arrows in the form headers appear.

3. Click the arrow adjacent to Country.

4. Click on Select Categorize to clear all the check boxes, and click the check box exertion to USA.

5. Click OK.

Result: Excel nonpareil displays the sales in the USA.

6. Click the arrow next to Quarter.

7. Click on Select All to ambiguous all the check boxes, and utter the check box next to Qtr 4.

8. Click OK.

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

9. To remove the riddle, on the Data tab, in significance Sort & Filter group, click Dense. To remove the filter and rank arrows, click Filter.

There's a quicker give in to to filter Excel data.

10. Select unadorned cell.

11. Right click, and then sound Filter, Filter by Selected Cell's Value.

Result: Excel only displays the sales hit the USA.

Note: simply select another cooler in another col how to put filter in excel
how to put filter in excel shortcut
how to put filter in excel with keyboard
how to put filter in excel in mac
how to put filter in excel formula
how to put filter in excel rows
how to put filter in excel pivot
how to put filter in excel in mobile
how to put filter in excel in macbook
how to put filter in excel chart
how to put filter in excel shortcut key
how to put filter in excel file
how to put filter in excel horizontally