When you create a Pivot Table, it comes up with values for all the items that are available in the source data sheet. Hence, an important part of formatting a Pivot Table is to hide values that you believe are not important, likely to create confusion or distract from other important values in your Pivot Table report.
At any time, you can unhide previously hidden values in a Pivot Table by clicking on the Filter icon; located next to the Column Label under which the values are hidden.
Related: How to Replace Blank Cells with Zeros in Pivot Table.
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.