1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Sheet Tabs

Discussion in 'Business Applications' started by leehow, Aug 15, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. leehow

    leehow Thread Starter

    Joined:
    Aug 15, 2007
    Messages:
    4
    Is there a known way to stack sheet tabs in an excel spreadsheet, rather than have them all on one row?
    I have 15 sheets where they all are categorized as one of three types. I would like to have them in three rows.
    Is this possible?
     
  2. netquestor

    netquestor

    Joined:
    Aug 15, 2007
    Messages:
    7
    As far as I know (and I've been a harcore Excel user since 2.0), there is no way to stack tabs in Excel. There are some things you can do to help though. One of the easiest is to color code the tabs and maintain your tabs in Groups and then place the tabs in order within category. It's not what you are looking for but once you do this, you may find that simply Right Clicking the small scrolling windows of the worksheet. That will pop up a list of all the tabs in the workbook.

    As if adding yet another tab to the group would be an answer ;) there is an app/script that you can add that automatically creates a Table of Contents listing the Tabs as hyperlinks ( http://www.mrexcel.com/archive/Edit/1059.html ).

    You could also change the appearance of the tabs themselves - but its limited to width/font size etc... but perhaps a combination of changes to the appearance will be enough.
     
  3. leehow

    leehow Thread Starter

    Joined:
    Aug 15, 2007
    Messages:
    4
    Hello Netquestor:

    Thank you very much for the reply. The odd thing is, I would swear i've seen the sheet tabs stacked before, and of course didn't give it a second thought at the time.

    I am trying to make my spreadsheet more user friendly for less experienced users. They sometimes forget there are more sheets to the right than what they see on the screen.

    I will look into the "Table of Contents" idea.

    Thanks again
     
  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    You could also check out www.asap-utilities.com. They have a free add-on for Excel that I find I use more and more. One thing it can do is automatically create a Table of COntents.
     
  5. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/610378