How to Navigate Between Sheets in Excel (10 Easy Methods)

Here are 10 simple ways to navigate between sheets in Excel:

Method 1 – Clicking on the Sheet Name Tab

Simply click on the desired sheet name tab, e.g. Sheet2, and it will become the active sheet.


Method 2 – Using Keyboard Shortcut

This method is efficient for navigating to adjacent (previous or next) sheets in Excel.

  1. If you want to move to the previous sheet (e.g. from the “Keyboard Shortcut” sheet to “Sheet2” sheet), press Ctrl + PgUp.
  2. Press Ctrl + PgDn to move from the “Sheet2” to the next sheet (to the right-hand side).Press CTRL+Page Down Keys to Navigate Between Sheets in Excel


Method 3 – Using Navigation Pane

The Navigation Pane in Excel makes it easy to find and access objects like worksheets, tables, charts, images, and more.

  1. Go to the View tab.
  2. Select Navigation.
  3. A list will appear on the right side. Click any sheet name to jump to it (e.g. Sheet2)


Method 4 – Using Go To Dialogue Box

  1. Go to the Home tab > Editing > Find & Select > click Go To.Applying Go To Feature to Navigate Between Sheets in Excel
  2. The Go To dialog box will pop up. In the Reference box, enter the worksheet name followed by an exclamation mark (!) and the cell address. For example, Sheet9!B5.
  3. Click OK to jump to cell B5 of Sheet9.


Method 5 – Applying the Watch Window Feature

This method is helpful when your workbook contains a large number of worksheets and you only need to navigate between some specific sheets.

  1. Select any cell on the sheet you want to navigate.
  2. Click the Formulas tab > Watch Window.Using Watch Window to Navigate Between Sheets in Excel A Watch Window toolbar will appear.
  3. Click on Add Watch.
  4. In the Add Watch dialog box, the reference to the active sheet and the selected cell will appear in the select cells that you would like to watch the value of field.
  5. Click on Add and the sheet and cell will be listed in the Watch Window.
  6. To add another sheet, click on Add Watch.
  7. Navigate to another sheet and select any cell.
    The reference to that sheet and the selected cell will appear in the select cells that you would like to watch the value of field.
  8. Click the Add button to add it to the list in the Watch Window.

    You can add more sheets by following the same steps.
  9. Once the targeted sheets are added in the Watch Window, double-click on any worksheet name to navigate to that sheet.
    Here, I have double-clicked on the Sheet2 option.
    Double Clicking on Watch Window to Navigate Between Sheets in Excel

It takes us to cell B5 of “Sheet2“.

Read More: How to Navigate Large Excel Spreadsheets

Method 6 – Using Activate Sheet Option

  1. Go to the bottom left corner of the sheet.
  2. Right-click on itEmploy Activate Sheet Option to Navigate Between Sheets in Excel
  3. The Activate dialog box will pop up with a list of the existing sheets of the workbook.
  4. Select your preferred sheet (e.g. Sheet2) from the list and click OK.

The selected sheet will be activated.

Method 7 – Using Name Box

In this method, we will assign a name to a single cell on each sheet within the Name Box. Then, we will use the Name Box to move between sheets in Excel.

  1. Select a cell (in this case, cell B5).
  2. Go to the Name Box and define the name NameBoxA1 in the Name Box.
    You can type any name in the Name Box.
  3. Press Enter.Use of Name Box to Navigate Between Sheets in Excel
  4. Go to another sheet (e.g. Sheet2), select a cell (e.g. B5), and type Sheet2B5 in the Name Box.
  5. Press Enter.
  6. Click on the drop-down arrow in the Name Box.
    The names of the two reference sheets we named will appear.
  7. Here, we want to navigate to Sheet2, so we select Sheet2B5.

It will take us to “Sheet2“.

Note: Make sure there is no Space between the characters in the Name Box.

Method 8 – Using Hyperlink to Navigate Between Sheets

You can establish a connection between two sheets by linking the cell value of one sheet to the corresponding link of another sheet.

  1. Select a desired cell (in this case, we have selected the C5 cell) in your worksheet.
  2. Select Link from the context menu.Inserting Hyperlink to Navigate Between Sheets in Excel
  3. In the Insert Hyperlink dialog box:
    • Go to Place in This Document.
    • Enter desired cell (in this case, cell C5) in the Type the cell reference box.
    • After that, click on the desired sheet (in this case, the Sheet9) that you want to link.
    • Click on OK.

    Cell C5 now has a Hyperlink.

  4. Click on this Hyperlink.

It will navigate to cell C5 in”Sheet9” worksheet.

Method 9 – Using VBA Code to Navigate Between Two Specific Sheets

If you constantly switch between two specific sheets, create a macro and add it as a button in the Quick Access Toolbar.

Step 1: Creating VBA Macro

  • Go to the Developer tab and select Visual Basic to open the VBA Editor window. Or, use keyboard shortcut Alt+F11.


Use VBA to Navigate Between Sheets in Excel

  • In Visual Basic Editor, click Insert > Module.

  • Paste following code in the Module.
Sub navigate_between_Sheets()
If ActiveSheet.Name = "VBA" Then
End If
End Sub

Step 2: Add VBA to the Quick Access Toolbar

  • Go to Quick Access Toolbar and select More Commands option from the drop-down menu.
    This will open the Excel Options window.
  • Select the Macros option from the Popular Commands drop-down menu.
  • Select the navigate_between_Sheets macro from the available options in the drop-down menu.
  • Click on Add.
  • Click OK.

You can see a toggle icon named navigate_between_Sheets has been added to the Quick Access Toolbar.

You can click the toggle button to navigate between the two sheets, “VBA” and “Sheet9”.

Method 10 – Using Dedicated Navigation Button (Excel 2010 and Earlier Only)

Older versions of Excel (Excel 2010 and earlier) had dedicated navigation buttons for scrolling to the first or last sheet in the workbook.

This feature is no longer available in newer versions of Excel.

However, if you still use Excel 2010 or earlier versions, you can use these buttons to navigate to the first and last worksheet tabs in your workbook.

Download Practice Workbook

Related Articles

<< Go Back to Navigation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF