HOW DO I HAVE TWO ROWS OF SHEET TABS?

T

Tess

I have a worksheet which currently has around 20 sheet tabs at the bottom,
with more being added in the future. Is there any way to have more than one
row of tabs, so that I can see all the tabs at once without having to scroll
back and forwards?
 
Z

Zygan

have not seen it but i use ctrl+pgdwn or pgup and that is faster an
works nicely or create a macro that asigns to your icons up top to t
dropdown box and select your sheet number ? mayb
 
N

Nika Lampe

Hi,

if you use Excel 2003 (I am not sure for previous versions), you can right
click on arrows that are on the left of sheet names and you'll get a "menu"
with all your sheets... and then just choose the one you want.

Regards,
Nika Lampe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Rows of Sheet Tabs 2
Manage a high number of worksheets in one workbook (Excel 2007) 4
How do I reference one OR another worksheet? 2
Copy rows to new sheet based on value in column A 0
Sheets Tabs 1
How can I print rows that go outside of the page without shrinking the text? 0
Dealing with a Pivot Table (when I don't want to) 0
Calculating inserted rows or colums from another sheet 1

Top