LibreOffice Calc

Function keys

Increases 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 forward
Text editor

Alt +


mpv
Add video pan-x -0.1
Move video rectangle

Alt +


Xyplorer
Forward
Go Menu

Alt +


Vivaldi
History forward
Page

Alt +


Affinity Photo
Loosen
Text shortcuts

Alt +


PRTG Network Monitor
Next viewpoint
Enterprise console

Alt +


GeoGebra
x100 multiplier
Mac desktop

Alt +


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

Alt +


Nuclide (Linux)
Expand all the directories from the current to the final directory child.
Project Explorer’s file tree

Alt +


Shotcut (Mac)
Seek Next Edit
Player

Alt +


Nier: Automata
Switch pod
Genel

Alt +


Shotcut
Seek Next Edit
Player

Alt +


Freshdesk
Go to the next page
Tickets tab

Alt +


Feedreader
Go forward in web browser
General

Alt +


Ace Editor
Go to line end
Go to

Alt +


Quicken 2018
Next 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 right (or first tab if the current one is the last).
General

Alt +


Bluebeam Revu
Next view
Navigation

Alt +


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

Alt +


Aegisub
Fast jump forward
Video

Alt +


Discord
Return to previous audio channel
General

Alt +


CorelDRAW Graphics Suite 2018
Pan Right
General

Alt +


Microsoft Word 2016
Go forward one page
Work with web content

Alt +


Xodo
Jump forward
Navigating

Alt +


PDF-XChange Editor
Navigate forward.
General

Alt +


gedit
Move the selected word right one word
Editing files

Alt +


ImageJ
Next hyperstack frame
General

Alt +


Microsoft FrontPage
Move forward to the next Help topic.
In the Help window

Alt +


Arch Linux
Switch to next virtual console
Terminal: Virtual console

Alt +


KDE Plasma Desktop
Forward
Working with files

Alt +


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

Alt +


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

Alt +


Microsoft Visual Studio 2017 (Most used shortcuts)
[Text Editor, Workflow Designer] Edit.CompleteWord
Edit

Alt +


WavePad
Fine Forward
Move and Select Operations

Alt +


Comodo IceDragon
arrow   Forward
Navigate Through Webpages

Alt +


AWS Cloud9 IDE (Windows)
Goto Line End
Goto

Alt +


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

Alt +


NetBeans
Go forward
Navigating through source code

Alt +


Kdenlive
Go to Next Snap Point
Editing

Alt +


PSPad
Delete Bookmark
Bookmark

Alt +


Mp3tag
Forward in directory history
General

Alt +


Zim
Go one page forward in history
General

Alt +


Office Delve
Go forward one page
General

Alt +


Brackets
Go to end of line
General

Alt +


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

Alt +


Qt Creator
Go forward
General

Alt +


Guitar Pro
Next section
Bar - Section

Alt +


Multi Commander
Go Forward
Core shortcuts

Alt +


Delphi
Browse forward (hotlink history)
General

Alt +


Maxthon
Forward
Go to

Alt +


Sumatra PDF
Go forward
Navigation

Alt +


KompoZer
Go Forward One Page
Help window

Alt +


REAPER
View: Scroll view right
Section: MIDI Editor

Alt +


The Bat!
Move to next viewed
Working with Messages

Alt +


Accounting CS
Moves forward through previous views
Navigating and special functions

Alt +


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

Alt +


MediaMonkey
Previous node forward
General

Alt +


VLC Media Player
Jump 10 seconds forward
Playback controls

Alt +


ACDSee
Zooms the image to fight the width within View mode window. Does not enlarge, only reduces
General

Alt +


ACDSee Free
Zooms the image to fit the width within the ACDSee Free window. Does not enlarge, only reduces
General

Alt +


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

Alt +


Slack
Next channel or DM visited
Navigation

Alt +


Firefox Quantum
Forward
Navigation

Alt +


Outlook 2016 and Outlook 2013
Go forward to next view in the main Outlook window
Basic navigation

Alt +


Microsoft Internet Explorer 11
Go to the next page
Browsing

Alt +


WinSCP
Go forward
Navigation

Alt +


PeaZip
Forward in history
Navigation

Alt +


Zimbra Web Client
Go to next tab
Tabs view

Alt +


Opera
Go to next page in history
Navigation: History

Alt +


Adobe Acrobat Reader DC
Jump to next page
Navigation

Alt +


Everything
Go forward to the next search
General keyboard shortcuts

Alt +


Audacity
Move Cursor to Next Label
Transport menu

Alt +


Windows Media Player 11
Switch to next view
Navigate the library

Alt +


File Explorer
View the next folder
Miscellaneous

Alt +


Microsoft Access 2016
Move forward to the next Help topic (Forward button)
Get help with Access

Alt +


Microsoft OneNote
Go forward to the next visited page
Work with pages and Quick Notes

Alt +


Total Commander
Jump to next directory
Navigation

Alt +


Spotify
Go forward
General

Alt +


Microsoft Edge
Go forward
General

Alt +


HeidiSQL
Next result tab
Data

Alt +


Adobe Acrobat 2017 (Windows and Unix)
Move forward to next topic
Help window

Alt +


DBeaver 6.0.3
Navigate forward in history
Data viewer

Alt +