![]() |
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 |
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 |
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 |
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