Excel sort option disabled--file name followed by "group" at top .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filename displayed followed by [Group] 1
Excel Excel spreadsheets opening at top instead of bottom. 4
group data in wksht columns for sorting purposes. 2
My Excel 2007 filename is followed by [Group]. Why? 1
Sort on opening a file 2
Matching Names 5
How do I sort pivot table data by subtotals? 2
sorting customer name and IP with value 1

Back
Top