MS EXCEL 2010: HIDE ZERO VALUE LINES WITHIN A PIVOT TABLE

From: http://www.techonthenet.com/excel/pivottbls/hide_blanks2010.php

MS EXCEL 2010: HIDE ZERO VALUE LINES WITHIN A PIVOT TABLE

This Excel tutorial explains how to hide zero value lines within a pivot table in Excel 2010 (with screenshots and step-by-step instructions).

See solution in other versions:

Question: Is there a way to hide zero valued lines within a pivot table in Microsoft Excel 2010? i.e. I have a table with two columns Order ID and Total (Sum of Quantity) and I would like to hide the Orders with no quantity total against them – is this possible?

Answer: Let’s look at an example. Below is a spreadsheet that contains values that are zeros. We want to hide these lines from being displayed in the pivot table.

Microsoft Excel

Drag the Quantity field from the “Choose fields to add to report” box to the Report Filter section. You should now see a Quantity drop down appear in row 1.

Microsoft Excel

Click on the arrow to the right of the Quantity (All) drop down box and a popup menu will appear. Check the “Select Multiple Items” checkbox. Then un-select the checkbox next to the 0 value and click on the OK button.

Microsoft Excel

Now when you return to the spreadsheet, the zero lines should be hidden.

Microsoft Excel

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s