tabs in Excel

Posted on 2012-09-07
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
    LVL 5

    Accepted Solution

    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

    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.
    LVL 6

    Assisted Solution

    Just right click on the right arrow to show all sheets.
    LVL 10

    Expert Comment

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

    Author Closing Comment

    Thanks everyone.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now