HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Hide a value in a pivot table in Excel 2007

Also learn how to hide a value in a pivot table in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Question:  How do I hide a value in a pivot table in 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.