How do I navigate using Excel keyboard?
8 Keyboard Shortcuts For Quick Workbook Navigation
- Ctrl + Tab Move between open Excel workbooks.
- Ctrl + Page Down Move to the next worksheet in the workbook.
- Ctrl + Page Up Move to the previous worksheet in the workbook.
- Ctrl + Arrow Key Move to the left, right, upper or lower most part current data region.
Why can’t I use my arrow keys in Excel?
One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. For as long as it remains enabled, the keys won’t do what they’re supposed to do. If you take a look at your keyboard, you’ll find that the light for the scroll lock button is turned on.
How do I navigate faster in Excel?
A Few Indispensable Keyboard Shortcuts for Moving Quickly Around Excel
- 1) CTRL + Arrow Key. While the arrow keys are used to navigate around the worksheet, they only move one cell at a time.
- 2) SHIFT + Arrow Key.
- 3) CTRL + PgUp/PgDown.
- 4) F2 key.
- 5) CTRL + 1.
- 6) CTRL + SHIFT + [1 – 7]
When I press arrows scroll in Excel?
If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. Click the “ScrLk” key to turn off Scroll Lock. The key should no longer be blue when Scroll Lock is off. The Scroll Lock indicator on the status bar goes away when Scroll Lock is off.
What are navigation shortcuts in MS Excel?
Keyboard shortcuts for navigating in cells
To do this | Press |
---|---|
Move to the next sheet in a workbook. | Ctrl+Page down |
Move one screen to the right in a worksheet. | Alt+Page down |
Move one screen up in a worksheet. | Page up |
Move one screen to the left in a worksheet. | Alt+Page up |