LibreOffice Calc

Function keys

Decreases the width of the current column

Alt +

All hotkeys for LibreOffice Calc

General
Fill a selected cell range with the formula that you entered on the Input line

Alt + ⤶ Enter

General
Apply the cell format of the input cell to the entire cell range

Alt + ↑   Shift + ⤶ Enter

General
Create a matrix in which all the cells contain the same information. Components of the matrix cannot be edited

↑   Shift + Ctrl + ⤶ Enter

General
To select multiple sheets in a spreadsheet, hold down Ctrl, and then click the name tabs at the lower edge of the workspace.

Ctrl

General
To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet

↑   Shift

General
To insert a manual line break in a cell, click in the cell, and then press Ctrl + Enter

Ctrl + ⤶ Enter

General
Delete the contents of selected cells

⬅ Backspace

Using the pivot table
Removes the current field from the area

Del

Using the pivot table
Moves the current field to the first place

Ctrl + Home

Using the pivot table
Moves the current field to the last place

Ctrl + End

Using the pivot table
Selects the first item in the current dialog area

Home

Using the pivot table
Selects the last item in the current dialog area

End

Navigating
Selects cells from the current cell to the first cell of the current row

↑   Shift + Home

Navigating
Selects cells from the current cell to the last cell of the current row

↑   Shift + End

Navigating
Selects cells from the current cell up to one page in the current column or extends the existing selection one page up

Shift + Page Up

Navigating
Selects cells from the current cell down to one page in the current column or extends the existing selection one page down

Shift + Page Down

Using the pivot table
Moves the current field one place to the left

Ctrl +

Using the pivot table
Moves the current field one place to the right

Ctrl +

Using the pivot table
Moves the current field up one place

Ctrl +

Using the pivot table
Moves the current field down one place

Ctrl +

Navigating
Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected

Ctrl + ↑   Shift + ← ↑ → ↓

Navigating
In the print preview: Moves to the previous print page

Ctrl + Page Up

Navigating
In the print preview: Moves to the next print page

Ctrl + Page Down

Navigating
Moves one screen to the left

Alt + Page Up

Navigating
Moves one screen page to the right

Alt + Page Down

Navigating
Adds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the previous sheet. Makes the previous sheet the current sheet

Shift + Ctrl + Page Up

Navigating
Adds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the next sheet. Makes the next sheet the current sheet

Shift + Ctrl + Page Down

Navigating
Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns

Ctrl + *

Navigating
Selects the matrix formula range that contains the cursor

Ctrl + /

Navigating
Insert cells (as in menu Insert - Cells)

Ctrl + +

Navigating
Delete cells (as in menu Edit - Delete Cells)

Ctrl + -

Navigating
(in a selected range) Moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose Tools - Options' - LibreOffice Calc - General'

⤶ Enter

Navigating
Displays or hides the formulas instead of the values in all cells (see note below this table)

