LibreOffice Calc Keyboard Shortcuts

Cheat sheet guide

LibreOffice Calc shortcuts worth learning first

This page collects 92 searchable LibreOffice Calc keyboard shortcuts across 4 categories. Start with the shortcuts for File & Edit, Cells & Formulas, Navigation & Selection, Formatting, then print the cheat sheet once the important ones are worth keeping nearby.

New spreadsheetCtrlN
Edit cellF2
Go to cell A1CtrlHome
BoldCtrlB
OpenCtrlO
SaveCtrlS

File & Edit

13 shortcuts

New spreadsheet

CtrlN

Ctrl+N · Cmd+N

Open

CtrlO

Ctrl+O · Cmd+O

Save

CtrlS

Ctrl+S · Cmd+S

CtrlP

Ctrl+P · Cmd+P

Undo

CtrlZ

Ctrl+Z · Cmd+Z

Redo

CtrlY

Ctrl+Y · Cmd+Y

Cut

CtrlX

Ctrl+X · Cmd+X

Copy

CtrlC

Ctrl+C · Cmd+C

Paste

CtrlV

Ctrl+V · Cmd+V

Paste special

CtrlShiftV

Ctrl+Shift+V · Cmd+Shift+V

After copying cells: paste with Enter

Enter

Enter

Check spelling in current sheet

F7

Open thesaurus for cell text

CtrlF7

Ctrl+F7 · Cmd+F7

Cells & Formulas

21 shortcuts

Edit cell

F2

Insert sum

Alt=

Alt+= · Opt+=

Confirm and stay

AltEnter

Alt+Enter · Opt+Enter

Insert current date

Ctrl;

Ctrl+; · Cmd+;

Insert current time

CtrlShift;

Ctrl+Shift+; · Cmd+Shift+;

Toggle absolute reference

ShiftF4

Shift+F4

Recalculate

F9

Show formulas

Ctrl`

Ctrl+` · Cmd+`

Focus formula input line

CtrlShiftF2

Ctrl+Shift+F2 · Shift+Cmd+F2

Delete selected cells

Ctrl-

Ctrl+- · Cmd+-

Show current cell comment

CtrlF1

Ctrl+F1 · Cmd+F1

Open Define Names dialog

CtrlF3

Ctrl+F3 · Cmd+F3

Open Function Wizard

CtrlF2

Ctrl+F2 · Cmd+F2

Trace dependent cells

ShiftF5

Shift+F5

Trace precedent cells

ShiftF9

Shift+F9

Insert cells

Ctrl+

Ctrl++ · Cmd++

Toggle value highlighting

CtrlF8

Ctrl+F8 · Cmd+F8

Recalculate all formulas in all sheets

CtrlShiftF9

Ctrl+Shift+F9 · Shift+Cmd+F9

Update selected chart

CtrlF9

Ctrl+F9 · Cmd+F9

Group selected data range

F12

F12

Ungroup selected data range

CtrlF12

Ctrl+F12 · Cmd+F12

Navigation & Selection

42 shortcuts

Go to cell A1

CtrlHome

Ctrl+Home · Cmd+Home

Go to last cell

CtrlEnd

Ctrl+End · Cmd+End

Jump to data edge

CtrlArrow

Select whole column

CtrlSpace

Ctrl+Space

Select whole row

ShiftSpace

Shift+Space

Select all

CtrlA

Ctrl+A · Cmd+A

Next sheet

CtrlPageDown

Ctrl+PageDown · Cmd+PageDown

Previous sheet

CtrlPageUp

Ctrl+PageUp · Cmd+PageUp

Move to current row start

Home

Home

Move to last populated column

End

End

Scroll one screen left

AltPageUp

Alt+PageUp · Opt+PageUp

Scroll one screen right

AltPageDown

Alt+PageDown · Opt+PageDown

Focus Name Box from input line

CtrlShiftF5

Ctrl+Shift+F5 · Shift+Cmd+F5

Extend cell selection to row start

ShiftHome

Shift+Home

Extend cell selection to last populated column

ShiftEnd

Shift+End

Extend cell selection one screen up

ShiftPageUp

Shift+PageUp

Extend cell selection one screen down

ShiftPageDown

Shift+PageDown

Extend selection to data block edge

CtrlShift←(arrowkeys)CtrlShift→(arrowkeys)CtrlShift↑(arrowkeys)CtrlShift↓(arrowkeys)

Ctrl+Shift+← · Ctrl+Shift+→ · Ctrl+Shift+↑ · Ctrl+Shift+↓ · Shift+Cmd+← · Shift+Cmd+→ · Shift+Cmd+↑ · Shift+Cmd+↓

Select current data block with numeric keypad

Ctrl*(numerickeypad)

Ctrl+* · Cmd+*

Select matrix formula range with numeric keypad

Ctrl/(numerickeypad)

Ctrl+/ · Cmd+/

Selection: move to next cell

Enter

Enter

Selection: move to previous cell or paste

ShiftEnter

Shift+Enter

Toggle additional cell selection mode

F8

Toggle data source explorer

CtrlShiftF4

Ctrl+Shift+F4 · Shift+Cmd+F4

Toggle Navigator

F5

Extend sheet selection to previous sheet

CtrlShiftPageUp

Ctrl+Shift+PageUp · Shift+Cmd+PageUp

Extend sheet selection to next sheet

CtrlShiftPageDown

Ctrl+Shift+PageDown · Shift+Cmd+PageDown

Pivot dialog: focus next area or button

Tab

Tab

Pivot dialog: focus previous area or button

ShiftTab

Shift+Tab

Pivot dialog: focus item above

↑

Pivot dialog: focus item below

↓

Pivot dialog: focus item left

←

Pivot dialog: focus item right

→

Pivot dialog: focus first item

Home

Home

Pivot dialog: focus last item

End

End

Pivot dialog: move field up

Ctrl↑

Ctrl+↑ · Cmd+↑

Pivot dialog: move field down

Ctrl↓

Ctrl+↓ · Cmd+↓

Pivot dialog: move field left

Ctrl←

Ctrl+← · Cmd+←

Pivot dialog: move field right

Ctrl→

Ctrl+→ · Cmd+→

Pivot dialog: move field first

CtrlHome

Ctrl+Home · Cmd+Home

Pivot dialog: move field last

CtrlEnd

Ctrl+End · Cmd+End

Pivot dialog: remove current field

Delete

Delete · Backspace

Formatting

16 shortcuts

Bold

CtrlB

Ctrl+B · Cmd+B

Italic

CtrlI

Ctrl+I · Cmd+I

Underline

CtrlU

Ctrl+U · Cmd+U

Format cells

Ctrl1

Ctrl+1 · Cmd+1

Find & Replace

CtrlH

Ctrl+H · Cmd+Opt+F

Find

CtrlF

Ctrl+F · Cmd+F

Increase current column width

Alt→

Alt+→ · Opt+→

Decrease current column width

Alt←

Alt+← · Opt+←

Optimize column width or row height

AltShift←(arrowkeys)AltShift→(arrowkeys)AltShift↑(arrowkeys)AltShift↓(arrowkeys)

Alt+Shift+← · Alt+Shift+→ · Alt+Shift+↑ · Alt+Shift+↓ · Opt+Shift+← · Opt+Shift+→ · Opt+Shift+↑ · Opt+Shift+↓

Toggle Styles window

F11

F11 · Cmd+T

Apply number format with two decimals

CtrlShift1

Ctrl+Shift+1 · Shift+Cmd+1

Apply scientific number format

CtrlShift2

Ctrl+Shift+2 · Shift+Cmd+2

Apply standard date format

CtrlShift3

Ctrl+Shift+3 · Shift+Cmd+3

Apply standard currency format

CtrlShift4

Ctrl+Shift+4 · Shift+Cmd+4

Apply percentage format with two decimals

CtrlShift5

Ctrl+Shift+5 · Shift+Cmd+5

Apply standard number format

CtrlShift6

Ctrl+Shift+6 · Shift+Cmd+6

Documentation check for this addition

60 additional actions were checked against the official documentation on 2026-11-05. Existing actions were retained. These are documentary checks, not tests in installed applications. A dash means this batch does not provide a verified binding for that system. Context such as PDF viewer, text field or address bar is part of the action.

LibreOffice Calc