Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Jumping to a Specific Worksheet

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Jumping to a Specific Worksheet.

If you have a huge number of worksheets in a workbook, you may be looking for a way to jump to a specific sheet rather easily. There are a number of ways you can approach this task, and their applicability to your situation depends on how many worksheets you actually have in the workbook.

One option that works well if you have a limited number of worksheets (say, 30-40 sheets or less) is to right-click the sheet navigation buttons at the left of the sheet tabs. Doing so will pull up a list of worksheet names, and you can select which one you want to jump to. If there are more worksheets than can comfortably fit in the list, then one of the options is "More Sheets." Select that option, and you end up with a dialog box that lists all the worksheets and you can make your selection.

Another option that many people employ is to create a "table of contents" for your workbook. In the first worksheet, enter a bunch of hyperlinks that jump to the various worksheets in your workbook. That way you can display the TOC, click a link, and you are on your way.

If you know the name of the worksheet you want to jump to, you can also use the Go To capabilities of Excel. Follow these steps:

  1. Press F5. Excel displays the Go To dialog box.
  2. In the Reference box, enter Sheet83!A1. (Replace "Sheet83" with the name of the worksheet you want to jump to.)
  3. Click OK.

Another option is to create a macro to prompt for either the name or number of the worksheet you want to display. The following macro could be assigned to a shortcut key, and then you can use it to jump to whatever sheet is desired.

Sub GotoSheet()
    Dim sSheet As String

    sSheet = InputBox( _
      Prompt:="Sheet name or number?", _
      Title:="Input Sheet")
    On Error Resume Next
    If Val(sSheet) > 0 Then
        Worksheets(Val(sSheet)).Activate
    Else
        Worksheets(sSheet).Activate
    End If
End Sub

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3119) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Jumping to a Specific Worksheet.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Muhammad haseeb Zahid    04 Oct 2016, 10:31
Thanks this is very helpful for any student. this is so easy.
nattawut k.    28 Sep 2016, 01:21
Thank you for the good one.
anonymous    01 Sep 2016, 19:02
Is it possible to tweak this code so I only have to type a portion of the sheet name rather than the entire name?
Judy    22 Jul 2016, 16:51
Can you use the go-to shortcut to jump to a worksheet whose name is more than one word? ie. Acosta FS (Has a space between the words.)
harish    13 Jun 2016, 10:47
you can go to next buttons at bottom left corner
and right click on them to go to a worksheet directly
Deevanshu Khatri    11 Feb 2016, 00:32
Dear Sir, Good Morning

I Want to Learn how to work & linking in Excel kindly help me .
vijaykumar    28 Nov 2015, 07:59
i want learn of how to go to directly jumping to linking place in excel sheet which function key, or command.. please tell us..
Hajiso    27 Oct 2015, 07:34
Nice
Martin greene    20 Oct 2015, 14:11
I need to insert the option of a wildcard vs typing in the entire name
Marty Greene    20 Oct 2015, 10:42
For long worksheet names , can wildcards be used in the prompt input? Which work best?
Parwez Ali    15 Sep 2015, 09:19
I Have Sheet Names like Hollidays, Comments Style, Income Etc so how can i search them That formula doesn't work Please tell me About this issue.
Thanks
Jaad    15 Aug 2015, 08:42
Hey amar
Just remove all the if statements and Leave only "Worksheets(sSheet).Activate" and you should be fine
It should look like this:
Sub Jumper()
    Dim sSheet As String

    sSheet = InputBox( _
      Prompt:="Enter Date in Formate 01/MM/YYYY", _
      Title:="Input Sheet")
    On Error Resume Next
        Worksheets(sSheet).Activate
End Sub
amar    29 Jun 2015, 06:30
Not working because my sheets name is like 791
792
901
902
912
in number format.

please help me whit i have to use at place of string..............
Ralphy    23 Feb 2015, 03:14
super! i needed this so bad. i didn't expect it to be so easy. thank you!
shiv kumar    30 Apr 2014, 09:44
I like this macro you have provided, short and working..
prabha jesi malar    31 Jan 2014, 10:48
thanks for your answer and your coding thanks thanks to all
gugan    21 Dec 2013, 03:05
Notify me about new comments ANYWHERE ON THIS SITE
Lynda     16 Nov 2013, 12:50
this is a tip i will use and completely forgot about.. if you dont use it you will forget it ... :)
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.