MS Excel 2010: How to Hide a Value in a Pivot Table
This Excel tutorial explains how to hide a value in a pivot table in Excel 2010 (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 2010?
Answer: In this example, we are going to hide Order #10249.
Click on the arrow to the right of the Order ID drop down box and un-select the checkbox next to the 10249 value. Then click on the OK button.
The Order #10249 is now hidden.
Advertisements