Ungroup a pivot table in XL 2000

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I have a pivot table with dates grouped by month.

In XL2002, if I want to ungroup them, I can use the PivotTable toolbar. I
also have to do this in XL2000, but I don't see the same tool bar.

How do you ungroup a pivot table in XL2000?
 
You can right-click on the field button in the pivot table, and choose
'Group and Outline'.

OR, select the cell that contains the field button
 

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 ungrouping on refresh? 3
Excel 2007: Pivot sharing same cache? 1
2007 Pvt Group/Ungroup symbols 3
XL2007 - Pivot Table Limitations 2
Grouping dates in pivot table 3
pivot table data 2
XL2000 Pivot Table - Show Pages 2
Group in Multiple Pivot table 1

Back
Top