View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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