I would suggest sorting your worksheet tabs alphabetically so
that you can find them quickly, and install the following macro
which is the equivalent of right-click on a sheet tabs navigation arrow on
lower left of workbook followed by "More Sheets..." or with a macro
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel...htm#moresheets

You could also build an index sheet
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mikky" wrote in message ...
I work with files with many sheets. I often need to switch between the sheet
tabs. Right clicking on the lower left corner and selecting the needed sheet
tab is too cumbersome for me. What about displaying all sheet tabs on as many
tab rows as necessary?

----------------
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...ic.excel.setup