Excel should allow tab groupings.

The way the tabs work in Excel is not very efficient. It would be nice if
you can create groupings for tabs in Excel so that each set of tabs can be
placed in its own group. I'm currently working on an Excel document that has
about 30 sheets. A lot of sheets are related in one way or another (i.e.,
Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
acceleration). It would be nice to be able to group these in some way so
that scrolling is no longer problematic and finding the right tab becomes
faster and easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

You can re-order the tabs however you like, thus grouping them according to
your preferences.

Cheers

--
macropod
[MVP - Microsoft Word]


"Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
message news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> The way the tabs work in Excel is not very efficient. It would be nice if
> you can create groupings for tabs in Excel so that each set of tabs can be
> placed in its own group. I'm currently working on an Excel document that
has
> about 30 sheets. A lot of sheets are related in one way or another (i.e.,
> Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
> acceleration). It would be nice to be able to group these in some way so
> that scrolling is no longer problematic and finding the right tab becomes
> faster and easier.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
>
http://www.microsoft.com/office/comm...lic.excel.misc

I do. But it's still not efficient because you have to read all the tebs to
get to what you want.

"macropod" wrote:

> You can re-order the tabs however you like, thus grouping them according to
> your preferences.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>
> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
> message news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > The way the tabs work in Excel is not very efficient. It would be nice if
> > you can create groupings for tabs in Excel so that each set of tabs can be
> > placed in its own group. I'm currently working on an Excel document that
> has
> > about 30 sheets. A lot of sheets are related in one way or another (i.e.,
> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
> > acceleration). It would be nice to be able to group these in some way so
> > that scrolling is no longer problematic and finding the right tab becomes
> > faster and easier.
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds to the
> > suggestions with the most votes. To vote for this suggestion, click the "I
> > Agree" button in the message pane. If you do not see the button, follow
> this
> > link to open the suggestion in the Microsoft Web-based Newsreader and then
> > click "I Agree" in the message pane.
> >
> >
> http://www.microsoft.com/office/comm...lic.excel.misc
>
>
>

You might consider using tab colors to make your tab groups more
distinct.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com>
wrote in message
news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> The way the tabs work in Excel is not very efficient. It would
> be nice if
> you can create groupings for tabs in Excel so that each set of
> tabs can be
> placed in its own group. I'm currently working on an Excel
> document that has
> about 30 sheets. A lot of sheets are related in one way or
> another (i.e.,
> Aircraft A speed, Aircraft A acceleration, Aircraft B speed,
> Aircraft B
> acceleration). It would be nice to be able to group these in
> some way so
> that scrolling is no longer problematic and finding the right
> tab becomes
> faster and easier.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds
> to the
> suggestions with the most votes. To vote for this suggestion,
> click the "I
> Agree" button in the message pane. If you do not see the
> button, follow this
> link to open the suggestion in the Microsoft Web-based
> Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc

Hi Chip,

Coloured tabs are only available on the more recent versions of Excel (2002
and later). Not enough reason for me to upgrade <g>.

Cheers

--
macropod
[MVP - Microsoft Word]


"Chip Pearson" <chip@cpearson.com> wrote in message
news:ezFs7qkhGHA.4284@TK2MSFTNGP05.phx.gbl...
> You might consider using tab colors to make your tab groups more
> distinct.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com>
> wrote in message
> news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > The way the tabs work in Excel is not very efficient. It would
> > be nice if
> > you can create groupings for tabs in Excel so that each set of
> > tabs can be
> > placed in its own group. I'm currently working on an Excel
> > document that has
> > about 30 sheets. A lot of sheets are related in one way or
> > another (i.e.,
> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed,
> > Aircraft B
> > acceleration). It would be nice to be able to group these in
> > some way so
> > that scrolling is no longer problematic and finding the right
> > tab becomes
> > faster and easier.
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds
> > to the
> > suggestions with the most votes. To vote for this suggestion,
> > click the "I
> > Agree" button in the message pane. If you do not see the
> > button, follow this
> > link to open the suggestion in the Microsoft Web-based
> > Newsreader and then
> > click "I Agree" in the message pane.
> >
> >
http://www.microsoft.com/office/comm...lic.excel.misc
>
>

Hi Chip,

Coloured tabs are only available on the more recent versions of Excel (2002
and later). Not enough reason for me to upgrade <g>.

Cheers

--
macropod
[MVP - Microsoft Word]


