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 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.