Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel sort option disabled--file name followed by "group" at top .
I received a file an excel file which I cannot sort. When I look at the file
in an excel window, I noticed that "group" appears after the name on the top of the window. Is this relevant to why I cannot sort and if so, how do I get rid of it? |
#2
|
|||
|
|||
Hi
Group indicates that you have more than one sheet selected. Right click on the sheet tab and click Ungroup Sheets. Any changes you have made to that sheet will have been made to the other sheets too. -- Andy. "Margaret" wrote in message ... I received a file an excel file which I cannot sort. When I look at the file in an excel window, I noticed that "group" appears after the name on the top of the window. Is this relevant to why I cannot sort and if so, how do I get rid of it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubel with compression of a very large Excel file | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |