Pivot Table- force rows with no data to be hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to force rows in a Pivot Table to be hidden? Thanks.

Best Regards,
Dean
 
You can filter the grand total values in Excel 2007. In earlier versions
that feature isn't available. You could manually hide the rows, or start
an AutoFilter outside of the pivot table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Question on the occupied field of the pivot table in excel spreadsheet 0
View Pivot Table Source data as a Data Table 6
Pivot Table Refresh 1
pivot table in Excel 2007 & 2000 (backward compatibility problem) 3
Adding to an existing Pivot Table 7
Pivot Table update 8
Pivot using 250,000 rows of data in Excel? 1

Back
Top