Grouping sheets (clicking on one tab and ctrlclicking on subsequent tabs) is a
nice way to make the same change to each of the grouped sheets.
If you have headers that need to be updated in A1:A10 of sheet1, sheet3,
sheet18, you can select those (notice the grouped sheets have tabs that show
that they're selected), you can just type in A1 in any of those sheets.
Then A1 on all those sheets will be the same.
This can be very useful. But it's kind of dangerous. If you didn't notice that
the sheets were grouped and deleted rows 3:35356, you deleted them from all the
grouped sheets.
To ungroup them, just rightclick on any of the grouped sheets and select Ungroup
Sheets (or select a sheet not in the group).
Before you ungroup, make a note of what sheets were grouped. You'll know what
ones you have to check to see if they were, er, destroyed.
Good luck,
Several spreadsheets have [Group] after the document name in the title bar.
I cannot find how it has occurred and the owner of the document have sworn
they have not done anything different.
It causes the sort options to be unusable. Any suggestions on how to remedy
the
situation
