(Msg. 1) Posted: Tue Aug 19, 2008 8:04 am
Post subject: Hide/Unhide vs Group/Ungroup - Need Help Archived from groups: microsoft>public>excel>misc (more info?)
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.
(Msg. 2) Posted: Tue Aug 19, 2008 9:00 am
Post subject: Re: Hide/Unhide vs Group/Ungroup - Need Help [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Richard RemoveThis @discussions.microsoft.com> wrote in message
news:13212E7F-20DC-4939-90B7-435F8258AB32@microsoft.com...
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.
(Msg. 3) Posted: Tue Aug 19, 2008 9:13 am
Post subject: Re: Hide/Unhide vs Group/Ungroup - Need Help [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Richard RemoveThis @discussions.microsoft.com> wrote in message
> news:13212E7F-20DC-4939-90B7-435F8258AB32@microsoft.com...
> 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
>
>
>
(Msg. 4) Posted: Tue Aug 19, 2008 12:41 pm
Post subject: Re: Hide/Unhide vs Group/Ungroup - Need Help [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Are you saying that in XL 07, when you use that keyboard shortcut to ungroup
the selected rows, it *unhides* the rows in addition to ungrouping them?
Strange - it doesn't do that in XL2k and XL02.
Wonder why Redmond made that change?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Richard" <Richard.TakeThisOut@discussions.microsoft.com> wrote in message
news:8BFDA487-A41A-41C4-B1E6-A193985F2493@microsoft.com...
> 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" <Richard.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:13212E7F-20DC-4939-90B7-435F8258AB32@microsoft.com...
>> 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
>>
>>
>>
(Msg. 5) Posted: Wed Aug 27, 2008 9:11 pm
Post subject: Re: Hide/Unhide vs Group/Ungroup - Need Help [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 19, 8:04 am, Richard <Rich... DeleteThis @discussions.microsoft.com> 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...
(Msg. 6) Posted: Wed Aug 27, 2008 9:15 pm
Post subject: Re: Hide/Unhide vs Group/Ungroup - Need Help [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 19, 8:04 am, Richard <Rich....TakeThisOut@discussions.microsoft.com> 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...
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office