![]() In our case, we have selected the checkbox next to item “Monitors’ in order to unhide and show this item in our Pivot Table. ![]() ![]() 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. 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. Now, when you view the Pivot Table, you won’t be able to see the Value or Item that you had unchecked. In our case, we are hiding the item “Monitors” by unchecking this item. 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.ģ. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |