excel pivot record group



I'm using Excel on a Mac.
I created a pivot table from some data on a worksheet.
I deleted the pivot table but the original data is now 'grouped'- there is a
border around the data.
I tried to apply an autofilter to one column only but it applied it to all
the data that was used for the pivot table.
Is there any way I can 'ungroup' the data?



Roger Govier

Hi Anna

I have no experience with a Mac
In XL2007, once a Table has been created, if you click anywhere in the
Table, then in the Table tools Design tab>Tools>Convert to Range
In XL2003 it is Data>List>Convert to Range

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