Cursor movement 14
| Action | Windows / Linux | Mac |
|---|---|---|
| Go to cell A1Jumps to the very first cell of the sheet from anywhere. | Ctrl+Home | Cmd+Home |
| Go to last cell with data | Ctrl+End | Cmd+End |
| Go to start of rowStays in the same row and jumps to its first cell. | Home | Home |
| Go to last column with dataThe column is the last one holding data in any row, not only the row of the cursor. | End | End |
| Move to Edge of Data Block (Left)From an empty cell it stops at the next filled cell, or at the first cell of the row when none is found. | Ctrl+Left | Cmd+Left |
| Move to Edge of Data Block (Right)From an empty cell it stops at the next filled cell, or at the last cell of the row when none is found. | Ctrl+Right | Cmd+Right |
| Move to Edge of Data Block (Up)From an empty cell it stops at the next filled cell, or at the top of the column when none is found. | Ctrl+Up | Cmd+Up |
| Move to Edge of Data Block (Down)From an empty cell it stops at the next filled cell, or at the bottom of the column when none is found. | Ctrl+Down | Cmd+Down |
| Previous SheetReturns to the cell that was last active there; in print preview it shows the previous print page. | Ctrl+Page Up | Cmd+Page Up |
| Next SheetLands on the remembered active cell of that sheet; in print preview it shows the next print page. | Ctrl+Page Down | Cmd+Page Down |
| Move one screen left | Alt+Page Up | Option+Page Up |
| Move one screen right | Alt+Page Down | Option+Page Down |
| Go to Input LinePuts the cursor in the Input line so that a formula can be typed for the current cell. | Ctrl+Shift+F2 | Cmd+Shift+F2 |
| Go to Name BoxLeaves the Input line for the Name Box; the help gives both chords for it. | Ctrl+Shift+F5orCtrl+Shift+T | Cmd+Shift+F5orCmd+Shift+T |
Selection 12
If the operating system or desktop already uses one of these chords, it never gets through to Calc. The help's remedy is to give the command a different key, either in Calc under Tools - Customize - Keyboard or in the desktop's own settings.
| Action | Windows / Linux | Mac |
|---|---|---|
| Select to First Cell of Row | Shift+Home | Shift+Home |
| Select to last column with dataThe selection ends at the last column holding data in any row of the sheet. | Shift+End | Shift+End |
| Select one page upStays in the current column, or grows an existing selection by one page upwards. | Shift+Page Up | Shift+Page Up |
| Select one page downStays in the current column, or grows an existing selection by one page downwards. | Shift+Page Down | Shift+Page Down |
| Select Current RowWith a selection already made, it widens to every row that selection touches. | Shift+Space | Shift+Space |
| Select Current ColumnWith a selection already made, it widens to every column that selection touches. | Ctrl+Space | Cmd+Space |
| Select all cells | Ctrl+Shift+Space | Cmd+Shift+Space |
| Select to edge of data blockCovers the cells that the matching data-block jump crosses; combining rows and columns selects a rectangle. | Ctrl+Shift+Arrow keys | Cmd+Shift+Arrow keys |
| Select data blockThe block is the filled range around the cursor, bounded by empty rows and columns; * is the numeric keypad key. | Ctrl+*orCtrl+A | Cmd+*orCmd+A |
| Select matrix formula rangeWorks with the cursor inside an array formula; / is the division key of the numeric keypad. | Ctrl+/ | Cmd+/ |
| Toggle Additional Selection ModeWhile it is on, arrow keys or a click on another cell extend the selection. | F8 | F8 |
| Select multiple cell areasEach drag with the modifier held adds another area of the sheet to the selection. | Ctrl+Drag | Cmd+Drag |
Entering and editing cells 13
| Action | Windows / Linux | Mac |
|---|---|---|
| Edit Cell ContentsPressing it again switches the arrow keys between picking ranges on the sheet and moving within the formula text. | F2 | F2 |
| Cycle Absolute/Relative ReferencesSteps a reference in the input field through forms such as A1, $A$1, $A1 and A$1. | F4 | F4 |
| Move down in selected rangeThe direction follows the Press Enter to move selection option in the Calc General settings. | Enter | Return |
| Paste after copying cellsOnly applies right after a copy, while nothing else in the file has been edited. | Enter | Return |
| Reverse Enter movementMoves opposite to the configured Enter direction; right after a copy it pastes the clipboard instead. | Shift+Enter | Shift+Return |
| Fill range with formulaPuts the formula typed on the Input line into every cell of the selected range. | Alt+Enter | Option+Return |
| Enter array formulaCreates a matrix from the Input line entry; its individual components cannot be edited afterwards. | Ctrl+Shift+Enter | Cmd+Shift+Return |
| Insert manual line breakClick in the cell first; the break starts a new line inside that cell. | Ctrl+Enter | Cmd+Return |
| Open Delete Contents dialogThe dialog asks which kinds of content to remove from the selected cells. | Backspace | Backspace |
| Delete cell contentsClears the selected cells at once, with no dialog in between. | Delete | Delete |
| Cut contents, keep formatThe source cells lose their contents but keep their formatting. | Ctrl+Shift+X | Cmd+Shift+X |
| Insert CellsRuns the Insert - Cells menu command at the current selection. | Ctrl++ | Cmd++ |
| Delete CellsRuns the Delete Cells menu command on the current selection. | Ctrl+- | Cmd+- |
Open, display or hide 9
On a keyboard without a ` key, Show Formulas can be given another key under Tools - Customize, Keyboard tab, in the View category.
| Action | Windows / Linux | Mac |
|---|---|---|
| Show cell comment | Ctrl+F1 | Cmd+F1 |
| Open Function Wizard | Ctrl+F2 | Cmd+F2 |
| Open Define Names dialog | Ctrl+F3 | Cmd+F3 |
| Show or hide Database explorer | Ctrl+Shift+F4 | Cmd+Shift+F4 |
| Show or hide Navigator | F5 | F5 |
| Trace Dependents | Shift+F5 | Shift+F5 |
| Trace Precedents | Shift+F9 | Shift+F9 |
| Open Styles WindowLists formatting styles for cell contents or the current sheet; the Mac key is a letter chord. | F11 | Cmd+T |
| Show FormulasToggles every cell between its formula and its value; the key sits beside 1 on most English keyboards. | Ctrl+` | Cmd+` |
Row height and column width 5
| Action | Windows / Linux | Mac |
|---|---|---|
| Increase row heightNeeds the legacy OpenOffice.org compatibility mode to be switched on. | Alt+Down | Option+Down |
| Decrease row heightHas an effect only while the legacy OpenOffice.org compatibility mode is active. | Alt+Up | Option+Up |
| Increase column width | Alt+Right | Option+Right |
| Decrease column width | Alt+Left | Option+Left |
| Fit column or row to cellUses the current cell as the measure for the optimal width or height. | Alt+Shift+Arrow keys | Option+Shift+Arrow keys |
Sheets 6
| Action | Windows / Linux | Mac |
|---|---|---|
| Add Previous Sheet to SelectionThat sheet becomes the current one; if every sheet was selected, only it stays selected. | Ctrl+Shift+Page Up | Cmd+Shift+Page Up |
| Add Next Sheet to SelectionThe next sheet becomes current; with all sheets selected, the selection shrinks to it alone. | Ctrl+Shift+Page Down | Cmd+Shift+Page Down |
| Select multiple sheetsClick the name tabs below the workspace while holding the modifier. | Ctrl+Click | Cmd+Click |
| Select only one sheetUsed on a name tab when several sheets are already selected. | Shift+Click | Shift+Click |
| Copy sheetDrag the sheet tab; the copy is placed where the mouse button is let go. | Ctrl+Drag | Cmd+Drag |
| Rename sheetClick the sheet tab to make its name editable, then confirm with Enter. | Alt+Click | Option+Click |
Function keys 10
| Action | Windows / Linux | Mac |
|---|---|---|
| Check spelling | F7 | F7 |
| Open ThesaurusNeeds text in the current cell. | Ctrl+F7 | Cmd+F7 |
| Highlight cells with values | Ctrl+F8 | Cmd+F8 |
| Recalculate changed formulasApplies to the current sheet only. | F9 | F9 |
| Recalculate all formulasCovers every sheet of the spreadsheet, not just the one in view. | Ctrl+Shift+F9 | Cmd+Shift+F9 |
| Update selected chart | Ctrl+F9 | Cmd+F9 |
| Create document template | Shift+F11 | Shift+F11 |
| Update templates | Ctrl+Shift+F11 | Cmd+Shift+F11 |
| Group selected data range | F12 | F12 |
| Ungroup selected data range | Ctrl+F12 | Cmd+F12 |
Number formatting 7
The format chords use the digit row of the main keyboard; the help heads their key column "not on the number pad".
| Action | Windows / Linux | Mac |
|---|---|---|
| Open Format Cells dialog | Ctrl+1 | Cmd+1 |
| Number with thousands separatorShows two decimal places; press the digit on the main keyboard row. | Ctrl+Shift+1 | Cmd+Shift+1 |
| Standard exponential format | Ctrl+Shift+2 | Cmd+Shift+2 |
| Standard date format | Ctrl+Shift+3 | Cmd+Shift+3 |
| Standard currency format | Ctrl+Shift+4 | Cmd+Shift+4 |
| Standard percentage formatDisplays the value as a percentage with two decimal places. | Ctrl+Shift+5 | Cmd+Shift+5 |
| Standard format | Ctrl+Shift+6 | Cmd+Shift+6 |
Pivot table 19
These keys act inside the Pivot Table Layout dialog only. On the sheet, Ctrl with an arrow key, Home or End moves the cell cursor instead.
| Action | Windows / Linux | Mac |
|---|---|---|
| Move Focus Forward in DialogSteps to the next area or button of the Pivot Table Layout dialog. | Tab | Tab |
| Move Focus Backward in DialogSteps to the previous area or button of the Pivot Table Layout dialog. | Shift+Tab | Shift+Tab |
| Move focus up one item | Up | Up |
| Move focus down one item | Down | Down |
| Move focus one item left | Left | Left |
| Move focus one item right | Right | Right |
| Select first item in area | Home | Home |
| Select last item in area | End | End |
| Send field to Row FieldsType the letter underlined in the Row Fields label; the current field is copied or moved there. | Alt+underlined character | Option+underlined character |
| Send field to Column Fields | Alt+underlined character | Option+underlined character |
| Send field to Data Fields | Alt+underlined character | Option+underlined character |
| Send field to Filters | Alt+underlined character | Option+underlined character |
| Move field up one place | Ctrl+Up | Cmd+Up |
| Move field down one place | Ctrl+Down | Cmd+Down |
| Move field one place left | Ctrl+Left | Cmd+Left |
| Move field one place right | Ctrl+Right | Cmd+Right |
| Move field to first place | Ctrl+Home | Cmd+Home |
| Move field to last place | Ctrl+End | Cmd+End |
| Remove field from area | Delete | Delete |
No row on this page matches that filter.
Notes
Same as Excel
Ctrl + Left, Ctrl + Right, Ctrl + Up and Ctrl + Down jump to the edge of the current block, Ctrl + Home to A1 and Ctrl + End to the last used cell. Shift + Space and Ctrl + Space select the row and column. F2 edits the cell and F4 cycles a reference between relative and absolute forms. Sheets are switched with Ctrl + Page Up or Ctrl + Page Down, Ctrl + 1 opens Format Cells and Ctrl + - deletes cells through a dialog that asks for the shift direction.
Different from Excel
Number formats use Ctrl + Shift + digits as in Excel, but three of them map differently: Ctrl + Shift + 2 is the exponential format, Ctrl + Shift + 5 a percentage with two decimal places and Ctrl + Shift + 6 resets to the standard format. Ctrl + Shift + 1 (two decimals with a thousands separator), Ctrl + Shift + 3 (date) and Ctrl + Shift + 4 (currency) match. Ctrl + Enter and Alt + Enter trade places: the first breaks the line inside a cell, the second fills the selected range with the formula. Ctrl + + inserts cells without Shift. Ctrl + F2 opens the Function Wizard, Ctrl + F3 the Define Names dialog, and Ctrl + Shift + F2 moves the cursor to the input line. F9 recalculates the sheet and Ctrl + Shift + F9 every sheet.
Auditing and structure
Shift + F5 draws arrows to the cells that depend on the current one and Shift + F9 to the cells it depends on — the trace tools that Excel hides in a ribbon tab. Ctrl + F8 highlights values, formulas and text in different colours across the sheet, a quick way to spot a hardcoded number in a formula column. F12 groups the selected rows or columns for an outline and Ctrl + F12 ungroups. Ctrl + F1 shows the comment on the current cell and F5 opens the Navigator for sheets, ranges and objects.
Questions
Which Excel shortcuts work in Calc?
Navigation and selection keys, F2, F4, Ctrl + 1 and Ctrl + - all match. Ctrl + Enter and Alt + Enter swap roles, cells are inserted with Ctrl + + without Shift, and Ctrl + Shift + 2, 5 and 6 apply different number formats.
How do I trace what a formula depends on?
Shift + F9 draws arrows from the precedent cells; Shift + F5 shows the dependents. Both are in Tools › Detective.
How do I find cells that contain typed numbers instead of formulas?
Ctrl + F8 highlights values, formulas and text in distinct colours.
How do I insert or delete cells?
Ctrl + + inserts and Ctrl + - deletes; each opens a dialog asking which way to shift the neighbours.
Sources and checks
- LibreOffice 26.8 Help — Shortcut Keys for Spreadsheets All rows. The help prints the Windows / Linux key and the macOS key of each row in the same table cell; both columns are read from it.
Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.
Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.