Spreadsheet navigation: We can move around a worksheet through four arrow keys
1. Left-arrow key
2. Right arrow key
3. Up arrow key
4. Down arrow key
The mouse can also be used for navigation in a spreadsheet except for data entry. Some common operations/navigations are listed below:
| Movement |
Keystroke (Press key) |
| One cell up |
Up arrow key/shift + Enter key |
| One cell down |
Down arrow key/Enter key |
| One cell right |
Right Arrow key/Tab key |
| One cell left |
Left arrow key/shift + tab key |
| Top of sheet (cell A1) |
Ctrl + Home key |
| Move to last cell containing data |
Ctrl + End key |
| Move to beginning of the row |
Home key or Ctrl + left arrow key |
| Move to last filled Cell in column |
End key |
