![]() |
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? |
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? |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com