Topic:Excel Sheet Tabs Remainpoint:0
   
PostTime:12/16/2008 1:33:41 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
95
Experience:
1
Thread:
268
Post:
947
Total online time:
1M
Joined date:
4/28/2007 11:29:00 PM
Last Visit:
12/17/2008 12:23:49 AM
Status:
Online
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?
 
     
   
Gender PostTime:12/16/2008 2:38:24 PM Point:0 | Floor# 1
Lv is 1
portrait
Level:
1
Professional point:
10
Experience:
14
Thread:
278
Post:
973
Total online time:
14M
Joined date:
4/28/2007 11:18:00 PM
Last Visit:
12/17/2008 12:41:03 AM
Status:
Offline
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.
 
     
   
Gender PostTime:12/16/2008 3:37:59 PM Point:0 | Floor# 2
Lv is 1
portrait
Level:
1
Professional point:
64
Experience:
3
Thread:
277
Post:
897
Total online time:
3M
Joined date:
4/28/2007 11:25:00 PM
Last Visit:
12/16/2008 11:33:11 PM
Status:
Offline
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.
 
     
   
Gender PostTime:12/16/2008 7:24:40 PM Point:0 | Floor# 3
Lv is 1
portrait
Level:
1
Professional point:
36
Experience:
4
Thread:
297
Post:
994
Total online time:
4M
Joined date:
4/28/2007 10:56:00 PM
Last Visit:
12/16/2008 11:36:14 PM
Status:
Offline
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
 
     
1

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search