"Chip Pearson" <chip@cpearson.com> wrote in message
news:ezFs7qkhGHA.4284@TK2MSFTNGP05.phx.gbl...
> You might consider using tab colors to make your tab groups more
> distinct.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com>
> wrote in message
> news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > The way the tabs work in Excel is not very efficient. It would
> > be nice if
> > you can create groupings for tabs in Excel so that each set of
> > tabs can be
> > placed in its own group. I'm currently working on an Excel
> > document that has
> > about 30 sheets. A lot of sheets are related in one way or
> > another (i.e.,
> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed,
> > Aircraft B
> > acceleration). It would be nice to be able to group these in
> > some way so
> > that scrolling is no longer problematic and finding the right
> > tab becomes
> > faster and easier.
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds
> > to the
> > suggestions with the most votes. To vote for this suggestion,
> > click the "I
> > Agree" button in the message pane. If you do not see the
> > button, follow this
> > link to open the suggestion in the Microsoft Web-based
> > Newsreader and then
> > click "I Agree" in the message pane.
> >
> >
http://www.microsoft.com/office/comm...lic.excel.misc
>
>

Some of us are color blind. :-)

"Chip Pearson" wrote:

> You might consider using tab colors to make your tab groups more
> distinct.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com>
> wrote in message
> news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > The way the tabs work in Excel is not very efficient. It would
> > be nice if
> > you can create groupings for tabs in Excel so that each set of
> > tabs can be
> > placed in its own group. I'm currently working on an Excel
> > document that has
> > about 30 sheets. A lot of sheets are related in one way or
> > another (i.e.,
> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed,
> > Aircraft B
> > acceleration). It would be nice to be able to group these in
> > some way so
> > that scrolling is no longer problematic and finding the right
> > tab becomes
> > faster and easier.
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds
> > to the
> > suggestions with the most votes. To vote for this suggestion,
> > click the "I
> > Agree" button in the message pane. If you do not see the
> > button, follow this
> > link to open the suggestion in the Microsoft Web-based
> > Newsreader and then
> > click "I Agree" in the message pane.
> >
> > http://www.microsoft.com/office/comm...lic.excel.misc
>
>
>

And some just can't be helped!

--
macropod
[MVP - Microsoft Word]


"Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
message news:28CF14AB-A410-43D7-AA56-2F0CB010396C@microsoft.com...
> Some of us are color blind. :-)
>
> "Chip Pearson" wrote:
>
> > You might consider using tab colors to make your tab groups more
> > distinct.
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com>
> > wrote in message
> > news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > > The way the tabs work in Excel is not very efficient. It would
> > > be nice if
> > > you can create groupings for tabs in Excel so that each set of
> > > tabs can be
> > > placed in its own group. I'm currently working on an Excel
> > > document that has
> > > about 30 sheets. A lot of sheets are related in one way or
> > > another (i.e.,
> > > Aircraft A speed, Aircraft A acceleration, Aircraft B speed,
> > > Aircraft B
> > > acceleration). It would be nice to be able to group these in
> > > some way so
> > > that scrolling is no longer problematic and finding the right
> > > tab becomes
> > > faster and easier.
> > >
> > > ----------------
> > > This post is a suggestion for Microsoft, and Microsoft responds
> > > to the
> > > suggestions with the most votes. To vote for this suggestion,
> > > click the "I
> > > Agree" button in the message pane. If you do not see the
> > > button, follow this
> > > link to open the suggestion in the Microsoft Web-based
> > > Newsreader and then
> > > click "I Agree" in the message pane.
> > >
> > >
http://www.microsoft.com/office/comm...lic.excel.misc
> >
> >
> >

Nearing release is my Excel add-in "Determine Colors". It adds a popup menu
to the cell right-click menu. It displays the cell color, font color, pattern color,
border color and the sheet tab color. (by name)
It may be of assistance to color blind Excel users. I am looking for comments
and feed back on the program. If you are interested, please email me and
I will forward it to you. Remove xxx from my email address.
--
Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX
http://www.realezsites.com/bus/primitivesoftware



"Bassam Abdul-Baki"
<BassamAbdulBaki@discussions.microsoft.com>
wrote in message
Some of us are color blind. :-)



"Chip Pearson" wrote:
> You might consider using tab colors to make your tab groups more
> distinct.
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com

In addition to the other suggestions, you could set up a list on one sheet
with a double click event to quickly goto any sheet on which you double
click

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
message news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> The way the tabs work in Excel is not very efficient. It would be nice if
> you can create groupings for tabs in Excel so that each set of tabs can be
> placed in its own group. I'm currently working on an Excel document that
> has
> about 30 sheets. A lot of sheets are related in one way or another (i.e.,
> Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
> acceleration). It would be nice to be able to group these in some way so
> that scrolling is no longer problematic and finding the right tab becomes
> faster and easier.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc

