If you incorporate keyboard shortcuts for Microsoft Excel, you will save time.
An Excel spreadsheet can be huge and awkward to navigate without these keyboard shortcuts. Using your mouse for navigation will increase the time it takes to complete even basic tasks in Microsoft Excel.
Incorporate these shortcuts and see how much time you save.
The chart below summarizes some Keyboard Shortcuts to Move around Microsoft Excel.
| Keyboard Shortcuts for Navigation | |||
|---|---|---|---|
| Press | Moves to… | ||
| Ctrl + Home | Cell A1 | ||
| Ctrl + End | Last cell in the worksheet with data | ||
| Home | Beginning of the current row | ||
| ↑ (up arrow) | Up one cell at at time | ||
| ↓ (down arrow) | Down one cell at at time | ||
| ← (left arrow) | Left one cell at at time | ||
| → (right arrow) | Right one cell at at time | ||
| Ctrl + ← (left arrow) | First cell in the current row that contains data | ||
| Ctrl + → (right arrow) | Last cell in the current row that contains data | ||
| Ctrl + ↑ (up arrow) | First cell in the current column that contains data | ||
| Ctrl + ↓ (down arrow) | Last cell in the current column that contains data | ||
| Page Up | Cell one screen up in a worksheet | ||
| Page Down | Cell one screen down in a worksheet | ||
| Ctrl + Page Up | Previous worksheet in workbook | ||
| Ctrl + Page Down | Next worksheet in workbook | ||
| Alt + Page Up | Cell one screen to the left in a worksheet | ||
| Alt + Page Down | Cell one screen to the right in a worksheet | ||
Please share this chart with others.