Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what is a group excel file and how do i disable so i can sort it?
even when i copy and paste to a new worksheet it still holds onto the group
status so won't allow me to sort the data. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what is a group excel file and how do i disable so i can sort it?
"Group" can apply to worksheets which have been grouped together
(easily done by holding the CTRL key and clicking on another sheet tab). To get rid of this setting, right-click on a sheet tab and select Ungroup sheets. It could also apply to a number of columns in the same sheet which have been grouped together. To get rid of this setting you should highlight the offending columns then click on Data | Group and Outline | Ungroup. Then save the file so that you won't have the same problem next time you open it. Hope this helps. Pete On Mar 20, 2:14*pm, JR wrote: even when i copy and paste to a new worksheet it still holds onto the group status so won't allow me to sort the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offer a feature to disable the sort warning in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I disable the Excel Sort Warning? | Excel Discussion (Misc queries) | |||
VBA in Excel, Know a way to disable SORT without protectsheet? | Excel Discussion (Misc queries) | |||
Excel sort option disabled--file name followed by "group" at top . | Excel Discussion (Misc queries) | |||
Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel |