[GROUP] by accident, how to get rid of it???

[Guest]

It seems I've somehow keyboard shortcutted my way into a grouped spreadsheet.
I can't sort, I can't undo... I can still add to the spreadsheet though.

There are two different places I've looked for an 'undo group' button, both
are unlit so won't work.

I can't cut and paste into a new spreadsheet or all the problems come with
the paste.

Help! I can't do my work!

 

[Dave Peterson]

Rightclick on any of the grouped sheet tabs and select Ungroup.

But before you do, make a note of what sheets were grouped. Almost all the
changes you've made to any one of those grouped sheets have been made to the
others in that group.

You may want to check the other sheets to determine if you should close without
saving.