Introduction
We have studied about the different methods of navigating between the excel cells and we concisely mentioned about the keyboard shortcuts that can be used to navigate between cells. Here we list all the important keyboard shortcuts that can be used for navigation in different scenarios.
Excel has made navigating within the cells of the worksheet super easy for its users. With the correct combination of various keystrokes one can easily scroll the worksheet view automatically to the desired location.
Simple keyboard shortcuts for Navigation in Excel
Here are the keystrokes and keyboard shortcuts that will make your life easier as an Excel user and will surely make you look like an expert.
Keystroke - Cursor movement
→ Move to Cell which is at the immediate right of the current cell.
Tab Move to Cell which is at the immediate right of the current cell.
← Move to Cell which is at the immediate left of the current cell.
Shift+Tab Move to Cell which is at the immediate left of the current cell.
↑ Move to Cell which is one row up to the current cell.
↓ Move to Cell which is one row down to the current cell.
Home Move to Cell which is in column A of the current row.
PgUp Move to Cell which one screenful up in the same column of the current cell.
PgDn Move to Cell which one screenful down in the same column of the current cell.
Navigation Keyboard shortcuts using the Ctrl Key
To use these shortcut combinations just hold down the Ctrl key and then press the other key in the combination i.e. both the keys will be pressed together. This is symbolized by the ‘+’ sign.
Ctrl + Home Move to the first cell of the worksheet i.e. the cell A1
Ctrl + End Move to the last cell of the active area of the worksheet i.e. last cell of that area of the worksheet that has some data.
Ctrl + → Move to the first occupied cell to the right of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very end of the row.
Ctrl + ← Move to the first occupied cell to the left of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very beginning of the row.
Ctrl + ↑ Move to the first occupied cell above the current cell. If there is no such occupied cell, the pointer goes to the cell at the top of the column.
Ctrl + ↓ Move to the first occupied cell below the current cell. If there is no such occupied cell, the pointer goes to the cell at the bottom of the column.
Ctrl + Page Down Move to the last occupied cell in the next worksheet of that workbook.
Ctrl + Page Up Move to the last occupied cell in the previous worksheet of that workbook.
Navigation Keyboard shortcuts using the End Key
To use these shortcut combinations press the END key, release it and then press the other key in the combination i.e. both the keys will be pressed one after another. This is symbolized by the ‘~’ sign.
Note # When we press the End key Excel enters the END MODE which is indicated on the status bar and it shows that Excel is waiting for another keystroke.
End ~ Home Move to the last cell of the active area of the worksheet i.e. last cell of that area of the worksheet that has some data.
End ~ → Move to the first occupied cell to the right of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very end of the row.
End ~ ← Move to the first occupied cell to the left of the current cell. If there is no such occupied cell, the pointer goes to the cell at the very beginning of the row.row.
End ~ ↑ Move to the first occupied cell above the current cell. If there is no such occupied cell, the pointer goes to the cell at the top of the column.
End ~ ↓ Move to the first occupied cell below the current cell. If there is no such occupied cell, the pointer goes to the cell at the bottom of the column..
Conclusion
It is advised that users should go through all these keyboard shortcuts and practice them again and agian untill these shortcuts become a part of your habit. This is very important for working swiftly with excel. These shortcuts will save a lot of your time and energy and straightaway increase your productivity manifolds.