Blocks and structure
1 shortcut
| Action |
Windows |
Mac |
|
Toggle the navigation panel Navigator
|
F5
|
·
Not documented
|
Clipboard
5 shortcuts
| Action |
Windows |
Mac |
|
Copy selection Selection
|
Ctrl + C
|
Cmd + C
|
|
Cut selection Selection
|
Ctrl + X
|
Cmd + X
|
|
Paste clipboard Destination
|
Ctrl + V
|
Cmd + V
|
|
Paste Special Clipboard
|
Ctrl + Shift + V
|
·
Not documented
|
|
Paste plain text Text destination
|
Ctrl + Alt + Shift + V
|
·
Not documented
|
Comments and review
3 shortcuts
| Action |
Windows |
Mac |
|
Move to the following sheet Worksheet, not print preview
|
Ctrl + Page Down
|
·
Not documented
|
|
Move to the preceding sheet Worksheet, not print preview
|
Ctrl + Page Up
|
·
Not documented
|
|
Show comment Commented cell
|
Ctrl + F1
|
·
Not documented
|
Editing
5 shortcuts
| Action |
Windows |
Mac |
|
Edit the current cell Worksheet
|
F2
|
·
Not documented
|
|
Choose which cell contents to erase Delete Contents dialog
|
Backspace
|
·
Not documented
|
|
Name box From input line
|
Ctrl + Shift + F5
|
·
Not documented
|
|
Undo change Editor
|
Ctrl + Z
|
·
Not documented
|
|
Redo change Editor
|
Ctrl + Y
|
·
Not documented
|
Files and printing
4 shortcuts
| Action |
Windows |
Mac |
|
Open document File
|
Ctrl + O
|
·
Not documented
|
|
New document File
|
Ctrl + N
|
·
Not documented
|
|
Save document File
|
Ctrl + S
|
·
Not documented
|
|
Print File
|
Ctrl + P
|
·
Not documented
|
Formulas and data
8 shortcuts
| Action |
Windows |
Mac |
|
Build a formula with guidance Function Wizard
|
Ctrl + F2
|
·
Not documented
|
|
Define a named range Define Names dialog
|
Ctrl + F3
|
·
Not documented
|
|
Trace dependents Formula cell
|
Shift + F5
|
·
Not documented
|
|
Trace precedents Formula cell
|
Shift + F9
|
·
Not documented
|
|
Reference locking Formula editing
|
F4
|
·
Not documented
|
|
Recalculate changed Sheet
|
F9
|
·
Not documented
|
|
Recalculate all Workbook
|
Ctrl + Shift + F9
|
·
Not documented
|
|
Percentage format Digit row
|
Ctrl + Shift + 5
|
·
Not documented
|
Navigation
13 shortcuts
| Action |
Windows |
Mac |
|
Jump to cell A1 Worksheet
|
Ctrl + Home
|
·
Not documented
|
|
Jump to the last used cell Worksheet
|
Ctrl + End
|
·
Not documented
|
|
Row start Navigation
|
Home
|
·
Not documented
|
|
Row data end Navigation
|
End
|
·
Not documented
|
|
Block edge left Data navigation
|
Ctrl + Left arrow
|
·
Not documented
|
|
Block edge right Data navigation
|
Ctrl + Right arrow
|
·
Not documented
|
|
Block edge up Data navigation
|
Ctrl + Up arrow
|
·
Not documented
|
|
Block edge down Data navigation
|
Ctrl + Down arrow
|
·
Not documented
|
|
Screen left Worksheet
|
Alt + Page Up
|
·
Not documented
|
|
Screen right Worksheet
|
Alt + Page Down
|
·
Not documented
|
|
Input line Worksheet
|
Ctrl + Shift + F2
|
·
Not documented
|
|
Styles panel Worksheet
|
F11
|
·
Not documented
|
|
Spellcheck Sheet
|
F7
|
·
Not documented
|
Paragraphs and lists
1 shortcut
| Action |
Windows |
Mac |
|
Break a line inside a cell While editing cell text
|
Ctrl + Enter
|
·
Not documented
|
Search
1 shortcut
| Action |
Windows |
Mac |
|
Find Document
|
Ctrl + F
|
·
Not documented
|
Selection
4 shortcuts
| Action |
Windows |
Mac |
|
Select row Selection
|
Shift + Space
|
·
Not documented
|
|
Select column Selection
|
Ctrl + Space
|
·
Not documented
|
|
Select sheet Selection
|
Ctrl + Shift + Space
|
·
Not documented
|
|
Delete cells Selection
|
Ctrl + -
|
·
Not documented
|
Text formatting
1 shortcut
| Action |
Windows |
Mac |
|
Format cells Selection
|
Ctrl + 1
|
·
Not documented
|
From Shortivo at https://shortivo.net/platforms/libreoffice-calc/. A dot means the maker does not document a key for that system. Nothing on this sheet was converted from one system to another.