Worksheet Tab Display - HELP!!

[JBG2007]

I know there has to be a way to do this!!

I have a file that has multiple worksheets (about 30) with very long tab names (25+ characters). Each month we have to update the sheets but it is a pain in the patootie to scroll through all the tabs, and it takes a ton of time. If it were me alone, I would just shorten the spreadsheet tab names but other people like the format so I am not allowed to do this. So! My question is:

Is there a way to format the worksheet tab display (on the bottom of the spreadsheet - print screen attached) so it stacks the tabs in rows and thus makes the tab area thicker, but is able to show all the tabs at one time? I am sure other people have had this question - I've seen spreadsheets with 50 tabs so I am pretty certain this is a common question.

I would truly appreciate your help with this, oh Excel gods and goddesses!!

JBG

[oldchippy]

I know there has to be a way to do this!!

I have a file that has multiple worksheets (about 30) with very long tab names (25+ characters). Each month we have to update the sheets but it is a pain in the patootie to scroll through all the tabs, and it takes a ton of time. If it were me alone, I would just shorten the spreadsheet tab names but other people like the format so I am not allowed to do this. So! My question is:

Is there a way to format the worksheet tab display (on the bottom of the spreadsheet - print screen attached) so it stacks the tabs in rows and thus makes the tab area thicker, but is able to show all the tabs at one time? I am sure other people have had this question - I've seen spreadsheets with 50 tabs so I am pretty certain this is a common question.

I would truly appreciate your help with this, oh Excel gods and goddesses!!

JBG

Hi JBG,

I don't think what you are asking is possible, but I could be wrong. But are you aware of Excel's built in pop-up sheet index. To see this simply right click on the sheet scroll tabs to the left of the name tabs. By doing this you will see a pop-up menu, upon clicking "More sheets..." you will see all Worksheets listed in a scrollable list box

Is this any help?

oldchippy

[JBG2007]

That is so fabulous!! I have worked with Excel for 10 years and had no clue about that - it isn't exactly what I was looking for but it solves the problem in a very efficient way! Thank you so much.

JBG