• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Hide and Unhide Values in Pivot Table

How to Hide and Unhide Values in Pivot Table

By: Waseem Patwegar

In case you do not want a certain value or values appearing in Pivot Table, you can hide them. In this tutorial, you will find the steps to hide and unhide values in Pivot Table.

Hide and Unhide Values in Pivot Table

Hide Values in Pivot Table

Follow the steps below to Hide Values in Pivot Table.

1. First, identify the Items or Values that you want to hide in Pivot Table. In our case, we are going to hide the Value located in Row Number 8 under Column A.

2. Next, click on the Down Arrow located to the right of the Label under which the item or value that you want to hide is located.

Hide Values or Items in Pivot Table

3. In the Drop-down, unselect the checkbox next to the Item or Value that you want to hide and click on OK to save this setting. In our case, we are hiding the item “Monitors” by unchecking this item.

Now, when you view the Pivot Table, you won’t be able to see the Value or Item that you had unchecked.

Unhide Values in Pivot Table

Whenever a Pivot Table contains a hidden value or values, you will see a Filter Icon next to the Column Label containing the hidden value, which makes it easy to identify the location of hidden values.

To Unhide Values, click on the Filter icon next to the Label under which the values are hidden. In the drop-down menu, select the check box next to the Hidden Value/Values and click on OK.

Unhide Vales or Items in Pivot Table

In our case, we have selected the checkbox next to item “Monitors’ in order to unhide and show this item in our Pivot Table.

Once you Unhide Items or Values in Pivot Table, you will no longer see the “Filter icon” next to the Column heading under which the values were previously hidden.

Related
  • How to Change Pivot Table Data Source and Range
  • How to Add or Remove Subtotals in Pivot Table

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved