ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   grouping (https://www.excelbanter.com/excel-programming/333660-grouping.html)

Steve

grouping
 
how exactly does this grouping function work? does it only group those
specific cells?

the reason i ask is that i have cells grouped, but now i want to sort them.
and the grouping doesn't move with the data, it just stays. is there a way i
can get the grouping to follow the data as it is sorted?

thanks,
steve


Anne Troy[_2_]

grouping
 
Are you talking about merged cells? Or are you talking about Data--Group
and Outline?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"steve" wrote in message
...
how exactly does this grouping function work? does it only group those
specific cells?

the reason i ask is that i have cells grouped, but now i want to sort

them.
and the grouping doesn't move with the data, it just stays. is there a

way i
can get the grouping to follow the data as it is sorted?

thanks,
steve




Steve

grouping
 
Data/Group


"Anne Troy" wrote:

Are you talking about merged cells? Or are you talking about Data--Group
and Outline?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"steve" wrote in message
...
how exactly does this grouping function work? does it only group those
specific cells?

the reason i ask is that i have cells grouped, but now i want to sort

them.
and the grouping doesn't move with the data, it just stays. is there a

way i
can get the grouping to follow the data as it is sorted?

thanks,
steve





Anne Troy[_2_]

grouping
 
Then you should ungroup your cells before you sort again. Subtotals,
grouping/outline, and autofilters are really designed for temporary use.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"steve" wrote in message
...
Data/Group


"Anne Troy" wrote:

Are you talking about merged cells? Or are you talking about

Data--Group
and Outline?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"steve" wrote in message
...
how exactly does this grouping function work? does it only group

those
specific cells?

the reason i ask is that i have cells grouped, but now i want to sort

them.
and the grouping doesn't move with the data, it just stays. is there

a
way i
can get the grouping to follow the data as it is sorted?

thanks,
steve








All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com