How do I eliminate Group on spreadsheets?

G

Guest

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?
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
G

Guest

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!
 
R

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
 
R

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top