ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grouping & Outline (https://www.excelbanter.com/excel-discussion-misc-queries/194013-grouping-outline.html)

havovie

Grouping & Outline
 
I have been using Excel 2003 for a while on a desktop. Have a new Laptop now
and cannot find the Grouping Tab. Finally found it under Draw toolbar, but it
is disabled. How do I enable it. Also earlier could get the grouping tab by
right clicking the selected rows / columns. This is not available. What can
be done.

Max

Grouping & Outline
 
Think you're mistaken. The menu for your subject line is at the top:
Select the rows/cols, then click Data Group and Outline Group/Ungroup
(There's also no right-click menu available for the above, from my obs here
in xl03)

As for the Draw toolbar "Group", that's for grouping/ungrouping objects, a
different thing altogether. Once you select 2 objects drawn on the sheet, say
2 rectangles, when you click the Draw dropdown, the "Group" option will then
be enabled.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"havovie" wrote:
I have been using Excel 2003 for a while on a desktop. Have a new Laptop now
and cannot find the Grouping Tab. Finally found it under Draw toolbar, but it
is disabled. How do I enable it.
Also earlier could get the grouping tab by right clicking
the selected rows / columns. This is not available. What can be done.


RagDyeR

Grouping & Outline
 
Keyboard Shortcuts:

Select rows or columns, then:

<Shift <Alt <RightArrow To Group
<Shift <Alt <LeftArrow To Ungroup

<Ctrl <8 To Toggle View of Outline Symbols - Off / On
*Do Not* use the #8 key from the Num keypad.


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"havovie" wrote in message
...
I have been using Excel 2003 for a while on a desktop. Have a new Laptop now
and cannot find the Grouping Tab. Finally found it under Draw toolbar, but
it
is disabled. How do I enable it. Also earlier could get the grouping tab by
right clicking the selected rows / columns. This is not available. What can
be done.




All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com