excel pivot record group

A

anna_717717

Hi,
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?
 
R

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

Similar Threads

Pivot Table - Changes 5
Can't open pivot table field list 1
Access #Error & Excel Pivot 0
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Update 3
Adding to an existing Pivot Table 7
Question on the occupied field of the pivot table in excel spreadsheet 0

Top