Tab-ulous Question! Expert Needed...

friendlyfan

New Member
Joined
Nov 26, 2005
Messages
5
Hello, experts. I have an Excel workbook with about 200 worksheet tabs. Is there any way to efficiently move between the tabs other than just scrolling and/or clicking all of the way to each end? It seems a little inefficient to scroll - must be a better way. Thank you! You're an angel! :wink:
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,222
Right-click on the navigation arrows to the immediate left of the sheet tabs, for a pop-up list of sheets in the workbook that you can left click onto for selection. Also notice, the right-most of those navigation buttons will take you to the last sheet (the leftmost button will take you to the first sheet, and the two others will take you to the next or previous sheet).
 

Watch MrExcel Video

Forum statistics

Threads
1,118,529
Messages
5,572,657
Members
412,481
Latest member
nhantam
Top