Jump List for Sheets

W

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
I got an idea but none on how to do it.
Rather than scrolling thru 20-30 sheets in a work book looking for one in particular, is there a way to create a filter that will list all the sheets alphabetically and let you choose which one to jump to?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Just right click to the left of the tabs (by the 2 arrows) and a list of all sheets will appear. Just click the one you want
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Looking to create a drop-down list where selecting a name brings me to a specific cell containing that name
Replies
5
Views
102
SanjayGMusafir
SanjayGMusafir
M
  • Question
Ideas Power Query and/or Python?
Replies
8
Views
80
mickeystanford_alumni
M
S
  • Question
Excel Drop Down List - Jump to Corresponding Cell
Replies
2
Views
954
kevin9999
K
I
  • Solved
Type in field to jump to first instance of what was typed from a drop down list
2 3 4
Replies
38
Views
870
ipbr21054
I
X
  • Question
Search and "mark" sheet with 35k rows of data against 1k names for partial match?
Replies
2
Views
234
xdriver
X

Forum statistics

Threads
1,214,976
Messages
6,122,539
Members
449,088
Latest member
RandomExceller01

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