MS Excel 2011 for Mac: How to Hide a Value in a Pivot Table
This Excel tutorial explains how to hide a value in a pivot table in Excel 2011 for Mac (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 2011 for Mac?
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 X in the top left to close the Order ID window.
The Order #10249 is now hidden.
TIP: You will see the filter icon 
appear next to the Order ID heading when the value has been hidden.
appear next to the Order ID heading when the value has been hidden.
Advertisements