tabs in Excel

I have about 30 worksheet "tabs" (at the bottom) in my Excel file and I have to scroll to the right to see them all.  I'd like to see them all within an average sized window without having to scroll over.  To do this I would need to have two stacked rows of tabs at the bottom, instead of one long row.  How do I do this?
trcampAsked:
Who is Participating?
 
PAdocITConnect With a Mentor Commented:
Not possible. If you google "Excel Multiple Tab Rows" you will find a lot of suggestions of other ways to work with a large number of tabs.
0
 
mark_harris231Connect With a Mentor Commented:
It's not possible to alter the UI in this way.  There are a couple of techniques that may help:

1. Create a Table of Contents tab with links to the various sheets.  There's an app available that will create the TOC automatically at ASAP Utilities.

2. Add the script found here to add a floating toolbar that will provide a drop-down list of available sheets.
0
 
oneononecompConnect With a Mentor Commented:
Just right click on the right arrow to show all sheets.
0
 
mark_harris231Commented:
@oneononecomp - nifty!  I wasn't aware of that technique.  Not the OP, but thanks just the same.
0
 
trcampAuthor Commented:
Thanks everyone.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.