View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default [GROUP] by accident, how to get rid of it???

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.

RiDunc1 wrote:

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