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)

results matching ""

    No results matching ""