Cascading sheet TABS

[Ironman]

Hello - - I've been given this question and I can't seem to find an answer within Excel and I'm starting to wonder if its even possible. Let say I have 25 worksheets or tabs in a workbook. In a normal setting the sheets go from sheet1 to sheet25, left to right. I'd use the scroll button to go from sheet 3, for example to sheet 24.

Is there a setting within excel that will allow me to view two rows of tabs? So, again for example, I would see Sheet1 and below that is sheet12. Then just to the right, I see Sheet2 and below that is sheet13.

So, I can now see all 25 sheets on my one screen and not have to scroll back and forth to the right and to the left...? I know I could right click the navigation arrows to select a sheet or I might incorporate a hyperlink...but I was wondering if any one of you fine excel gurus know if this is possible (under options or something)....thanks for you attention on this...Best wishes to you all.

Thanks for the responses...I'm going to call this one resolved....the two suggestions were great...thanks for the quick and timely answers...

[StephenR]

You can open new windows and then arrange them?

Window > New Window

[Andy Pope]

Sheet tabs appear in a single row only.

Best you can do is reduce the space taken up by the horizontal scrollbar but even then 25 tabs will probably not display.

You can hold the SHIFT key whilst clicking the inner scroller, this will then step through a set of tabs rather than just 1 tab.