MS Excel 2003: How to Display a Hidden Value in a Pivot Table
This Excel tutorial explains how to unhide a value in a pivot table in Excel 2003 and older versions (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: How do I display a hidden value in a pivot table in Microsoft Excel 2003/XP/2000/97?
Answer: To explain how to display a hidden value in an Excel pivot table, we'll take a look at an example. In this case, the entry for Order ID 10249 is hidden.
Click on the arrow to the right of the field that has the hidden value. In this example, the field that has the hidden value is called Order ID, so we'll click on the arrow to the right of the Order ID field.
Check the box to the left of the value that you want to display. Click on the OK button. In this example, we've checked the box for Order ID 10249.
Just to summarize, all checked values are visible in the pivot table and all unchecked values are hidden in the pivot table.
Now when we return to the pivot table, we can see the details for Order ID 10249.
Advertisements