While the default option in Microsoft Excel is to show all possible values in a Pivot Table, it also provides the option to hide specific values that you do not want to show up in a Pivot Table.
This allows you to selectively hide values that you believe are not important, likely to create confusion or distract from other important values in your Pivot Table report.
1. 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.
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.
2. 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 in Pivot Table, 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.
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.