How to Use Navigation in Excel?

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will learn how to
-Navigate within Excel cells and worksheets
-Move across selected ranges for navigation
-Use the scroll lock and scroll bars for navigation
-Use the Navigation Pane for charts and tables in Excel

We have used Microsoft 365 to prepare this article. But these methods apply to Excel 2021, 2019, 2016, 2013, 2010, and prior versions.

We will use Excel navigation methods to work faster and improve efficiency while working with spreadsheets.

Navigation in Excel

Download Practice Workbook

How to Use Navigation Shortcuts in Excel? (9 Easy Ways)

Here, we will show you nine different types of navigation shortcuts in Excel. We will use these navigation shortcuts to navigate across Excel cells, worksheets, rows, columns, and many more.

1. Navigating Within Excel Cells in Excel of a Data Region

You will learn how to move the cursor position within Excel cells to perform cell navigation. Follow the steps below.

  • Firstly, select the B6 cell, which is the first row of the table ⟹ press the Ctrl + Down Arrow keys.

Select a cell and press Ctrl + Down arrow keys

  • Now, you can see the cursor is in the last row of the data region.

New position of cursor


  • Similarly, you can move to the top row of a data region by pressing, Ctrl + Up keys. To move to the most left and right cells of the dataset, press the Ctrl + Left and Ctrl + Right keys respectively.

2. Navigating to the First Cell of the Worksheet

In this part, we will show how to navigate to the first cell of the Excel worksheet. In the image below, you can see a sample dataset where the initial cell position is in the B6 cell.

Select a cell and press Ctrl + Home key

  • Select the B6 cell ⟹ and press Ctrl + Home key.
  • Now, it will move the cursor to the first cell (A1)

 Cursor moves to the first cell

3. Navigating to the Beginning of the Row of the Worksheet

To go to the beginning of the row in the worksheet, follow the below steps. 

  • Select any cell on the worksheet. We have selected the E9 cell.

Select a cell and press Home key

  • Press the Home key.
  • Finally, it will move the cursor to the beginning of the row of the worksheet in cell A9.

 Cursor moves to the beginning of the row

4. Navigating to a Specific Cell of the Worksheet

In this part, we will show how you can navigate to a specific cell from the Go To dialog box.

  • Press F5 or Ctrl + G to open the Go To dialog box.
  • Now, write any cell address in the Go To dialog box. We have written C8 as a cell reference here.

Press F5 or Ctrl + G and write a cell reference in the Go To dialog box

  • Finally, you can see that it will select the C8 cell that you wrote in the Go To dialog box.

Cursor moves to the specific cell

5. Moving Across Selected Ranges for Navigation

In this section, we will show how to select any cells in a specified range.

  • Go to the B6 cell ⟹ and press Ctrl + Shift + Down Arrow keys.
Select a cell and press Ctrl + Shift + Down Arrow keys for navigation

Click on the image for a detailed view

  • Here, you can see that all the cells in range B6:B15 have been selected. Now, press the Tab key on the keyboard.
Press the Tab button to navigate

Click on the image for a detailed view

  • When you press the Tab key, it will move the cursor from the top by one cell within the selected range.
Changed the position of the cursor from the top by one cell

Click on the image for a detailed view

6. Navigating Between Worksheets in Excel

It is necessary to navigate worksheets in Excel when you work with multiple sheets. To learn how to do it, follow the steps below.

  • This is our main worksheet named “Navigate Between Worksheets”.
  • If you want to switch between two sheets, click on the Ctrl PgUp keys, and it will move to the previous worksheet. 

Press Ctrl + PageUp keys for navigation

  • Now, you will see the previous worksheet named “Moving across Selected Range”.

Show previous worksheet

  • And, when you click on the Ctrl PgDn keys, it will move back to the main worksheet.

Show main worksheet

7. Using the Scroll Lock Feature to Navigate Between Pages

You can scroll between pages to maintain large sets of data by enabling the Scroll Lock feature

  • Press the ScrLK (Scroll Lock) button to enable scroll lock which helps you to scroll large pages. You will see a scroll lock enabled in the status bar.

