Calc Guide 26.2
Appendix A
Keyboard Shortcuts
This document is Copyright © 2026 by the LibreOffice Documentation Team. Contributors are listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License (https://www.gnu.org/licenses/gpl.html), version 3 or later, or the Creative Commons Attribution License (https://creativecommons.org/licenses/by/4.0/), version 4.0 or later.
All trademarks within this guide belong to their legitimate owners.
Ed Olson
Barbara Duprey, Jean Hollis Weber, Simon Brydon, Richard Barnes, Peter Kupfer, Iain Roberts, Magnus Adielsson, Sandeep Samuel Medikonda, Zachary Parliman, Steve Fanning, Drew Jensen, Gordon Bates, Kees Kriek, Felipe Viggiano, Rafael Lima, Skip Masonsmith, Olivier Hallot.
Please direct any comments or suggestions about this document to the Documentation Team’s forum at https://community.documentfoundation.org/c/documentation/loguides/ (registration is required) or send an email to: loguides@community.documentfoundation.org.
Note
Everything you send to a forum, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. Emails sent to the forum are moderated.
Published February 2026. Based on LibreOffice 26.2.
Other versions of LibreOffice may differ in appearance and functionality.
Calc can be operated entirely through keyboard shortcuts, eliminating the need for a mouse or touch pad. This appendix provides a complete reference list of built-in shortcuts, allowing easy browsing to identify those that enhance daily workflow.
Upon installation, LibreOffice includes a default set of Calc keyboard shortcuts, described in this chapter under the assumption that no customization has been applied. Shortcuts for common actions can be identified by observing key sequences displayed in menu options and toolbar tool tips. A more extensive list is available in the Keyboard tab of the Customize dialog (Tools > Customize).
Additional details about specific key combinations appear throughout this guide and in the Help system.
Shortcuts may be defined or changed using Tools > Customize > Keyboard on the Menu bar. See Chapter 16, Setting up and Customizing, for further instructions. Some shortcuts cannot be re-assigned; these are identified in the “Keyboard shortcuts that cannot be modified” section.
Caution
Be careful when reassigning predefined shortcuts. Although you can reset shortcut keys back to LibreOffice defaults, changing common hotkeys, such as F1 for Help, can cause confusion and frustration, especially if other users share your computer.
Note
Different operating systems may allocate particular keys to operating system functions and, in such cases, those keys may not perform the Calc functions described in this appendix.
For example, the F1 function key may be used to put your Windows computer into a sleep / hibernation mode and so cannot be used to access the Calc Help system. For some macOS versions, the Cmd+F5 key sequence is used by macOS to display its VoiceOver dialog and so cannot be used to control the display of the sidebar. Similarly the Shift+F11 key sequence may be used by macOS to show its desktop and so cannot be used to access the Save as Template dialog in Calc.
Check your computer system’s documentation to determine which key presses are used by the operating system and hence cannot carry out Calc functions.
Keys on many macOS keyboards use symbols rather than text labels. Table 1 identifies some common macOS keyboard symbols with their meanings. In the tables that follow, the key names are used rather than symbols, since the latter may not appear on all macOS keyboards.
Table 1: Common MacOS keyboard keys
|
Key name |
Symbol |
|
Command (shortened to “Cmd” in the tables that follow) |
⌘ |
|
Control (shorted to “Ctrl” in the tables that follow) |
^ |
|
Option |
⌥ |
|
Shift |
⇑ |
|
Page Up (shortened to “Pg Up” in the tables that follow) |
⇞ |
|
Page Down (shortened to “Pg Dn” in the tables that follow) |
⇟ |
|
Home |
↖ |
|
End |
↘ |
|
Delete |
⌫ |
|
Forward Delete (shortened to “Fwd Del” in the tables that follow) |
⌦ |
Table 2: LibreOffice Calc shortcuts
|
Shortcut name |
Keys |
Description and notes |
|
Help |
F1 |
LibreOffice Help |
|
Context Help |
Shift+F1 |
Display context-sensitive help. |
|
Navigator |
F5 |
View > Navigator. |
|
Sidebar |
Ctrl+F5 (Win/Linux) Cmd+F5 (macOS) |
View > Sidebar. |
|
Spelling |
F7 (Win/Linux) Shift+Cmd+; (macOS) |
Tools > Spelling; Standard toolbar icon. |
|
Thesaurus |
Ctrl+F7 (Win/Linux) Cmd+F7 (macOS) |
Tools > Thesaurus. |
|
Hangul/Hanja |
Ctrl+Shift+F7 (Win/Linux) Shift+Cmd+F7 (macOS) |
Tools > Language > Hangul/Hanja Conversion (availability depends on Language Settings). |
|
Auto Spell |
Shift+F7 |
Tools > Automatic Spell Checking. |
|
Recalculate |
F9 |
Data > Calculate > Recalculate. |
|
Hard Recalc |
Ctrl+Shift+F9 (Win/Linux) Shift+Cmd+F9 (macOS) |
Data > Calculate > Recalculate Hard. |
|
Save Template |
Shift+F11 |
File > Templates > Save as Template (via Save icon menu). |
|
Group |
F12 |
Data > Group and Outline > Group. |
|
Ungroup |
Ctrl+F12 (Win/Linux) Cmd+F12 (macOS) |
Data > Group and Outline > Ungroup. |
|
Save As |
Ctrl+Shift+S (Win/Linux) Shift+Cmd+S (macOS) |
File > Save As; via Save icon menu. |
|
Hide App |
Cmd+H (macOS) |
LibreOffice > Hide LibreOffice. |
|
Close Window |
Ctrl+W (Win/Linux) Cmd+W (macOS) |
Window > Close Window. |
|
Preferences |
Alt+F12 (Win/Linux) Cmd+, (macOS) |
Tools > Options. LibreOffice > Preferences. |
|
Search Commands |
Shift+Esc (Win/Linux) |
Help > Search Commands. |
|
Repeat Find |
Cmd+G (macOS) |
Repeat search forwards. |
Table 3: Keys for formatting data
|
Shortcut name |
Keys |
Description and notes |
|
Styles |
F11 (Win/Linux) Cmd+T (macOS) |
View > Styles; Styles > Manage Styles. |
|
Format Cells |
Ctrl+1 (Win/Linux) Cmd+1 (macOS) |
Format > Cells. |
|
Number Format |
Ctrl+Shift+1 (Win/Linux) Cmd+Shift+1 (macOS) |
Format > Number Format > Number (main keyboard 1). Toolbar icon available. |
|
Scientific |
Ctrl+Shift+2 |
Format > Number Format > Scientific (main keyboard 2). |
|
Date |
Ctrl+Shift+3 |
Format > Number Format > Date (main keyboard 3). Toolbar icon available. |
|
Currency |
Ctrl+Shift+4 |
Format > Number Format > Currency (main keyboard 4); toolbar icon available. |
|
Percent |
Ctrl+Shift+5 |
Format > Number Format > Percent (main keyboard 5); toolbar icon available. |
|
General |
Ctrl+Shift+6 |
Format > Number Format > General (main keyboard 6). |
|
Bold |
Ctrl+B (Win/Linux) Cmd+B (macOS) |
Format > Text > Bold; Formatting toolbar icon. |
|
Subscript |
Ctrl+Shift+B (Win/Linux) Shift+Cmd+B (macOS) |
Format > Text > Subscript. |
|
Align Center |
Ctrl+E (Win/Linux) Cmd+E (macOS) |
Format > Align > Centered; toolbar icon. |
|
Italic |
Ctrl+I (Win/Linux) Cmd+I (macOS) |
Format > Text > Italic; toolbar icon. |
|
Align Justify |
Ctrl+J (Win/Linux) Cmd+J (macOS) |
Format > Align > Justified. |
|
Align Center |
Ctrl+E (Win/Linux) Cmd+E (macOS) |
Format > Align > Centered; toolbar icon. |
|
Align Left |
Ctrl+L (Win/Linux) Cmd+L (macOS) |
Format > Align > Left; toolbar icon. |
|
Align Right |
Ctrl+R (Win/Linux) Cmd+R (macOS) |
Format > Align > Right; toolbar icon. |
|
Superscript |
Ctrl+Shift+P (Win/Linux) Shift+Cmd+P (macOS) |
Format > Text > Superscript. |
|
Underline |
Ctrl+U (Win/Linux) Cmd+U (macOS) |
Underline icon on Formatting toolbar. |
Table 4: Keys for moving cursor in workspace
|
Shortcut name |
Keys |
Description and notes |
|
Move Up |
↑ |
Move cell focus up. |
|
Jump Up Edge |
Ctrl+↑ (Win/Linux) Cmd+↑ (macOS) |
Jump to edge of current data range upward. |
|
Move Right |
→ |
Move cell focus right. |
|
Jump Right Edge |
Ctrl+→ (Win/Linux) Cmd+→ (macOS) |
Jump to edge of current data range to the right. |
|
Move Down |
↓ |
Move cell focus down. |
|
Jump Down Edge |
Ctrl+↓ (Win/Linux) Cmd+↓ (macOS) |
Jump to edge of current data range downward. |
|
Move Left |
← |
Move cell focus left. |
|
Jump Left Edge |
Ctrl+← (Win/Linux) Cmd+← (macOS) |
Jump to edge of current data range to the left. |
|
Row First Cell |
Home |
Move to first cell of current row. |
|
Sheet First Cell |
Ctrl+Home (Win/Linux) Cmd+Home (macOS) |
Move to cell A1 in current sheet. |
|
Row Last Data |
End |
Move along row to last column with data. |
|
Sheet Last Data |
Ctrl+End (Win/Linux) Cmd+End (macOS) |
Move to last row/column cell containing data. |
|
Page Up |
PgUp |
Move up one screen page. |
|
Prev Sheet |
Ctrl+PgUp (Win/Linux) Cmd+Pg Up (macOS) |
Move to previous sheet (expert option allows wrap from first to last). |
|
Page Left |
Alt+PgUp (Win/Linux) Option+Pg Dn (macOS) |
Move one screen page left. |
|
Page Down |
PgDown (Win/Linux) Pg Dn (macOS) |
Move down one screen page. |
|
Next Sheet |
Ctrl+PgDown (Win/Linux) Cmd+Pg Dn (macOS) |
Move to next sheet (expert option allows wrap from last to first). |
|
Page Right |
Alt+PgDown (Win/Linux) Option+Pg Up (macOS) |
Move one screen page right. |
|
Refocus Cursor |
Ctrl+Backspace (Win/Linux) Cmd+Delete (macOS) |
Refocus view on cursor. |
|
Move Next in Range |
Enter |
Move to next cell in selection (top→bottom, then left→right); direction configurable in Options/Preferences. |
|
Move to Input |
Ctrl+Shift+F2 (Win/Linux) Shift+Cmd+F2 (macOS) |
Focus Input line (enter formula). |
|
Focus Name Box |
Ctrl+Shift+F5 / Ctrl+Shift+T (Win/Linux) Shift+Cmd+F5 / Shift+Cmd+T (macOS) |
Move cursor to Name Box on Formula bar. |
Table 5: Selection keys
|
Shortcut name |
Keys |
Description and notes |
|
Select Up |
Shift+↑ |
Extend selection upward. |
|
Select Up Edge |
Ctrl+Shift+↑ (Win/Linux) Shift+Cmd+↑ (macOS) |
Select to edge of data range upward. |
|
Select Right |
Shift+→ |
Extend selection rightward. |
|
Select Right Edge |
Ctrl+Shift+→ (Win/Linux) Shift+Cmd+→ (macOS) |
Select to edge of data range rightward. |
|
AutoText List |
Alt+↓ (Win/Linux) Option+↓ (macOS) |
Show drop-down of prior text entries in column. |
|
Select Down |
Shift+↓ |
Extend selection downward. |
|
Select Down Edge |
Ctrl+Shift+↓ (Win/Linux) Shift+Cmd+↓ (macOS) |
Select to edge of data range downward. |
|
Select Left |
Shift+← |
Extend selection leftward. |
|
Select Left Edge |
Ctrl+Shift+← (Win/Linux) Shift+Cmd+← (macOS) |
Select to edge of data range leftward. |
|
Select to Row Start |
Shift+Home |
Select from cursor to first cell of current row. |
|
Select to A1 |
Ctrl+Shift+Home (Win/Linux) Shift+Cmd+Home (macOS) |
Select from cursor to A1 in current sheet. |
|
Select to Row End |
Shift+End |
Select from cursor to last column with data. |
|
Select to Last Data |
Ctrl+Shift+End (Win/Linux) Shift+Cmd+End (macOS) |
Select from cursor to last row/column with data. |
|
Select Page Up |
Shift+PgUp (Win/Linux) Shift+Pg Dn (macOS) |
Select from cursor to row one page up. |
|
Select Page Left |
Alt+Shift+PgUp (Win/Linux) |
Select from cursor to column one page left. |
|
Select Page Left |
Option+Shift+Pg Dn (macOS) |
Select from cursor to column one page left. |
|
Select Page Down |
Shift+PgDown |
Select from cursor to row one page down. |
|
Select Page Right |
Alt+Shift+PgDown (Win/Linux) Option+Shift+Pg Up (macOS) |
Select from cursor to column one page right. |
|
Select Precedents |
Ctrl+[ (Win/Linux) Cmd+[ (macOS) |
Select cells on which current cell is dependent. |
|
Select Dependents |
Ctrl+] (Win/Linux) Cmd+] (macOS) |
Select cells dependent on current cell. |
|
Select Prev Sheet |
Ctrl+Shift+PgUp (Win/Linux) Shift+Cmd+PgUp (macOS) |
Edit > Select > Select to Previous Sheet. |
|
Select Next Sheet |
Ctrl+Shift+PgDown (Win/Linux) Shift+Cmd+PgDn (macOS) |
Edit > Select > Select to Next Sheet. |
|
Select Data Area |
Ctrl + A (Win/Linux) Ctrl+ * (Win/Linux, numpad *) Cmd+ * (macOS) |
Edit > Select > Select Data Area (cursor must be inside area). |
|
Select Column |
Ctrl+Space |
Edit > Select > Select Column. |
|
Select Row |
Shift+Space |
Edit > Select > Select Row. |
|
Select All |
Ctrl+Shift+Space (Win/Linux) Cmd+A (macOS) |
Edit > Select All. |
|
Toggle Select Mode |
F8 / Shift+F8 (macOS) |
Toggle standard vs extending / adding selection modes. |
|
Select All Cells |
Ctrl+A (Win/Linux) |
Select all cells in current sheet. The focus must be out of any data area. |
Table 6: Keys for viewing data
|
Shortcut name |
Keys |
Description & notes |
|
Optimize Row |
Alt+Shift+↑ (Win/Linux) Option+Shift+↑ (macOS) |
Optimize row height based on current cell. |
|
Increase Column |
Alt+→ (Win/Linux) Option+→ (macOS) |
Increase width of current column. |
|
Optimize Column |
Alt+Shift+→ (Win/Linux) Option+Shift+→ (macOS) |
Optimize column width based on current cell. |
|
Optimize Row |
Alt+Shift+↓ (Win/Linux) Option+Shift+↓ (macOS) |
Optimize row height based on current cell. |
|
Decrease Column |
Alt+← (Win/Linux) Option+← (macOS) |
Decrease width of current column. |
|
Optimize Column |
Alt+Shift+← (Win/Linux) Option+Shift+← (macOS) |
Optimize column width based on current cell. |
|
Full Screen |
Ctrl+Shift+J (Win/Linux) Ctrl+Cmd+F (macOS) |
View > Full Screen. |
|
Redraw View |
Ctrl+Shift+R (Win/Linux) Shift+Cmd+R (macOS) |
Redraws the document view. |
|
Show Comment |
Ctrl+F1 (Win/Linux) Cmd+F1 (macOS) |
Display comment attached to current cell. |
|
Value Highlight |
Ctrl+F8 (Win/Linux) Cmd+F8 (macOS) |
View > Value Highlighting. |
|
Data Sources |
Ctrl+Shift+F4 (Win/Linux) Shift+Cmd+F4 (macOS) |
View > Data Sources. |
|
Trace Precedents |
Shift+F9 |
Tools > Detective > Trace Precedents. |
|
Trace Dependents |
Shift+F5 |
Tools > Detective > Trace Dependents. |
|
Show Formula |
Ctrl+` (Win/Linux) |
View > Show Formula. ( ` key is left of 1 on many keyboards.) |
Table 7: Keys for data editing
|
Shortcut name |
Keys |
Description & notes |
|
Edit Cell |
F2 |
Enter cell edit mode. |
|
Cancel Edit |
Escape |
Cancel current cell edit. |
|
Copy to Clipboard |
Ctrl+Insert (Win/Linux) |
Copy selection to clipboard (for later paste). |
|
Copy |
Ctrl+C (Win/Linux) Cmd+C (macOS) |
Edit > Copy; Standard toolbar icon. |
|
Paste Clipboard |
Shift+Insert (Win/Linux) |
Paste clipboard into selection. |
|
Paste Special |
Insert (Win/Linux) |
After selecting, open Paste Special dialog. |
|
Paste |
Ctrl+V (Win/Linux) Cmd+V (macOS) |
Edit > Paste; toolbar icon. |
|
Paste Special |
Ctrl+Shift+V (Win/Linux) Shift+Cmd+V (macOS) |
Edit > Paste Special > Paste Special. |
|
Paste Unformatted |
Ctrl+Alt+Shift+V (Win/Linux) Option+Shift+Cmd+V (macOS) |
Edit > Paste Special > Paste Unformatted Text. |
|
Delete Contents |
Delete (Win/Linux) Forward Delete (macOS) |
Delete cell contents without dialog (keeps formatting). |
|
Cut |
Ctrl+X (Win/Linux) Cmd+X (macOS) |
Edit > Cut; toolbar icon. |
|
Cut Keep Format |
Ctrl+Shift+X (Win/Linux) |
Cut contents; keep cell formatting. |
|
Remove & Copy |
Shift+Delete (Win/Linux) |
Remove and copy selection to clipboard. |
|
Deselect |
Shift+Backspace (Win/Linux) |
Deselect current selection without deleting. |
|
Undo Last Entry |
Alt+Backspace (Win/Linux) Option+Delete (macOS) |
Reverse last command or last entry typed. |
|
Copy Above |
Ctrl+' (Win/Linux) Cmd+' (macOS) |
Copy cell above into current cell; remain in edit mode (apostrophe key). |
|
Line Break |
Ctrl+Enter (Win/Linux) Cmd+Enter (macOS) |
Insert manual line break while editing a cell. |
|
Create Matrix |
Ctrl+Shift+Enter (Win/Linux) Shift+Cmd+Enter (macOS) |
Create matrix in current range using formula input. |
|
Edit Matrix |
F2, followed by Ctrl+Shift+Enter (Win/Linux) Shift+Cmd+Enter (macOS) |
Edit matrix formula in current range, using formula input. |
|
Fill Range |
Alt+Enter (Win/Linux) Option+Enter (macOS) |
Fill selected range with formula from input line. |
|
Sum Function |
Alt+= (Win/Linux) |
Equivalent to Select Function > Sum on Formula bar. |
|
Formula Object |
Alt+Shift+E (Win/Linux) Option+Cmd+= (macOS) |
Insert > OLE Object > Formula Object. |
|
Redo |
Ctrl+Y (Win/Linux) Cmd+Y (macOS) |
Edit > Redo; toolbar icon. |
|
Repeat |
Ctrl+Shift+Y (Win/Linux) Shift+Cmd+Y (macOS) |
Edit > Repeat. |
|
Undo |
Ctrl+Z (Win/Linux) Cmd+Z (macOS) |
Edit > Undo; toolbar icon. |
|
Cycle Case |
Shift+F3 |
Format > Text > Cycle Case. |
|
Ref Types |
F4 |
Sheet > Cycle Cell Reference Types. |
|
Clear Formatting |
Ctrl+M (Win/Linux) Cmd+M (macOS) |
Format > Clear Direct Formatting; toolbar icon. |
|
Edit Mode |
Ctrl+Shift+M (Win/Linux) Shift+Cmd+M (macOS) |
Edit > Edit Mode. |
|
Undo Reverse |
Ctrl+Shift+Z (Win/Linux) Shift+Cmd+Z (macOS) |
Reverse last Undo command. |
Table 8: Keys for inserting contents
|
Shortcut name |
Keys |
Description & notes |
|
Insert Comment |
Ctrl+Alt+C (Win/Linux) Option+Cmd+C (macOS) |
Insert > Comment / Sheet > Cell Comments > Edit Comment; toolbar icon. |
|
Fill Down |
Ctrl+D (Win/Linux) Cmd+D (macOS) |
Sheet > Fill Cells > Fill Down. |
|
Insert Function |
Ctrl+F2 (Win/Linux) Cmd+F2 (macOS) |
Insert > Function. |
|
Insert Cells |
Ctrl+ + (Win/Linux, numpad +) Cmd+ + (macOS, numpad +) |
Sheet > Insert Cells. |
|
Delete Cells |
Ctrl+ - (Win/Linux, numpad -) Cmd+ - (macOS, numpad -) |
Sheet > Delete Cells. |
|
Insert Date |
Ctrl+; (Win/Linux) Cmd+; (macOS) |
Insert > Date. |
|
Insert Time |
Ctrl+Shift+; (Win/Linux) |
Insert > Time. |
Table 9: Keys for charts and outlines
|
Shortcut name |
Keys |
Description & notes |
|
Chart Next Element |
Tab / ⇥ |
Select next chart element. |
|
Chart Prev Element |
Shift+Tab Shift+⇥ |
Select previous chart element. |
|
Chart First Element |
Home |
Select first chart element. |
|
Chart Last Element |
End |
Select last chart element. |
|
Chart Cancel |
Esc |
Cancel selection. |
|
Chart Move |
Arrow keys |
Move selected chart element; in pie charts, move segment in arrow direction. |
|
Chart Text Mode |
F2 (titles) |
Enter text input mode. |
|
Chart Open Group |
F3 (legends/data series) |
Open group to edit components. |
|
Chart Exit Group |
Ctrl+F3 Cmd+F3 |
Exit group (Win/Linux/macOS). |
|
Chart Zoom |
+ / - (numpad) |
Enlarge/shrink chart; in pie charts, move segment off/into pie. |
|
Outline Cycle Forward |
Tab / ⇥ |
Cycle outline indicators forward (focus outline window with F6/Shift+F6). |
|
Outline Cycle Back |
Shift+Tab Shift+⇥ |
Cycle outline indicators backward. |
|
Outline Show Levels |
Ctrl+1 – 8 Cmd+1 – 8 |
Show all levels up to number; hide higher levels. |
|
Outline Show/Hide Group |
+ / - (numpad) |
Show (+) or hide (-) focused outline group. |
|
Outline Activate |
Enter |
Activate focused indicator button. |
|
Outline Navigate |
Arrow keys |
Cycle indicators in arrow direction. |
Table 10 identifies the key combinations that are grayed out (not available for modification) in the Shortcut Keys list on the Tools > Customize > Keyboard dialog with Calc selected.
Table 10: Grayed key combinations in Tools > Customize > Keyboard
|
Operating system |
Key combinations grayed in Customize dialog |
|
macOS |
F1, Cmd+F1, Shift+F1 Shift+F2 Cmd+F4, Option+F4, Cmd+Option+F4 F6, Cmd+F6, Shift+F6, Shift+Cmd+F6 F10 Shift+Cmd+0, Shift+Cmd+1, Shift+Cmd+2, Shift+Cmd+3, Shift+Cmd+4, Shift+Cmd+5, Shift+Cmd+6, Shift+Cmd+7, Shift+Cmd+8, Shift+Cmd+9 |
Note
Certain keys may be reserved by the operating system and therefore unavailable for Calc (e.g., F1 for Windows Sleep/Hibernate; macOS Cmd+F5 for VoiceOver; macOS Shift+F11 for desktop). Refer to the OS documentation when a shortcut does not trigger Calc behavior.