LibreOffice Calc Keyboard Shortcuts

LibreOffice Calc is a free, open-source spreadsheet program for Linux, Windows, and MacOS. Like Microsoft Excel, LibreOffice Calc provides a simple yet powerful interface that you can use to record and manipulate data tables. LibreOffice Calc can also produce complex tables and analyze them through its extensive built-in wizards.

Essential LibreOffice Calc Keybindings

While creating new bindings for existing functions is possible, the default set of keybindings in LibreOffice Calc can already demonstrate its extensive features. For example, the spreadsheet editor has a bunch of keybindings for reference tracing, formula recalculation, setting custom colors, and formatting.

This cheatsheet provides an extensive list of default keybindings you can use with LibreOffice Calc. Furthermore, this list highlights some of the program’s lesser-known complex functions so you can become a spreadsheet wizard.

Windows/Linux	macOS	Function
File Manipulation
Ctrl + N	Command + N	Create a new Calc spreadsheet.
Ctrl + O	Command + O	Open an existing Calc spreadsheet.
Ctrl + S	Command + S	Save the current Calc spreadsheet.
Ctrl + Shift + S	Command + Shift + S	Save the current Calc spreadsheet in a different format.
Ctrl + F4	Command + F4	Close the current Calc spreadsheet.
F6	F6	Switch focus on the next internal window.
Shift + F6	Shift + F6	Switch focus on the previous internal window.
Ctrl + P	Command + P	Open the Print dialog menu.
Interface Manipulation
Ctrl + Shift + J	Command + Shift + J	Switch between fullscreen and windowed mode.
Ctrl + Shift + R	Command + Shift + R	Render the current spreadsheet again.
Ctrl + Shift + I	Command + Shift + I	Toggle the cursor in Read Only spreadsheets.
F5	F5	Toggle the spreadsheet navigator subwindow.
F10	F10	Open the first item in the Menu Bar.
Shift + F10	Shift + F10	Open the Context Menu.
Ctrl + Shift + F10	Command + Shift + F10	Toggle the dock status of the current subwindows.
F11	F11	Open the “Styles” dialog box.
Ctrl + Q	Command + Q	Exit the Calc program.
Help Menu
F1	F1	Open the Built-in Libreoffice Help System.
Shift + F1	Shift + F1	Open the Help System entry for the current mode.
Shift + F2	Shift + F2	Reopen the Tips menu.
Spreadsheet Navigation
Left Arrow	Left Arrow	Move the selection cursor to the cell on the left.
Right Arrow	Right Arrow	Move the selection cursor to the cell on the right.
Up Arrow	Up Arrow	Move the selection cursor one cell up.
Down Arrow	Down Arrow	Move the selection cursor one cell down.
Ctrl + Left Arrow	Command + Left Arrow	Move the selection cursor to the first cell on the left with data.
Ctrl + Right Arrow	Command + Right Arrow	Move the selection cursor to the first cell on the right with data.
Ctrl + Up Arrow	Command + Up Arrow	Move the selection cursor to the first cell with data upwards.
Ctrl + Down Arrow	Command + Down Arrow	Move the selection cursor to the first cell with data downwards.
Ctrl + Page Up		Move to the previous spreadsheet in the file.
Ctrl + Page Down		Move to the next spreadsheet in the file.
Alt + Page Up		Move the spreadsheet viewer to the left by one screen.
Alt + Page Down		Move the spreadsheet viewer to the right by one screen.
Ctrl + F	Command + F	Search for a string in the current spreadsheet.
Ctrl + Shift + F	Command + Shift + F	Search for the last string that you searched for in the current spreadsheet.
Ctrl + H	Command + H	Open the “Find and Replace” dialog box.
Spreadsheet Selection
Shift + Space	Shift + Space	Select the entire current row.
Ctrl + Space	Command + Space	Select the entire current column.
Ctrl + Shift + Space	Command + Shift + Space	Select the entire spreadsheet.
Shift + Home		Select the current cell up until the first cell in the current row.
Shift + End		Select the current cell up until the last cell with data in the current row.
Shift + Page Up		Select the current cell and one screen up in the current column.
Shift + Page Down		Select the current cell and one screen down in the current column.
Ctrl + Shift + Page Up		Select the previous spreadsheet in the file along with the current one.
Ctrl + Shift + Page Down		Select the next spreadsheet in the file along with the current one.
Spreadsheet Editing
Ctrl + C	Command + C	Copy the contents of the currently selected cell.
Ctrl + X	Command + X	Copy the contents of the currently selected cell and delete it.
Enter	Enter	Paste the contents of the clipboard at the currently selected cell.
Backspace	Backspace	Open the “Delete Contents” dialog box.
Delete	Delete	Delete the contents of the currently selected cell.
Ctrl + Plus (+)	Command + Plus (+)	Insert a new cell at the current cursor position.
Ctrl + Minus (-)	Command + Minus (-)	Delete the currently selected cell.
Ctrl + Back Quote (`)	Command + Back Quote (`)	Toggle the formula display for each cell in the current spreadsheet.
Ctrl + Z	Command + Z	Undo the last change that you made.
Ctrl + Y	Command + Y	Redo the last change that you made.
Ctrl + Alt + Y	Command + Option + Y	Redo the last calc command that you made.
Ctrl + Semicolon (;)	Command + Semicolon (;)	Insert the current date in currently selected cell.
Ctrl + Shift + Semicolon (;)	Command + Shift + Semicolon (;)	Insert the current time in the currently selected cell.
Spreadsheet Formatting
Ctrl + 1	Command + 1	Open the “Format Cells” dialog box.
Ctrl + Shift + 1	Command + Shift + 1	Format the current cell up to two decimal places.
Ctrl + Shift + 2	Command + Shift + 2	Format the current cell in scientific notation.
Ctrl + Shift + 3	Command + Shift + 3	Format the current cell to the standard date format.
Ctrl + Shift + 4	Command + Shift + 4	Format the current cell to the standard currency format.
Ctrl + Shift + 5	Command + Shift + 5	Format the current cell in percentage format with up to two decimal places.
Ctrl + Shift + 6	Command + Shift + 6	Format the current cell using the default style.
Cell Formatting
Ctrl + B	Command + B	Format the current cell in bold.
Ctrl + I	Command + I	Format the current cell in italics.
Ctrl + U	Command + U	Underline the text in the current cell.
Ctrl + M	Command + M	Remove any formatting in the current cell.
Ctrl + L	Command + L	Force the contents of the current cell to be left justified.
Ctrl + R	Command + R	Force the contents of the current cell to be right justified.
Ctrl + E	Command + E	Center the contents of the current cell.
Ctrl + J	Command + J	Justify the contents of the current cell.
Shift + F3	Shift + F3	Toggle the different letter cases for the current cell.
Pivot Table
Tab	Tab	Go through the different fields in the Pivot Table dialog box.
Shift + Tab	Shift + Tab	Go through the different fields in the dialog box in reverse.
Up Arrow	Up Arrow	Move the selection cursor one line up in the current field.
Down Arrow	Down Arrow	Move the selection cursor one line down in the current field.
Left Arrow	Left Arrow	Move the selected data point to an adjacent field on the left.
Right Arrow	Right Arrow	Move the selected data point to an adjacent field on the right.
Home		Move the selection cursor to the top of the current field.
End		Move the selection cursor to the bottom of the current field.
Delete	Delete	Delete the selected data point in the current field.

_{Image Credit: Unsplash and Wikimedia Commons. All alterations by Ramces Red.}