Filter by Label Filters in Excel

Question

How to filter by Label Filters in Excel?

Answer

To do this simply right click on the name of the item, select Filter, and select Label Filters.  A dialog box will appear titled Label Filter.  To the left you will see the dropdown arrow, select Equals.  Next type in the item's name you are seeking to pull out and click OK. 
                                                                                      
To remove the filter, just right click on the name, and select Clear Filter from Item.

For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.