| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel pivot record group
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 tabToolsConvert to Range In XL2003 it is DataListConvert to Range -- Regards Roger Govier "anna_717717" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Pivot Table - Group Field function is not always availa | Excel Worksheet Functions | |||
| how to add a record to a pivot table | Excel Worksheet Functions | |||
| How do I group record w/same info but different number in a row | Excel Discussion (Misc queries) | |||
| Can't group by dates in Excel 2003 pivot table | Excel Discussion (Misc queries) | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
