Filter
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 Filter Example](https://www.excel-easy.com/data-analysis/images/filter/filter-example.png)
Arrows in the column headers appear.
![Filter Arrrows Filter Arrrows](https://www.excel-easy.com/data-analysis/images/filter/filter-arrows.png)
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 Click USA](https://www.excel-easy.com/data-analysis/images/filter/click-usa.png)
5. Click OK.
Result. Excel only displays the sales in the USA.
![Filter in Excel Filter in Excel](https://www.excel-easy.com/data-analysis/images/filter/filter-result.png)
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 Click Qtr 4](https://www.excel-easy.com/data-analysis/images/filter/click-qtr4.png)
8. Click OK.
Result. Excel only displays the sales in the USA in Qtr 4.
![Filter in Excel Filter in Excel](https://www.excel-easy.com/data-analysis/images/filter/filter-result-2.png)
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 Clear Filter](https://www.excel-easy.com/data-analysis/images/filter/clear-filter.png)
No comments:
Post a Comment