Tab-ulous Question! Expert Needed...

F

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:
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
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).
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
117
frobeniusabnorm
F
C
  • Question
Use command buttons to advance vertical userform textbox scrollbar up or down
Replies
3
Views
258
Micron
M
M
  • Question
Turn off sheet tabs & export data . Help me!
Replies
0
Views
369
Mark Milan
M
R
  • Question
VBA Performance / Optimization & Out of Memory Error
Replies
9
Views
669
Candyman8019
C
B
  • Question
Efficient moving in range where all cells have a formula
Replies
4
Views
293
Alex Blakenburg
A

Forum statistics

Threads
1,214,978
Messages
6,122,545
Members
449,089
Latest member
davidcom

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top