Show or hide your PivotTable’s grand totals

by Kara Soos

Application:

Microsoft Excel 2000/2002/2003/2004/2007

Operating Systems:

Microsoft Windows, Macintosh

 

When I create a PivotTable, it automatically adds grand totals to both the columns and the rows. Is there a way to eliminate the column totals so my PivotTable shows only grand totals for each row?

 

Terrence Greene

Marketing Manager

Scottsdale, Ariz.

 

You don’t always need totals for both columns and rows. For example, the Grand Total row in the PivotTable shown in Figure A isn’t necessary because you won’t need to know the total of your accounts’ end balances over the first six months. But the Grand Total column is helpful because it tells you the end balance of all three accounts combined for each month.