View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default trying to delete a row in the pivot table for the pivot chart

You can't delete a row in the pivot table, but maybe you can use the
dropdown lists on the field buttons, to hide the item you don't want.
To hide the grand total row or column:
Right-click a cell in the pivot table
Choose Table Options
Remove the check mark from Grand Totals for Rows and/or Grand Totals for
Columns.
Click OK

babs wrote:
I would like to delete a row(s) in the pivot table and it will not let me.
Is there someway I can copy it and then delete the totals rows???



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html