Ctrl + `

Function keys
Displays the comment that is attached to the current cell

Ctrl + F1

Function keys
If the cursor is in an input box in a dialog that has a Minimize button, the dialog is hidden and the input box remains visible. Press F2 again to show the whole dialog

F2

Function keys
Opens the Function Wizard

Ctrl + F2

Function keys
Moves the cursor to the Input line where you can enter a formula for the current cell

↑   Shift + Ctrl + F2

Function keys
Opens the Define Names dialog

Ctrl + F3

Function keys
Shows or Hides the Database explorer

↑   Shift + Ctrl + F4

Function keys
Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field

F4

Function keys
Shows or hides the Navigator

F5

Function keys
Traces dependents

↑   Shift + F5

Function keys
Traces precedents

↑   Shift + F7

Function keys
Moves the cursor from the Input line to the Sheet area box

↑   Shift + Ctrl + F5

Function keys
Checks spelling in the current sheet

F7

Function keys
Opens the Thesaurus if the current cell contains text

Ctrl + F7

Function keys
Turns additional selection mode on or off. In this mode, you can use the arrow keys to extend the selection. You can also click in another cell to extend the selection

F8

Function keys
Highlights cells containing values

Ctrl + F8

Function keys
Recalculates changed formulas in the current sheet

F9

Function keys
Recalculates all formulas in all sheets

Ctrl + ↑   Shift + F9

Function keys
Updates the selected chart

Ctrl + F9

Function keys
Opens the Styles and Formatting window where you can apply a formatting style to the contents of the cell or to the current sheet

F11

Function keys
Creates a document template

↑   Shift + F11

Function keys
Updates the templates

↑   Shift + Ctrl + F11

Function keys
Groups the selected data range

F12

Function keys
Ungroups the selected data range

Ctrl + F12

Function keys
Increases the height of current row (only in OpenOffice.org legacy compatibility mode)

Alt +

Function keys
Decreases the height of current row (only in OpenOffice.org legacy compatibility mode)

Alt +

Function keys
Increases the width of the current column

Alt +

Function keys
Decreases the width of the current column

Alt +

Function keys
Optimizes the column width or row height based on the current cell

Alt + ↑   Shift + ← ↑ → ↓

Formatting cells
Open Format Cells dialog

Ctrl + 1

Formatting cells
Two decimal places, thousands separator

Ctrl + ↑   Shift + 1

Formatting cells
Standard exponential format

Ctrl + ↑   Shift + 2

Formatting cells
Standard date format

Ctrl + ↑   Shift + 3

Formatting cells
Standard currency format

Ctrl + ↑   Shift + 4

Formatting cells
Standard percentage format (two decimal places)

Ctrl + ↑   Shift + 5

Formatting cells
Standard format

Ctrl + ↑   Shift + 6

Using the pivot table
Changes the focus by moving forwards through the areas and buttons of the dialog

⭾ Tab

Using the pivot table
Changes the focus by moving backwards through the areas and buttons of the dialog

↑   Shift + ⭾ Tab

Using the pivot table
Moves the focus up one item in the current dialog area

Using the pivot table
Moves the focus down one item in the current dialog area

Using the pivot table
Moves the focus one item to the left in the current dialog area

Using the pivot table
Moves the focus one item to the right in the current dialog area

Using the pivot table
and the underlined character in the word "Data" Copies or moves the current field into the "Data" area

Alt

Using the pivot table
Displays the options for the current field

Alt + O

Similar combinations for other applications


Visual Assist
Navigate back
Text editor

Alt +


mpv
Add video pan-x 0.1
Move video rectangle

Alt +


Xyplorer
Back
Go Menu

Alt +


Vivaldi
History back
Page

Alt +


Affinity Photo
Tighten
Text shortcuts

Alt +


PRTG Network Monitor
Previous viewpoint
Enterprise console

Alt +


GeoGebra
x100 multiplier
Mac desktop

Alt +


Google Chrome
Open the previous page from your browsing history in the current tab
Tab and window shortcuts

Alt +


Nuclide (Linux)
Collapse all the directories to the top parent.
Project Explorer’s file tree

Alt +


Shotcut (Mac)
Seek Previous Edit
Player

Alt +


Nier: Automata
Switch pod
Genel

Alt +


Shotcut
Seek Previous Edit
Player

Alt +


Freshdesk
Go to the previous page
Tickets tab

Alt +


Feedreader
Go back in web browser
General

Alt +


Ace Editor
Go to line start
Go to

Alt +


Quicken 2018
Previous window
Moving around in windows and fields

Alt +


PyCharm 2018.2
When several tabs are open in the editor or a view, open the next tab to the left (or last tab if the current one is the first).
General

Alt +


Bluebeam Revu
Previous view
Navigation

Alt +


Atom (Windows)
(Source: Tree View) tree-view:recursive-collapse-directory
All shortcuts

Alt +


Aegisub
Fast jump backwards
Video

Alt +


Discord
Return to connected audio channel
General

Alt +


CorelDRAW Graphics Suite 2018
Pan Left
General

Alt +


Microsoft Word 2016
Go back one page
Work with web content

Alt +


PDF-XChange Editor
Promote bookmark
General

Alt +


Xodo
Jump back
Navigating

Alt +


gedit
Move the selected word left one word
Editing files

Alt +


ImageJ
Previous hyperstack frame
General

Alt +


Microsoft FrontPage
Move back to the previous Help topic.
In the Help window

Alt +


Arch Linux
Switch to previous virtual console
Terminal: Virtual console

Alt +


KDE Plasma Desktop
Back
Working with files

Alt +


CodeMirror
Move cursor to the start of the line
General (Windows)

Alt +


Chromebook and Chrome OS
Go to previous page in your browsing history
Tabs and windows

Alt +


WavePad
Fine Back
Move and Select Operations

Alt +


Comodo IceDragon
arrow  Back
Navigate Through Webpages

Alt +


AWS Cloud9 IDE (Windows)
Goto Line Start
Goto

Alt +


Adobe Premiere Pro (Windows)
Trim Backward by One Frame
Trim Monitor panel

Alt +


NetBeans
Go backward
Navigating through source code

Alt +


Kdenlive
Go to Previous Snap Point
Editing

Alt +


Mp3tag
Backward in directory history
General

Alt +


Zim
Go one page back in history
General

Alt +


PSPad
Set/Delete Bookmark
Bookmark

Alt +


Office Delve
Go back one page
General

Alt +


Brackets
Go to beginning of line
General

Alt +


Microsoft Visual Studio 2017 (All shortcuts)
Arrow  GraphView.RighttoLeft
XML Schema Designer

Alt +


Android
Move cursor to beginning of line
Typing

Alt +


Qt Creator
Go back
General

Alt +


Guitar Pro
Previous section
Bar - Section

Alt +


Multi Commander
Go Back
Core shortcuts

Alt +


Delphi
Browse backward (hotlink history)
General

Alt +


Maxthon
Back
Go to

Alt +


Sumatra PDF
Go back
Navigation

Alt +


KompoZer
Go Back to Previous Page
Help window

Alt +


REAPER
View: Scroll view left
Section: MIDI Editor

Alt +


The Bat!
Move to previous viewed
Working with Messages

Alt +


Accounting CS
Moves back through previous views
Navigating and special functions

Alt +


WinMerge
Copy difference from right side to left side
Difference navigation and merging (normal mode)

Alt +


MediaMonkey
Previous node back
General

Alt +


VLC Media Player
Jump 10 seconds backward
Playback controls

Alt +


SQL Server Management Studio (SSMS)
Back, display the previous page in the viewing history
Document window and browser

Alt +


Slack
Previous channel or DM visited
Navigation

Alt +


Firefox Quantum
Back
Navigation

Alt +


Outlook 2016 and Outlook 2013
Go back to previous view in the main Outlook window
Basic navigation

Alt +


Microsoft Internet Explorer 11
Go to the previous page
Browsing

Alt +


WinSCP
Go back
Navigation

Alt +


PeaZip
Go back in history
Navigation

Alt +


Opera
Go to previous page in history
Navigation: History

Alt +


Zimbra Web Client
Go to previous tab
Tabs view

Alt +


Adobe Acrobat Reader DC
Jump to previously visited page
Navigation

Alt +


Everything
Go back to the previous search
General keyboard shortcuts

Alt +


Microsoft Movies and TV
Go back
General

Alt +


Audacity
Move Cursor to Previous Label
Transport menu

Alt +


Windows Media Player 11
Switch to previous view
Navigate the library

Alt +


File Explorer
View the previous folder
Miscellaneous

Alt +


Microsoft Access 2016
Move back to the previous Help topic (Back button)
Get help with Access

Alt +


Steam
Go back to previous page (?)
Store tab

Alt +


Microsoft OneNote
Go back to the last visited page
Work with pages and Quick Notes

Alt +


Total Commander
Jump to previous directory
Navigation

Alt +


Spotify
Go back
General

Alt +


Microsoft Edge
Go back
General

Alt +


HeidiSQL
Previous result tab
Data

Alt +


Adobe Acrobat 2017 (Windows and Unix)
Move back to previously opened topic
Help window

Alt +


DBeaver 6.0.3
Navigate backward in history
Data viewer

Alt +