At times, an Excel spreadsheet may be so large that it is difficult to navigate. And using the mouse for navigation may increase the time it takes to complete even the most basic tasks in Excel.
By implementing Excel keyboard shortcuts:
* you can easily move around large spreadsheets with ease
* you can decrease the time it takes to complete common tasks
Incorporate these shortcuts and see how much time you save.
Keyboard Shortcuts for Excel Navigation
Press
Moves…
Enter
Down one cell at a time
Tab
Right one cell at a time
Shift + Tab
Left one cell at a time
Shift + Enter
Up one cell at a time
Ctrl + Home
Cell A1
Ctrl + End
Last cell in the worksheet that contains data
Home
Beginning of the current row
↑
Up one cell at a time
↓
Down one cell at a time
←
Left one cell at a time
→
Right one cell at a time
Ctrl + ←
First cell in the current row that contains data
Ctrl + →
Last cell in the current row that contains data
Ctrl + ↑
First cell in the current column that contains data
Ctrl + ↓
Last cell in the current column that contains data
Page Up
One screen up in a worksheet
Page Down
One screen down in a worksheet
Ctrl + Page Up
Previous worksheet in the workbook
Ctrl + Page Down
Next worksheet in the workbook
Alt + Page Up
One screen to the left in a worksheet
Alt + Page Down
One screen to the right in a worksheet
Ctrl + G or F5
Displays the GoTo dialog box,
Here you can quickly move to a cell reference, range name, bookmark,
Or you can use the Special button to find specific information (comments, formulas, blanks, etc.)
Please share this with other Excel users and save them hours of time.
~ Let Microsoft Excel do the work for you. ~
0 Comments