Learn how to a build a cloud-first strategyRegister Now


tabs in Excel

Posted on 2012-09-07
Medium Priority
Last Modified: 2012-09-07
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?
Question by:trcamp

Accepted Solution

PAdocIT earned 120 total points
ID: 38376990
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.
LVL 10

Assisted Solution

mark_harris231 earned 270 total points
ID: 38377021
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.

Assisted Solution

oneononecomp earned 165 total points
ID: 38377026
Just right click on the right arrow to show all sheets.
LVL 10

Expert Comment

ID: 38377046
@oneononecomp - nifty!  I wasn't aware of that technique.  Not the OP, but thanks just the same.

Author Closing Comment

ID: 38377047
Thanks everyone.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question