tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Hide zero value lines within a pivot table in Excel 2007

See solution in other versions of Excel:

Question: Is there a way to hide zero valued lines within a pivot table in Microsoft Excel 2007? i.e. I have a table with two columns branch name and stock value and I would like to hide the branches with no value 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 STOCK VALUE field from the "Choose fields to add to report" box to the Report Filter section. You should now see a STOCK VALUE drop down appear in row 1.

Microsoft Excel

Click on the arrow to the right of the STOCK VALUE (All) drop down box and un-select the checkbox next to the 0 value. Then click on the OK button.

Microsoft Excel

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

Microsoft Excel