Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am not sure what I have done but I can no longer group cells (using the
green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do not recognize "green arrows on the toolbar".
What function/feature are you referring to? Merging cells maybe? Can you post back with a better description please. Gord Dibben MS Excel MVP On Fri, 11 Aug 2006 04:13:01 -0700, ec8spe wrote: I am not sure what I have done but I can no longer group cells (using the green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the worksheet is protected or the workbook is shared, you won't be
able to group the rows. ec8spe wrote: I am not sure what I have done but I can no longer group cells (using the green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Debra
You seem to have figured out what/where the "green arrows" are. Can you give me a hint please? Thanks, Gord On Fri, 11 Aug 2006 20:31:49 -0400, Debra Dalgleish wrote: If the worksheet is protected or the workbook is shared, you won't be able to group the rows. ec8spe wrote: I am not sure what I have done but I can no longer group cells (using the green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? Gord Dibben MS Excel MVP |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Gord,
You can see them in DataGroup and OutlineGroup, or could customize a toolbar, to show the Group and Ungroup buttons. Debra Gord Dibben wrote: Debra You seem to have figured out what/where the "green arrows" are. Can you give me a hint please? Thanks, Gord On Fri, 11 Aug 2006 20:31:49 -0400, Debra Dalgleish wrote: If the worksheet is protected or the workbook is shared, you won't be able to group the rows. ec8spe wrote: I am not sure what I have done but I can no longer group cells (using the green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? Gord Dibben MS Excel MVP -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I guess there are features of Excel I just don't use much and we found another
one<g Thanks On Fri, 11 Aug 2006 20:45:44 -0400, Debra Dalgleish wrote: Hi Gord, You can see them in DataGroup and OutlineGroup, or could customize a toolbar, to show the Group and Ungroup buttons. Debra Gord Dibben wrote: Debra You seem to have figured out what/where the "green arrows" are. Can you give me a hint please? Thanks, Gord On Fri, 11 Aug 2006 20:31:49 -0400, Debra Dalgleish wrote: If the worksheet is protected or the workbook is shared, you won't be able to group the rows. ec8spe wrote: I am not sure what I have done but I can no longer group cells (using the green arrows on the toolbar). What might I have inadvertantly done to cause this and how can I rectify it? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
concatenating rows from different sheets | Excel Worksheet Functions | |||
format group of rows based on condition | Excel Discussion (Misc queries) | |||
How do I group rows prior to a data sort so they stay together? | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Unable to group rows or columns on an excel worksheet | Excel Discussion (Misc queries) |