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" wrote in
message ...
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"
wrote in message
...
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

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

"Bassam Abdul-Baki" wrote in
message ...
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

"Bassam Abdul-Baki" wrote in
message ...
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" wrote in message
...
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"
wrote in message
...
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" wrote in
message ...
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"
wrote in message
...
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

"CLR" wrote in message
...
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

"Bassam Abdul-Baki" wrote in
message ...
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" 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


"Bassam Abdul-Baki"
wrote in message
...
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
XX
http://www.realezsites.com/bus/primitivesoftware



"Bassam Abdul-Baki"

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

Grouping pby color:

http://cjoint.com/?gdiebRItrq

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

Cordialy JB



Bassam Abdul-Baki a écrit :

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 thathas
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