Excel Workspace - Worksheet Tabs

[Marc Lauter]

Is there a way to cause Excel to display multiple rows of
worksheet tabs at the bottom of the excel workspace rather
than just one?

When a workbook has many worksheets it would be easier to
switch between different worksheets if they were visable.
I am aware that right clicking on the worksheet scroll bar
displays a list of the worksheets and that I can drag the
scroll bar on the lower right side of the workspace to the
right to allow more woorksheet tabs to be displayed but
these solutions don't really meet my needs.

Thanks to anyone that can help.

Marc

 

[John Wilson]

Marc,

Try Right Clicking on the arrows to the left of the worksheet tabs.

John

 

[c thomyre]

Marc

Try the menuZap add-in on www.admisoft.com
It's exactly what it does enable you to do, but in a
slightly different method

Christophe

 

[David McRitchie]

Marc said he already knew about right-clicking on the navigation
buttons. You can drag the separation line between worksheet
tabs and scrolling so technically that answers question but doesn't
gain much. Excel cannot display multiple rows (layers) of ws tabs.

Some suggestions to make things easier:

You can build a Table of Contents with hyperlinks to the sheets,
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

When you have lots of worksheet tabs the basic logical arrangement
is alphabetical. You can sort your worksheet tabs see SortALLSheets
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#SortAllSheets
With sorted sheet tabs, the right-click on the navigation controls
listing of worksheets looks much more meaningful. Having to almost
always hit the "More Sheets" option can be alleviated with a macro
to go directly there
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets

If you want categories you can add little prefixes in front of a worksheet
name. i.e. k.Function keys, k.Shortcut keys
since I mentioned shortcuts keys, list of builtin shortcut keys for Excel
http://www.mvps.org/dmcritchie/excel/sortx2k.htm

Colored worksheet tabs were introduced in Excel 2002, though I don't
see it as a big advantage for categorizations or anything else.

The menuZap (payfor) add-in on www.admisoft.com mentioned by
Christopher while it may not change the sheetnames for those without
the software it is going to look different to those who have it and those
who don't. It would seem that there would be about as much work to
setting that up as to set up logical arrangements of menus, so for most
usage straight alphabetical would be sufficient and easier for me.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm