What does [Group] mean at the end of a file name ?

[Guest]

All of a sudden an important file I use regularly has started opening with
[Group] at the end of the file name. As a result certain features such as
Goal Seek can not be used on any cells in the spreadsheet. How did this
happen and how do I "un-do" it ?

 

[Guest]

Groups means your tabs are grouped together. Right click on one of the tabs
and select "ungroup."

Dave

 

[Gord Dibben]

This means you more than one worksheet selected.

On the sheet tab bar you will see that two or more sheet tabs are white in
color.

Those sheets are grouped.

Quite a handy feature if you want to do the same thing to several sheets at
once, like insert rows or format some cells etc.

Right-click and "ungroup" or select a sheet that is not in the group.

NOTE: have a good look at the sheets that were grouped.

What you have done to one will be done to all.

Can lead to some interesting but unwanted changes if you did not know the sheets
were grouped.


Gord Dibben MS Excel MVP