Hidden Data in Excel

Question

How to hide data in Excel?

Answer

You do have the option within the pivot table to hide some of the information without actually removing it from the table. 

  1. Right click on the item name.  
  2. Next, select Filter and select Hide Selected Items.  You will notice the item is no longer on the table.  
  3. To retrieve the data back just right-click again in any name category, 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.

CTL Support Request

Details

Article ID: 7982
Created
Fri 12/30/22 1:52 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.