Agreed.........I use a MasterMenu sheet on a workbook with about 40 sheets,
with buttons to go to each sheet directly, with all sheets being hidden.
Each sheet also has a "Return to MainMenu" button, so to go to any sheet from
any sheet is only two clicks away...........on the MasterMenu, the buttons
can be grouped for Visual optimum......maybe even pictoral, like an
Instrument Panel....click on an instrument picture and it takes you to that
sheet.........

hth
Vaya con Dios,
Chuck, CABGx3



"Don Guillett" wrote:

> In addition to the other suggestions, you could set up a list on one sheet
> with a double click event to quickly goto any sheet on which you double
> click
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
> message news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
> > The way the tabs work in Excel is not very efficient. It would be nice if
> > you can create groupings for tabs in Excel so that each set of tabs can be
> > placed in its own group. I'm currently working on an Excel document that
> > has
> > about 30 sheets. A lot of sheets are related in one way or another (i.e.,
> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
> > acceleration). It would be nice to be able to group these in some way so
> > that scrolling is no longer problematic and finding the right tab becomes
> > faster and easier.
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds to the
> > suggestions with the most votes. To vote for this suggestion, click the "I
> > Agree" button in the message pane. If you do not see the button, follow
> > this
> > link to open the suggestion in the Microsoft Web-based Newsreader and then
> > click "I Agree" in the message pane.
> >
> > http://www.microsoft.com/office/comm...lic.excel.misc
>
>
>

Chuck,
Maybe the double click would be less overhead for you. Just a thought

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"CLR" <CLR@discussions.microsoft.com> wrote in message
news:A1556C83-7B3A-4E7C-BFA6-5159B081D64C@microsoft.com...
> Agreed.........I use a MasterMenu sheet on a workbook with about 40
> sheets,
> with buttons to go to each sheet directly, with all sheets being hidden.
> Each sheet also has a "Return to MainMenu" button, so to go to any sheet
> from
> any sheet is only two clicks away...........on the MasterMenu, the buttons
> can be grouped for Visual optimum......maybe even pictoral, like an
> Instrument Panel....click on an instrument picture and it takes you to
> that
> sheet.........
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Don Guillett" wrote:
>
>> In addition to the other suggestions, you could set up a list on one
>> sheet
>> with a double click event to quickly goto any sheet on which you double
>> click
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "Bassam Abdul-Baki" <BassamAbdulBaki@discussions.microsoft.com> wrote in
>> message news:BFFB17FB-470C-4E3A-BC81-610F404617EF@microsoft.com...
>> > The way the tabs work in Excel is not very efficient. It would be nice
>> > if
>> > you can create groupings for tabs in Excel so that each set of tabs can
>> > be
>> > placed in its own group. I'm currently working on an Excel document
>> > that
>> > has
>> > about 30 sheets. A lot of sheets are related in one way or another
>> > (i.e.,
>> > Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
>> > acceleration). It would be nice to be able to group these in some way
>> > so
>> > that scrolling is no longer problematic and finding the right tab
>> > becomes
>> > faster and easier.
>> >
>> > ----------------
>> > This post is a suggestion for Microsoft, and Microsoft responds to the
>> > suggestions with the most votes. To vote for this suggestion, click the
>> > "I
>> > Agree" button in the message pane. If you do not see the button, follow
>> > this
>> > link to open the suggestion in the Microsoft Web-based Newsreader and
>> > then
>> > click "I Agree" in the message pane.
>> >
>> > http://www.microsoft.com/office/comm...lic.excel.misc
>>
>>
>>

Grouping pby color:

http://cjoint.com/?gdiebRItrq

Private Sub CheckGroupe1Visible_Click()
For Each f In ActiveWorkbook.Sheets
If f.Tab.ColorIndex =3D 45 Then
Sheets(f.Name).Visible =3D CheckGroupe1Visible.Value
End If
Next

Cordialy JB



Bassam Abdul-Baki a =E9crit :

> The way the tabs work in Excel is not very efficient. It would be nice if
> you can create groupings for tabs in Excel so that each set of tabs can be
> placed in its own group. I'm currently working on an Excel document that=
has
> about 30 sheets. A lot of sheets are related in one way or another (i.e.,
> Aircraft A speed, Aircraft A acceleration, Aircraft B speed, Aircraft B
> acceleration). It would be nice to be able to group these in some way so
> that scrolling is no longer problematic and finding the right tab becomes
> faster and easier.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow t=
his
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...?mid=3Dbffb17=
fb-470c-4e3a-bc81-610f404617ef&dg=3Dmicrosoft.public.excel.misc