Hide/Unhide vs Group/Ungroup - Need Help
I don't use XL07, so this is just a guess.
If rows 3 to 10 are grouped and compressed (hidden),
select Row 2 and drag down 1 row to select Row 11 also, then:
<Shift <Alt <LeftArrow
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Richard" wrote in message
...
Hi, I am pulling my hair out on this one. I just switched to Excel 2007 and
I
cannot figure out how to Ungroup rows without also Unhiding any hidden rows
within that group. I really need to be able to Group/Ungroup without
Unhiding
rows that are unused. This was never a problem with my previous version of
Excel. The two commands were not linked. Thanks in advance.
Richard
|