Label Filter in Excel

Summary

How to use the Label Filter in Excel?

Body

Question

How to use the Label Filter in Excel?

Answer

Using different filters, you have the ability to filter the report to specified criteria. Click on a cell in column A (row labels) and Right-click and point to Filter, and then select Label Filters.

The Label Filter (Subject) dialog box will appear.  
                                                                                                     
The report shows data now limited by the filtered set.  To clear the date filter, right-click in the filtered celll, point to Filter and click on Clear Filter from Subject. 

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.

Details

Details

Article ID: 7977
Created
Fri 12/30/22 2:11 PM
Modified
Fri 11/3/23 5:09 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

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.