excel
 

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

excel
 

Just right-click on any of the grouped* sheets Ungroup

*these will appear "white"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"neil in cornwall" <neil in wrote in
message ...
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?????

excel
 

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

excel
 

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

excel
 

Right-click any sheet tab

If it was a grouped sheet.....UNGROUP will list first (select it)

If it was NOT a grouped sheet....the sheets will UNgroup (so you're done)

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

XL2002, WinXP


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

excel
 

Sorry, the description earlier should read as: "sheet tabs"
Just right-click on any of the grouped* sheet tabs Ungroup
*these will appear "white"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

excel
 

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