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

Details

Article ID: 7981
Created
Fri 12/30/22 1:50 PM
Modified
Fri 11/3/23 4:10 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

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.