On Aug 19, 8:04 am, Richard wrote:
Hi, I am pulling my hair out on this one. I just switched toExcel2007and I
cannot figure out how to Ungrouprowswithout also Unhiding any hiddenrows
within thatgroup. I really need to be able toGroup/Ungroup without Unhidingrowsthat are unused. This was never a problem with my previous version ofExcel. The two commands were not linked. Thanks in advance.

Richard

Richard,
Launch Excel 2007, highlight your rows to group, then go to "Data" in
the Menu Bar at top, then in the ribbon below, look to the far right
in the "Outline" box. There will be "Group" and "Ungroup" icons...