Enable scroll lock by pressing the Scroll Lock button for navigation

  • Now, press the Ctrl Right Arrow key as shown in the image below.

 Press the Ctrl + Right Arrow key for navigation

  • Finally, the screen is shifted to the right by one page.
  • Similarly, you can move back to the left by one page by pressing the Ctrl Left Arrow key.

Shifted screen position by one-page

8. Applying Scroll Bar for Left-Right Navigation in Excel

Here, we will look at moving rows and columns using the Scroll Bars in Excel.

  • Drag the Scroll Bar from left to right.
  • After dragging, you can see the dataset moved to the left by one column.
 Apply Scroll Bars for navigation in Excel

Click on the image for a detailed view

9. Switching Between Screens for Navigation in Excel

In this part, we will show you how to switch from one screen to another on your device. It may vary with your monitor size.

  • Select the B6 cell ⟹ and press the Page Down key.

Select a cell and press the Page Down key

  • Now, it will move to the next screen of the B33 cell. So, it switches to one screen from row 6 to row 33.

Screen moves in the downward direction

  • Again, by pressing the Page Up key, it will move back to the B6 cell.

 Screen moves in the upward direction

How to Use Navigation Pane For Charts, and Tables in Excel?

In this part, we will use the navigation pane to navigate charts and tables in Excel.

  • Firstly, go to the View tab, then click on the Navigation Pane.

Click on the Navigation pane from the View tab

  • Now, select any sheet that you want to navigate and their charts, datasets, tables, etc.
  • Then, you will see different elements of that worksheet displayed in the navigation pane.
  • Here, we have selected Navigating_Sheets_Charts_Table Navigating_Sheets_Charts_Table!B4:C9 and it takes us to the dataset of the worksheet.

 Navigating dataset in the worksheet

  • Now, we have selected range B4:C9 of the sheet named Navigating_Sheets_Charts_Table Chart 2: Sales Item Vs Month and it will select the graph.

Navigating chart in the worksheet

Things to Remember

  • Enabling Scroll Lock allows smooth scrolling through the worksheet without changing the active cell. This is particularly useful when dealing with large datasets.
  • Always double-check that you’ve selected the correct cells before performing any action. Selecting the wrong cells can lead to unintended changes in your data.
  • Be cautious when navigating through sheets with hidden rows or columns. Hidden data can affect calculations and analysis. Unhide them when necessary.
  • The sheet tabs at the bottom of the Excel window make it easier to switch between worksheets in a workbook.

Frequently Asked Questions

1. Can I create custom-named ranges for easy navigation in Excel?

Yes, you can define named ranges to make navigation easier. Go to the Formulas tab, and click on Name Manager to create a new named range. Then, you can navigate to that named range by using Ctrl + G and selecting the range from the list.

2. How do I switch between different open workbooks using the keyboard?

You can use the “Ctrl + F6” shortcut to cycle through different open workbooks. Press “Ctrl” and then repeatedly press “F6” to switch between them.

3. How can I quickly move to the start or end of a row or column?

Press the Ctrl + Arrow key to move to the last filled cell in that direction. For example, the Ctrl + Down Arrow key will take you to the bottom of the current column.

4. How can I make an Excel navigation link?

  • Create a Link to a website
  • Choose the cell on a worksheet where you want to link something.
  • Insert tab ⟹ Hyperlink button.
  • Enter the text you want to use to represent the link under Display Text.
  • Enter the complete Uniform Resource Locator (URL) of the website you want to connect to under the URL.
  • Choose OK.


In this article, we have demonstrated various applications of the navigation shortcuts in Excel to navigate across Excel cells, worksheets, rows, columns, and many more.  You can navigate any size spreadsheet more quickly and precisely by using the shortcut and navigation keys in Excel. We have also discussed their examples and usages with proper explanations. Further, you will learn the basics of how to use the navigation pane for navigating charts and tables in Excel from this article.

We hope you find this helpful article. If there are any further queries or recommendations, feel free to comment.

Navigation in Excel: Knowledge Hub

<< Go Back to Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.


Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF