LibreOffice Calc keyboard shortcuts for Windows, Linux and Mac

Keys for the cells, formulas and sheets of LibreOffice Calc, from the "Shortcut Keys for Spreadsheets" topic of the LibreOffice 26.8 Help. The help writes each binding twice in one cell, for Windows and Linux and for macOS, and both appear here as columns. Keys shared by every LibreOffice module stay on the general list. Formula work relies on F2, F4 and Alt + Enter; the last section works only in the Pivot Table Layout dialog.

95 shortcuts in 9 sections. Checked row by row against LibreOffice 26.8 Help on . Edited by Jay.

Cursor movement 14

ActionWindows / LinuxMac
Go to cell A1Jumps to the very first cell of the sheet from anywhere.Ctrl+HomeCmd+Home
Go to last cell with dataCtrl+EndCmd+End
Go to start of rowStays in the same row and jumps to its first cell.HomeHome
Go to last column with dataThe column is the last one holding data in any row, not only the row of the cursor.EndEnd
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+LeftCmd+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+RightCmd+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+UpCmd+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+DownCmd+Down
Previous SheetReturns to the cell that was last active there; in print preview it shows the previous print page.Ctrl+Page UpCmd+Page Up
Next SheetLands on the remembered active cell of that sheet; in print preview it shows the next print page.Ctrl+Page DownCmd+Page Down
Move one screen leftAlt+Page UpOption+Page Up
Move one screen rightAlt+Page DownOption+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+F2Cmd+Shift+F2
Go to Name BoxLeaves the Input line for the Name Box; the help gives both chords for it.Ctrl+Shift+F5orCtrl+Shift+TCmd+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.

ActionWindows / LinuxMac
Select to First Cell of RowShift+HomeShift+Home
Select to last column with dataThe selection ends at the last column holding data in any row of the sheet.Shift+EndShift+End
Select one page upStays in the current column, or grows an existing selection by one page upwards.Shift+Page UpShift+Page Up
Select one page downStays in the current column, or grows an existing selection by one page downwards.Shift+Page DownShift+Page Down
Select Current RowWith a selection already made, it widens to every row that selection touches.Shift+SpaceShift+Space
Select Current ColumnWith a selection already made, it widens to every column that selection touches.Ctrl+SpaceCmd+Space
Select all cellsCtrl+Shift+SpaceCmd+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 keysCmd+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+ACmd+*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.F8F8
Select multiple cell areasEach drag with the modifier held adds another area of the sheet to the selection.Ctrl+DragCmd+Drag

Entering and editing cells 13

ActionWindows / LinuxMac
Edit Cell ContentsPressing it again switches the arrow keys between picking ranges on the sheet and moving within the formula text.F2F2
Cycle Absolute/Relative ReferencesSteps a reference in the input field through forms such as A1, $A$1, $A1 and A$1.F4F4
Move down in selected rangeThe direction follows the Press Enter to move selection option in the Calc General settings.EnterReturn
Paste after copying cellsOnly applies right after a copy, while nothing else in the file has been edited.EnterReturn
Reverse Enter movementMoves opposite to the configured Enter direction; right after a copy it pastes the clipboard instead.Shift+EnterShift+Return
Fill range with formulaPuts the formula typed on the Input line into every cell of the selected range.Alt+EnterOption+Return
Enter array formulaCreates a matrix from the Input line entry; its individual components cannot be edited afterwards.Ctrl+Shift+EnterCmd+Shift+Return
Insert manual line breakClick in the cell first; the break starts a new line inside that cell.Ctrl+EnterCmd+Return
Open Delete Contents dialogThe dialog asks which kinds of content to remove from the selected cells.BackspaceBackspace
Delete cell contentsClears the selected cells at once, with no dialog in between.DeleteDelete
Cut contents, keep formatThe source cells lose their contents but keep their formatting.Ctrl+Shift+XCmd+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.

ActionWindows / LinuxMac
Show cell commentCtrl+F1Cmd+F1
Open Function WizardCtrl+F2Cmd+F2
Open Define Names dialogCtrl+F3Cmd+F3
Show or hide Database explorerCtrl+Shift+F4Cmd+Shift+F4
Show or hide NavigatorF5F5
Trace DependentsShift+F5Shift+F5
Trace PrecedentsShift+F9Shift+F9
Open Styles WindowLists formatting styles for cell contents or the current sheet; the Mac key is a letter chord.F11Cmd+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

ActionWindows / LinuxMac
Increase row heightNeeds the legacy OpenOffice.org compatibility mode to be switched on.Alt+DownOption+Down
Decrease row heightHas an effect only while the legacy OpenOffice.org compatibility mode is active.Alt+UpOption+Up
Increase column widthAlt+RightOption+Right
Decrease column widthAlt+LeftOption+Left
Fit column or row to cellUses the current cell as the measure for the optimal width or height.Alt+Shift+Arrow keysOption+Shift+Arrow keys

Sheets 6

ActionWindows / LinuxMac
Add Previous Sheet to SelectionThat sheet becomes the current one; if every sheet was selected, only it stays selected.Ctrl+Shift+Page UpCmd+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 DownCmd+Shift+Page Down
Select multiple sheetsClick the name tabs below the workspace while holding the modifier.Ctrl+ClickCmd+Click
Select only one sheetUsed on a name tab when several sheets are already selected.Shift+ClickShift+Click
Copy sheetDrag the sheet tab; the copy is placed where the mouse button is let go.Ctrl+DragCmd+Drag
Rename sheetClick the sheet tab to make its name editable, then confirm with Enter.Alt+ClickOption+Click

Function keys 10

ActionWindows / LinuxMac
Check spellingF7F7
Open ThesaurusNeeds text in the current cell.Ctrl+F7Cmd+F7
Highlight cells with valuesCtrl+F8Cmd+F8
Recalculate changed formulasApplies to the current sheet only.F9F9
Recalculate all formulasCovers every sheet of the spreadsheet, not just the one in view.Ctrl+Shift+F9Cmd+Shift+F9
Update selected chartCtrl+F9Cmd+F9
Create document templateShift+F11Shift+F11
Update templatesCtrl+Shift+F11Cmd+Shift+F11
Group selected data rangeF12F12
Ungroup selected data rangeCtrl+F12Cmd+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".

ActionWindows / LinuxMac
Open Format Cells dialogCtrl+1Cmd+1
Number with thousands separatorShows two decimal places; press the digit on the main keyboard row.Ctrl+Shift+1Cmd+Shift+1
Standard exponential formatCtrl+Shift+2Cmd+Shift+2
Standard date formatCtrl+Shift+3Cmd+Shift+3
Standard currency formatCtrl+Shift+4Cmd+Shift+4
Standard percentage formatDisplays the value as a percentage with two decimal places.Ctrl+Shift+5Cmd+Shift+5
Standard formatCtrl+Shift+6Cmd+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.

ActionWindows / LinuxMac
Move Focus Forward in DialogSteps to the next area or button of the Pivot Table Layout dialog.TabTab
Move Focus Backward in DialogSteps to the previous area or button of the Pivot Table Layout dialog.Shift+TabShift+Tab
Move focus up one itemUpUp
Move focus down one itemDownDown
Move focus one item leftLeftLeft
Move focus one item rightRightRight
Select first item in areaHomeHome
Select last item in areaEndEnd
Send field to Row FieldsType the letter underlined in the Row Fields label; the current field is copied or moved there.Alt+underlined characterOption+underlined character
Send field to Column FieldsAlt+underlined characterOption+underlined character
Send field to Data FieldsAlt+underlined characterOption+underlined character
Send field to FiltersAlt+underlined characterOption+underlined character
Move field up one placeCtrl+UpCmd+Up
Move field down one placeCtrl+DownCmd+Down
Move field one place leftCtrl+LeftCmd+Left
Move field one place rightCtrl+RightCmd+Right
Move field to first placeCtrl+HomeCmd+Home
Move field to last placeCtrl+EndCmd+End
Remove field from areaDeleteDelete

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

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.