Go To Specific tab

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

Is there an easy way to find and jump to (go to) a specific tab in a
worksheet containing multiple tabs. e.g., if I have 32 tabs for 32 states
and I want to go to/jump to the Wyoming tab without scrolling - does Excel
have a 'built in' option/feature to quickly identify the Wyoming tab and go
to it.
 
You can rightclick on the VCR/DVD like controls on the bottom left and you'll
see a popup of the available worksheets.
 
And another way if you do a lot of sheet jumping - you might assign a name
(using Ctrl-F3) to a cell on each sheet, like "WY" for cell A1 on Wyoming.
Then F5, WY, Enter and you're there.

--
Jim
| Is there an easy way to find and jump to (go to) a specific tab in a
| worksheet containing multiple tabs. e.g., if I have 32 tabs for 32 states
| and I want to go to/jump to the Wyoming tab without scrolling - does Excel
| have a 'built in' option/feature to quickly identify the Wyoming tab and
go
| to it.
 
Hi,

You can also move throught the sheet tabs by using Ctrl+PgDn and Ctrl+PgUp.
Or you can Shift+Click the center tab scrollers to go a set of sheets to the
left or right.

I have a workbook with over a hundred sheets so the tab scroller trick is
useful but limited because you need to choose the More Sheets options and
then scroll. Naming cell A1 on each sheet with the sheet name or an
abreviation is nice because you can pick the name from the much longer list
in the Name Box.

You can put hyperlinks onto a dashboard sheet that takes you to any sheet in
the workbook. Or you can create a formula to any sheet and if you press
Ctrl+[ while on the formula you will go to the sheet. =Texas!A1.

However, for my work I need something slightly different. So on a dashboard
page, the first sheet in the workbook I have a list of all the sheet names
and I've coded it such that you just double click the name and you go to the
sheet. Since the sheet I want to return to is almost always the dashboard
I've code cell A1 on all the sheets to take me back to the dashboard when I
double click. To make life easier there is code to rebuild the sheet list on
the dashboard with a single click.
 
Back
Top