"Group" and sorting data

[Joel Bergsman]

One of my Excel spread sheets somehow (?) acquired the
word "group" in its name, and many menu choices
disappeared -- including the sort function.

How do I get out of this "group" thing and regain the
missing menu functions, including sort?

Thanks

 

[Andy Brown]

"Joel Bergsman",

You have more than one sheet selected. If you have any non-white sheet tabs
click one of them. Else rightclick one of the white tabs and choose Ungroup
Sheets.

Rgds,
Andy

 

[acw]

Joel

Have a look at the sheet tabs at the bottom. If they are
all highlighted and the sheet name has [Group] attached,
then just press one of the sheets and it will release the
grouping.

Tony