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

If you want to navigate between sheets in Excel, you have come to the right place. Here, we will walk you through 8 easy ways to do the task smoothly.

Table of Contents hide

Download Workbook

8 Easy Methods to Navigate Between Sheets in Excel

1. Apply Keyboard Shortcut

2. Use of Navigation Pane

3. Use Go To Special Feature to Navigate Between Sheets in Excel

4. Applying Watch Window Feature to Navigate Between Sheets in Excel

5. Employ Activate Option to Navigate Between Sheets in Excel

6. Use of Name Box

7. Insert Hyperlink

8. Use VBA to Move Between Sheets

Practice Section

Conclusion

Download Workbook

You can download the following Excel file and practice while reading this article.

Navigation Between Sheets.xlsm

8 Easy Methods to Navigate Between Sheets in Excel

In the following article, we will describe 8 easy and effective methods to navigate between sheets in Excel. Here, we used Excel 365. You can use any available Excel version.

1. Apply Keyboard Shortcut

In this method, we will use a keyboard shortcut to navigate between sheets in Excel.
If you want to move one sheet left, press CTRL+Page Up keys.
If you want to move one sheet right, press CTRL+Page Down keys.

Steps:

Here, we want to move from the Keyboard Shortcut sheet to Sheet2.
Since Sheet2 is one sheet left of the Keyboard Shortcut sheet, therefore, we will press CTRL+Page Up keys.

As a result, we have been navigated to Sheet2.

Now, we want to move from Sheet2 to the Keyboard Shortcut sheet.
Since Keyboard Shortcut sheet is one sheet right to Sheet2, hence, we will press the CTRL+Page Down keys together.

Therefore, you can see that we have moved toward the right.
Hence, you can navigate between sheets in Excel.

2. Use of Navigation Pane

In this method, we will use a navigation pane to navigate between sheets in Excel. This is a quick and handy feature.

Steps:

In the first place, go to the View tab >> select Navigation.

At this point, a Navigation dialog box will appear at the right end of the Excel sheet.
Here, you can see all the Sheets of the Workbook.
You can select any Sheet name to navigate from this navigation pane.
Here, we selected Sheet2.

Therefore, you can see that we have reached Sheet2.

3. Use Go To Special Feature to Navigate Between Sheets in Excel

In this method, we will use the Go To Special feature to navigate between sheets in Excel.

Steps:

In the first place, go to the Home tab >> Editing group.
Then, from the Find & Select group >> select Go To.

At this point, a Go To dialog box will appear.
In the Reference box, we type Sheet9!B5.

Note: In the Reference box, make sure to add a ”!” symbol after the Sheet name.

In addition, click OK.

Therefore, we will reach cell B5 of Sheet9.

4. Applying Watch Window Feature to Navigate Between Sheets in Excel

In this method, we will use the Watch Window to navigate between sheets in Excel. This method is helpful to navigate through several numbers of sheets.

Steps:

First of all, select any cell for cell reference.
Here, we select cell B5 >> go to the Formulas tab >> select Watch Window.

At this point, a Watch Window will appear.
Then, click on Add Watch.

Afterward, we will select cell B5 of the acting sheet in the select cells that you would like to watch the value of box.
Moreover, click on Add.

Therefore, you can see the added sheet in the Watch Window.
Furthermore, to add another sheet >> click on Add Watch.

Then, we will navigate to Sheet2, and add cell B5 in the select cells that you would like to watch the value of box.
Moreover, click on Add.

Hence, you can see two sheets in the Watch Window.
Here, you can add more sheets if you need them.
Further, to navigate to the sheet, we have to double-check that sheet.
Here, we double-click on Sheet2.

As a result, we have reached cell B5 of Sheet2.

5. Employ Activate Option to Navigate Between Sheets in Excel

In this method, we will use the Activate option to navigate between sheets in Excel. This is a quick and handy method to navigate through several sheets.

Steps:

In the beginning, we will right-click on the grey area of the tab that is located left side of the first Sheet.

Therefore, you will see an Activate dialog box appears.
This dialog box contains all the sheets.
Next, we will click on Sheet2 >> click OK.

Hence, we navigated to Sheet2.

6. Use of Name Box

In this method, we will use the Name Box to navigate between sheets in Excel.

Steps:

First, select a cell and type a name in the Name box.
Here, we select cell B5 >> typed NameBoxA1 in the Name Box.
Here, you can type any name in the Name Box.

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

In addition, press ENTER.

Afterward, go to another sheet >> select cell B5 >> type Sheet2B5 in the Name Box.
Then, press ENTER.

After that, click on the drop-down arrow of the Name Box.

Therefore, the names of two reference sheets will appear.
Here, we want to navigate to Sheet2, therefore, we select Sheet2B5.

Hence, we reached Sheet2.

7. Insert Hyperlink

In this method, we will insert a Hyperlink into a cell, and we will navigate between sheets by clicking on the Hyperlink.

Steps:

In the first place, we will right-click on cell C5.
Here, we want to insert a Hyperlink into cell C5, so we right-click on cell C5.
Afterward, we will select Link from the Context Menu.

At this point, an Insert Hyperlink dialog box will appear.
Then, select Place in This Document.
This will bring out all the Sheets in the Workbook.
Then, we select Sheet9 >> type C5 as a cell reference.
In addition, click OK.

Therefore, cell C5 has now a Hyperlink.
Moreover, click on this Hyperlink.

Therefore, we have reached Sheet9.

8. Use VBA to Move Between Sheets

In this method, we will use VBA to navigate between sheets in Excel.

Steps:

First, to bring out the VBA Editor window, go to the Developer tab >> select Visual Basic.
Here, you can also press the ALT+F11 keys to bring out the VBA Editor window.

Then, a VBA Editor window will appear.
At this point, from the Insert tab, select Module.

Then, we will type the following code in the Module.

Sub navigate_between_Sheets()
If ActiveSheet.Name = "VBA" Then
Sheets("Sheet2").Activate
Else
Sheets("Sheet9").Activate
End If
End Sub

Code Breakdown

We take navigate_between_Sheets as the Sub.

The If…Then…Else statement is used to navigate between sheets.

Afterward, Save the code.
Then, we return to the VBA sheet.
Now, it’s time to run the code.
To do so, we will press the ALT+F8 keys.

This will bring out a Macro window.
Then, select the Sub of our code from Macro Name >> click on Run.

Hence, we shifted to Sheet2.

Practice Section

You can download the following Excel file and practice the explained methods.

Conclusion

Here, we show you 8 easy methods to navigate between sheets in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website Exceldemy for more related articles.