MS Excel 2007: How to Hide a Value in a Pivot Table
This Excel tutorial explains how to hide a value in a pivot table in Excel 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: How do I hide a value in a pivot table in Microsoft Excel 2007?
Answer: In this example, we are going to hide Order #10250.
Click on the arrow to the right of the Order ID drop down box and un-select the checkbox next to the 10250 value. Then click on the OK button.
The Order #10250 is now hidden.
Advertisements