Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to go to a specific sheet in Excel?

To go to a specific sheet by clicking at the tab name is very easy for many users, but if the workbook is large with multiple sheets which cannot shown all in the tab as below screenshot shwon, how can you quickly find a sheet and go to it?

doc go to specific sheet 1

Go to a specific sheet with right click

Go to a specific sheet with VBA

Go to a specific sheet with Kutools for Excelgood idea3

Check if a sheet name exist with Kutools for Excel


arrow blue right bubble Go to a specific sheet with right click


In Excel, to go to a specific sheet, you can use the right click.

Place the cursor at the litter arrows at the bottom left corner of the sheet, and the right click, you can see there is a context menu popping out to show first 15 sheets.

doc go to specific sheet 2

If there are more than 15 sheets in your workbook, you can click More Sheets to the Activate dialog, in this dialog, all sheets are displayed in it, and just scroll to find the sheet you want, and click it to go to activate it.

doc go to specific sheet 3

Note: In Excel 2013, the Activate dialog box will pop out directly when right clicking the arrows at bottom-right corner of Sheet Bar.

If there are so many sheets in a workbook, this is not a good choice to find and go to the specific sheet by scrolling.


arrow blue right bubble Go to a specific sheet with VBA

There is a VBA code can help you to quickly find and go to a specific sheet in a workbook.

1. Presss Alt + F11 keys together, and a Microsoft Visual Basic for Applicatioons window pops out.

2. Click Insert > Module, then paste below VBA into the Module window.

VBA: Go to a specific sheet

Sub GotoSheet()
'UpdatebyKutoolsforExcel20150916
    Dim xRet As Variant
    Dim xSht As Worksheet
    xRet = Application.InputBox("Go to this sheet", "Kutools for Excel")
    On Error Resume Next
    If xRet = False Then Exit Sub
    On Error GoTo 0
    On Error Resume Next
    Set xSht = Sheets(xRet)
    If xSht Is Nothing Then Set xSht = Sheets(Val(xRet))
    If xSht Is Nothing Then
        MsgBox "This sheet does not exist", , "Kutools for Excel"
    Else
        xSht.Activate
    End If
End Sub

3. Click Run or press F5 to excute the code, and a Kutools for Excel dailog pops out, then type the sheet name you want to find and go to in the textbox. See screenshot:

doc go to specific sheet 4

4. Click OK, and now you have placed at the specific sheet you want.


arrow blue right bubble Go to a specific sheet with Kutools for Excel

With Kutools for Excel, you can list all sheet names and then find the sheet name you need, and go to it.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Click Enterprise > Worksheet > Create List of Sheet Names. See screenshot:

doc go to specific sheet 13

2. In the popped out dialog, do as below:

doc go to specific sheet 6
1) Check Contains a list of hyperlinks option;
2) Type a name for your new sheet which will contain all sheet names;
3) Specify a location to insert the new sheet;
4) Specify how many columns you want to place the sheet names in a sheet

3. Click Ok. Now a new sheet with all sheet names list is created,

doc go to specific sheet 7

4. Press Ctrl + F to open the Find and Replace dialog, then type the sheet name you want to find into the Find what textbox. See screenshot:

doc go to specific sheet 8

5. Click Find All. Now the sheet you need is selected, (close the Find and Replace dialog), and then just click it, you will go to this specific sheet.

doc go to specific sheet 9

Click here to know more about Create List of Sheet Names.


arrow blue right bubble Check if a sheet name exist with Kutools for Excel

If you just want to check if a sheet name exist in a workbook and do not need to go to it, I can introduce a trick for you.

After free installing Kutools for Excel, please do as below:

1. Click Enterprise > Worksheet > Rename Multiple Worksheets. See screenshot:

doc go to specific sheet 10

2. Then check Filter checkbox in the popping dialog. See screenshot:

doc go to specific sheet 11

3. Now type the sheet name you want to check if exist into the textbox under Filter, and after your typing, if there are relative sheet appears in the Worksheet list, the sheet exists in the workbook, or it does not.

doc go to specific sheet 12

Click here to know more about Kutools for Excel’s Rename Multiple Worksheets.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.