Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |