Tab-ulous Question! Expert Needed...

[friendlyfan]

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:

 

[Tom Urtis]

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).

 

[jdee]

Here are some more ideas.
http://www.mrexcel.com/board2/viewt...rksheets&sid=24e203668840d98322d6fdc0348cb738

 

[friendlyfan]

Tom Urtis and jdee:

You two are terrific! Thanks for your assistance.