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.
Download Practice Workbook
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.
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.
- Now, you can see the cursor is in the last row of the data region.
Notes
- 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.
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 the B6 cell ⟹ and press Ctrl + Home key.
- Now, it will move the cursor to the first cell (A1).
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.
- Press the Home key.
- Finally, it will move the cursor to the beginning of the row of the worksheet in cell A9.
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.
- Finally, you can see that it will select the C8 cell that you wrote in the Go To dialog box.
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.
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.
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.
Click on the image for a detailed view
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.
- Now, you will see the previous worksheet named “Moving across Selected Range”.
- And, when you click on the Ctrl ⟹ PgDn keys, it will move back to the main worksheet.
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.
- Now, press the Ctrl ⟹ Right Arrow key as shown in the image below.
- 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.
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.
Click on the image for a detailed view
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.
- Now, it will move to the next screen of the B33 cell. So, it switches to one screen from row 6 to row 33.
- Again, by pressing the Page Up key, it will move back to the B6 cell.
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.
- 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.
- 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.
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
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.
- 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.
Conclusion
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.
- Create Navigation Buttons
- Navigate Large Excel Spreadsheets
- Use Navigation Keys
- Perform Tab Navigation
- [Fixed] Excel Navigation Arrow Keys Not Working
- Scrolling in Excel
- How to Turn On/Off Scroll Lock in Excel
<< Go Back to Learn Excel
