View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
anna_717717 anna_717717 is offline
external usenet poster
 
Posts: 8
Default excel pivot record group

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?