The grouped sheets will have white tab colors.

If all white, meaning all are grouped, select any sheet that is not the active
sheet and ungrouping will occur.

Note: while sheets are grouped, most of what you do to one will be done to all.

If you don't know how long they have been grouped, suggest you have a good look
at each sheet...........you may have inadvertantly made a few changes you did
not want.


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 07:09:01 -0800, neil in cornwall
wrote:

hi Ron
when i right click i dont see un group but i do see veiw code

"Ron Coderre" wrote:

Excel is not-so-subtley telling you that you have at least 2 sheets grouped.
Grouping can be handy for effecting the same change through multiple sheets
at once (eg putting the same text in cell A1 of all grouped sheets). However,
when sheets are grouped, some functionality is disabled....Sorting is one.

To fix the problem:
Right-click on one of the sheets within the group and select: Ungroup
OR
Just click on any sheet tab NOT in the group.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"neil in cornwall" wrote:

when i sent an excel spread sheet from home to work the sort function is no
longer available the header of the page has now got [GROUP] at the end of the
title can any one help?????