View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Hide/Unhide vs Group/Ungroup - Need Help

Thanks, but that wasn't it. That string of commands Ungroups lines. I need to
be able to Ungroup without also Unhiding any hidden lines within that group.
But thanks.

"RagDyeR" wrote:

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