Keyboard navigation
Pressing a key or a combination of keys allows you to navigate a spreadsheet using the keyboard. A key combination is where you press more than one key together, for example Ctrl+Home key combination to move to cell A1. Table 1 lists the keys and key combinations you can use for spreadsheet navigation in Calc.
Table 1: Keyboard cell navigation
Keyboard shortcut | Cell navigation |
---|---|
→ | Moves cell focus right one cell |
← | Moves cell focus left one cell |
↑ | Moves cell focus up one cell |
↓ | Moves cell focus down one cell |
Ctrl+→ | Moves cell focus to the first column on the right containing data in that row if cell focus is on a blank cell. |
Ctrl+← | Moves cell focus to the last column on the left containing data in that row if cell focus is on a blank cell. |
Ctrl+↑ | Moves cell focus from a blank cell to the first cell above containing data in the same column. |
Ctrl+↓ | Moves cell focus from a blank cell to the first cell below containing data in the same column. |
Ctrl+Home | Moves cell focus from anywhere on the spreadsheet to Cell A1 on the same sheet. |
Ctrl+End | Moves cell focus from anywhere on the spreadsheet to the last cell in the lower right-hand corner of the rectangular area of cells containing data on the same sheet. |
Alt+Page Down | Moves cell focus one screen to the right (if possible). |
Alt+Page Up | Moves cell focus one screen to the left (if possible). |
Ctrl+Page Down | Moves cell focus to the same cell on the next sheet to the right in sheet tabs if the spreadsheet has more than on sheet. |
Ctrl+Page Up | Moves cell focus to the same cell on the next sheet to the left in sheet tabs if the spreadsheet has more than on sheet. |
Tab | Moves cell focus to the next cell on the right |
Shift+Tab | Moves cell focus to the next cell on the left |
Enter | Down one cell (unless changed by user) |
Shift+Enter | Up one cell (unless changed by user) |