How do I eliminate Group on spreadsheets?

[AnneHenderson1]

I can no longer sort data on my spreadsheets. The word "group" appears after
the filename. I don't know how or why group appears but it prevents the data
sort. How do I prevent this or turn it off?

[Peo Sjoblom]

Right click a sheet tab and select ungroup, save the file

--
Regards,

Peo Sjoblom

(No private emails please)


"AnneHenderson1" <[email protected]> wrote in message
news:[email protected]...
>I can no longer sort data on my spreadsheets. The word "group" appears
>after
> the filename. I don't know how or why group appears but it prevents the
> data
> sort. How do I prevent this or turn it off?

[sir Lancelot]

Group means that the tabs on the lower left section of the window are
highlighted. Just click on a tab that is not highlighted and this will
remove the grouping.
Hope this helps!

"AnneHenderson1" wrote:

> I can no longer sort data on my spreadsheets. The word "group" appears after
> the filename. I don't know how or why group appears but it prevents the data
> sort. How do I prevent this or turn it off?

[Rowan Drummond]

The "Group" is indicating that you have more than one sheet selected.
The selected sheet tabs should be white. Either click on any other sheet
tab or right click one of the white tabs and select Ungroup sheets.

NOTE: while the sheets have been grouped any changes you have made will
have affected all grouped sheets so check carefully that you have not
inadvertently made unwanted changes.

Hope this helps
Rowan

AnneHenderson1 wrote:
> I can no longer sort data on my spreadsheets. The word "group" appears after
> the filename. I don't know how or why group appears but it prevents the data
> sort. How do I prevent this or turn it off?

[Ragdyer]

This means your worksheets are "grouped" together, meaning whatever you do
to one, will also be done to all the other sheets in the group.

The sheet tabs of the grouped sheets are white, while the main sheet of the
group in focus is also in bold.

To break the group, either click in a sheet tab that's not grouped, or right
click in a grouped sheet tab and choose "Ungroup Sheets".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AnneHenderson1" <[email protected]> wrote in message
news:[email protected]...
> I can no longer sort data on my spreadsheets. The word "group" appears
after
> the filename. I don't know how or why group appears but it prevents the
data
> sort. How do I prevent this or turn it off?

[AnneHenderson1]

Thanks to all who answered. I can now sort and really appreciate the quick
response.

"AnneHenderson1" wrote:

> I can no longer sort data on my spreadsheets. The word "group" appears after
> the filename. I don't know how or why group appears but it prevents the data
> sort. How do I prevent this or turn it off?