Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I can no longer Group rows

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default I can no longer Group rows

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default I can no longer Group rows

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default I can no longer Group rows

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default I can no longer Group rows

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default I can no longer Group rows

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenating rows from different sheets ExcelWolfie Excel Worksheet Functions 1 January 27th 06 05:31 PM
format group of rows based on condition Aaron Excel Discussion (Misc queries) 0 January 10th 06 12:29 AM
How do I group rows prior to a data sort so they stay together? Linda Mills Excel Discussion (Misc queries) 4 August 17th 05 08:28 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM
Unable to group rows or columns on an excel worksheet Christine - HCVT Excel Discussion (Misc queries) 4 August 3rd 05 04:23 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"