LibreOffice Calc

Using the pivot table

Moves the current field to the last place

Ctrl + End

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


Microsoft Projects 2010 (Windows)
Jump to first cell / jump to last cell
Navigate Gantt Chart and Select Tasks

Ctrl + Home / Ctrl + End


Adobe Reader X (Windows)
Jump to beginning/ jump to end of document
Navigation

Ctrl + Home / Ctrl + End


Microsoft OneNote 2010 (Windows)
Scroll to the top/ bottom of the current page.
Basic Editing and Formatting

ctrl + home / ctrl + end


Microsoft Word 2007 (Windows)
Move to the last preview page when zoomed out.
Working with documents: Print and preview documents

Ctrl + End


Inpage (Windows)
To go to the end of the text
To move cursor

Ctrl + End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the line in multi-line fields
Manage Access Features - Edit Text and Data

Ctrl + Home / Ctrl + End


Access 2010 (Windows)
Move to first field in first record / last field in last record
Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Home / Ctrl + End


Google Docs (Windows)
Jump to end / to beginning of document
Navigate Google Docs

Ctrl + End / Ctrl + Home


Microsoft Word 2007 (Windows)
To the end of a document
Edit and move text and graphics: Move through your document

Ctrl + End


Microsoft Excel 2011 (MacOS)
Move to the beginning / to the end of the sheet
Moving and scrolling in a sheet or workbook

Ctrl + Home ./ Ctrl + End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the line in multi-line fields
Working with Text and Data - Edit Text and Data

Ctrl + Home / Ctrl + End


Access 2010 (Windows)
Move to first field in first record / last field in last record
Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Home / Ctrl + End


Microsoft PowerPoint 2010 (Windows)
Move to the end of a text box.
Basic Text Navigation and Formatting

Ctrl + End


Adobe Reader X (Linux)
Jump to beginning/ jump to end of document
Navigation

Ctrl + Home / Ctrl + End


Microsoft Excel 2013 (Windows)
Move to the last cell with content on a worksheet
Navigate Worksheets

Ctrl + End


Microsoft Word 2013 (Windows)
Jump to end / to beginning of document
Navigate in Word Documents

Ctrl + End / Home


Access 2010 (Windows)
Move cursor to the beginning / to the end of the line in multi-line fields
Working with Access Views - Edit Text and Data

Ctrl + Home / Ctrl + End


Access 2010 (Windows)
Move to first field in first record / last field in last record
Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Home / Ctrl + End


Presonus Studio One (Windows)
End skip
Navigation

Ctrl + End


FileMaker Pro (Windows)
Move to beginning / to end of the text
Layout Mode Shortcuts - Text Navigation

Ctrl + Home / Ctrl + End


Windows 10 Command Prompt (Windows)
Delete from cursor position to end of line
Enter and Manipulate Text

Ctrl + End


Microsoft Word 2013 (Windows)
Move to first page / last page (with focus on preview page)
Print Documents

Ctrl + Home / Ctrl + End


Camtasia 8 (Windows)
Jump to end/ beginning of timeline
Editor Timeline Navigation

Ctrl + End / Ctrl + Home


Microsoft Excel 2010 (Windows)
Move to the last cell with content on a worksheet.
Navigate Inside Worksheets

Ctrl + End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the line in multi-line fields
The Rest - Edit Text and Data

Ctrl + Home / Ctrl + End


FileMaker Pro (Windows)
Move to beginning / to end of the text
Text Shortcuts - Text Navigation

Ctrl + Home / Ctrl + End


Access 2010 (Windows)
Move to first field in first record / last field in last record
The Rest - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Home / Ctrl + End


Microsoft Edge Browser (Windows)
Scroll to bottom of page
Navigation

Ctrl + End


Microsoft PowerPoint 2016 (Windows)
End of text block
Navigation Operation

Ctrl + End


FileMaker Pro (Windows)
Move to beginning / to end of the text
Database Management Shortcuts - Text Navigation

Ctrl + Home / Ctrl + End


Microsoft Outlook 2016 (Windows)
Display (without selecting) the first/last item on the timeline (if items are not grouped) or the first item in the group
View: Timeline (Tasks) - When an item is selected

Ctrl + Home / Ctrl + End


Finale (Windows)
Last Page
Navigation Shortcuts

Ctrl + End


Finale (Windows)
Add selected expression to all staves to bottom of system
Expression Tool

Ctrl + End


Zoho Writer (Windows)
Move to the end of document
General

Ctrl + End


Zoho Sheet (Windows)
Go to last cell in data region
Navigate

Ctrl + End


Zoho Writer (Windows)
Move to the end of document
Navigation keys

Ctrl + End


Dynamics AX 2015 (Windows)
Move to the last record.
Working with Forms

Ctrl + End


Dynamics SL 2015 (Windows)
Last
General Shortcuts

Ctrl + End


Microsoft Word 2016 (Windows)
End of text block
Navigation Operation

Ctrl + End


Dynamics NAV 2015 (Windows)
Move to the last line in a list
Moving Shortcuts

Ctrl + End


Dynamics NAV 2015 (Windows)
Move to the last line in a list
Edit

Ctrl + End


Dynamics AX 2015 (Windows)
Move to the last record.
Grid Controls

Ctrl + End


Ace Projects (Windows)
Go to end
Navigation Shortcuts

Ctrl + End


Microsoft Projects 2016 (Windows)
Move to the end of a text box.
Moving around cells/text

Ctrl + End


AutoCad Architecture 2017 (Windows)
Moves the cursor to the end of the last line of text
Text Editing

Ctrl + End


Microsoft Projects 2016 (Windows)
Move to the end of the object’s text
Working with OfficeArt Objects

Ctrl + End


Microsoft Excel 2016 (Windows)
Move to the last cell with content of worksheet
Navigate Worksheets

Ctrl + End


Microsoft Projects 2016 (Windows)
Move to the last field of the last row.
Sheet View

Ctrl + End


Adobe Dreamweaver (Windows)
Move to end of file
Coding Shortcuts

Ctrl + End


Microsoft Excel 2016 (MacOS)
Move to the last cell in use on the sheet
Move and scroll in a sheet or workbook

Ctrl + End


HTML-Kit (Windows)
Go To End of Document
87 Shortcuts for HTML-Kit (Windows)

Ctrl + End


Microsoft Word 2016 (MacOS)
Move to the last cell in the row
Move around in a table

Ctrl + End


Final Fantasy XV (Windows)
Save current camera position
Camera

Ctrl + End


Kingsoft Writer 2016 (Windows)
Go to End of Document
Navigation Shortcuts

Ctrl + End


Kingsoft Spreadsheets 2016 (Windows)
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column
Other Shortcuts

Ctrl + End


Informix Genero 2.5.0 (Windows)
Bottom of file
Cursor Movement Shortcuts

Ctrl + End


Brackets (Windows)
Go to Document End
99 Shortcuts for Brackets (Windows)

Ctrl + End


MPS 2017 (Windows)
Move the caret to the end of text
Basic Editing

Ctrl + End


Aptana Studio 3 (Windows)
Jump to End of File
Navigation

Ctrl + End


Soundforge (Windows)
Go to the last sample in the data window
Cursor Movements

Ctrl + End


Editpad 7 (Windows)
Move to the end of the document
Select and Edit Text

Ctrl + End


Vegas Pro 14 (Windows)
Go to end of project
Cursor Placement,Loop Region and Time Selection

Ctrl + End


Jupyter Notebook (Windows)
go to cell end
Edit Mode (press Enter to enable)

Ctrl + End


Editpad 7 (Windows)
Delete the end of the current word
Select and Edit Text

Ctrl + End


Libreoffice Writer (Windows)
Go to end of document
General

Ctrl + End


Visual Studio Code (Windows)
Go to End of file
Editing Shortcuts

Ctrl + End


Quickbooks Desktop (Windows)
First transaction/ last transaction
Account Register Shortcuts

Ctrl + Home / Ctrl + End


Sierra Chart (Windows)
Scroll All Charts to End
Chart Menu

Ctrl + End


Libreoffice Writer (Windows)
If the active cell is empty: goes to the end of the table. Otherwise: first press goes to the end of the active cell, second press goes to the end of the current table, third press goes to the end of the document.
Tables

Ctrl + End


Bitcomet (Windows)
Move task down-most (non-sorting)
Task lists

Ctrl + End


Vegas Pro 14 (Windows)
Go to end of project
Playback,Recording and Preview

Ctrl + End


Delphi 10 (Windows)
Moves to the end of a file
193 Shortcuts for Delphi 10 (Windows)

Ctrl + End


CodeLite 10 (Windows)
Go to end of document.
Editor

Ctrl + End


TurboCAD (Windows)
Pan the window to the selected point
171 Shortcuts for TurboCAD (Windows)

Ctrl + End


Most used text editing
Move cursor to bottom of the text entry field
Moving the cursor

Ctrl + End


Source Insight (Windows)
Bottom of File
General

Ctrl + End


Comodo IceDragon (Windows)
Move Foreground Tab to last position
Windows and Tabs

Ctrl + End


Wordfast Pro (Windows)
Go To Last Segment
100 Shortcuts for Wordfast Pro (Windows)

Ctrl + End


FEKO (Windows)
Move to end of file
General EDITFEKO Shortcuts

Ctrl + End


FEKO (Linux)
Move to end of file
General EDITFEKO Shortcuts

Ctrl + End


RStudio
Jump to Start/End
Editing (Console and Source)

Ctrl + End


Banner 9 (Windows, Mac)
Last Page
Mac shortcuts

Ctrl + End


LDCad
Switch to the main session/model in the current LDraw file
Editor

Ctrl + End


Altium Designer (Windows)
Jump to defined relative origin for the workspace
PCB Editor Only Shortcuts

Ctrl + End


EasyWorship
Move the cursor to the end of the text when in words view
Editor

Ctrl + End


Altium Designer (Windows)
Jump to bottom of chart
SimData Editor Shortcuts

Ctrl + Down Arrow / Ctrl + End


Altium Designer (Windows)
Move cursor to End of File
Common Shortcuts

Ctrl + End


Lacerte
Move to the last item of the current screen
Batch input

Ctrl + End


Jupyter Notebook
Go to cell end
Edit mode

Ctrl + End


draw.io
Expand container
Canvas

Ctrl + End


WorkZone Client
Select the last list item on the last page
Navigate in lists

Ctrl + End


Ace Editor
Go to end
Go to

Ctrl + End


PyCharm 2018.2
Move the caret to the end of text.
Basic editing

Ctrl + End


Quicken 2018
Last transaction or lower right corner of report
Moving around in windows and fields

Ctrl + End


ActivePresenter 7
Arrange: Order back
Text

Ctrl + End


JAWS
Jump to the last cell in a table
Table layer

Ctrl + End


jEdit
End of buffer.
Moving the caret

Ctrl + End


Unreal Engine
Snap origin to grid
Level editor

Ctrl + End


OBS Studio
Move source bottom of souces list
Order

Ctrl + End


CorelDRAW Graphics Suite 2018
To Back Of Page
General

Ctrl + End


Atom (Windows)
(Source: Find And Replace) core:move-to-bottom
All shortcuts

Ctrl + End


Microsoft Word 2016
To the end of a document
Move around in a document

Ctrl + End


Camtasia
Jump to end of timeline
Editor's timeline

Ctrl + End


gedit
Move to the end of the document
Editing files

Ctrl + End


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

Ctrl + End


Microsoft FrontPage
Move to the top or bottom of the selected gallery list.
Access and use task panes

Ctrl + End


AWS Cloud9 IDE (Windows)
Goto End
Goto

Ctrl + End


GoldWave
Moves the Sound window view to the end of the sound.
Sound window

Ctrl + End


Comodo IceDragon
Move Foreground Tab to last position
Windows and Tabs

Ctrl + End


Kdenlive
Go to Project End
Editing

Ctrl + End


Inkscape
go to beginning/end of text
Text tool

Ctrl + End


Kodi
Exit Kodi (Only on Home Screen)
Global

Ctrl + End


Brackets
Go to end of document
General

Ctrl + End


WinHex
Go to end of file
Navigation

Ctrl + End


LibreOffice Impress
Go to end of text block in slide
Editing text

Ctrl + End


Microsoft PowerPoint (Creating presentations)
Move to the end of a text box
Move around in text

Ctrl + End


WriteMonkey
(Windows) Jump to start / end document
Navigation

Ctrl + End


Maple
Cursor to Bottom of Worksheet
General

Ctrl + End


LibreOffice Writer
If the active cell is empty: goes to the end of the table. Otherwise: first press goes to the end of the active cell, second press goes to the end of the current table, third press goes to the end of the document
Tables

Ctrl + End


Valentina Studio
Move to End of Document
Text - Navigation

Ctrl + End


LibreOffice
Selects the last Drawing Object
Drawing objects

Ctrl + End


Google Sheets
Move to end of sheet
Navigate spreadsheet

Ctrl + End


Google Translator Toolkit
Select last unit
Navigation

Ctrl + End


FileMaker
End of the text
Text navigation

Ctrl + End


Guitar Pro
Last bar
Sound

Ctrl + End


Vuze
Move selected torrent(s) to top or bottom of list
General

Ctrl + End


Visual Studio Code (Linux)
Scroll to bottom
Integrated terminal

Ctrl + End


Eclipse
Jump to end of source
Navigation in editor window

Ctrl + End


Visual Studio Code (Windows)
Scroll to bottom
Integrated terminal

Ctrl + End


IrfanView
Load last image in current directory
Browsing between images

Ctrl + End


Delphi
Moves to the end of a file
General

Ctrl + End


Microsoft Access 2016
Move to the end of a text box
Navigate in tables and cells: Move around in tables or cells

Ctrl + End


Microsoft Excel 2016
moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, this shortcut moves the cursor to the end of the text
Other useful shortcut keys

Ctrl + End


Microsoft Visual Studio 2017 (All shortcuts)
Edit.DocumentEnd
Text Editor

Ctrl + End


SQL Server Management Studio (SSMS)
Move the cursor to the end of the document
Cursor movement

Ctrl + End


Paint.NET
Scroll bottom right image to center screen
UI and Canvas Controls

Ctrl + End


Firefox Quantum
Move tab in focus to end
Windows and tabs

Ctrl + End


Windows 3.1
Puts the cursor to the end of an open document
Common features

Ctrl + End


Everything
Navigate item focus
Result list

Ctrl + End


Narrator
Move the Narrator cursor to the last line of text and then read it
Scan mode keyboard commands

Ctrl + End


Audacity
Move Focus to Last Track
Tracks menu

Ctrl + End


Wordpad
Move to the end of the document
General

Ctrl + End


Microsoft OneNote
Scroll to the bottom of the current page
Work with pages and Quick Notes

Ctrl + End


Outlook 2016 and Outlook 2013
Display (without selecting) the last item on the timeline (if items are not grouped) or the last item in the group
Timeline view (Tasks): When an item is selected

Ctrl + End


Command Line
Delete text from the insertion point to the end of the current line
Text manipulation

Ctrl + End


Microsoft Excel 2007 (Windows)
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text
Navigating in Worksheets and Selecting Cells

Ctrl + End


Google Spreadsheets (Web Application)
Go to last cell in data region
Movement within worksheets

Ctrl + End


Open Office Writer 3 (Windows)
Go to end of document
General OpenOffice Writer Shortcuts

Ctrl + End


Open Office Writer 3 (Windows)
If the active cell is empty, ctrl+end moves the cursor to the end of the table. Pressing ctrl+end again moves the cursor to the end of document.
Working with Tables

Ctrl + End


Microsoft Excel 2007 (Windows)
Move to the end of a text box.
Smart-Art Graphics : Work with Text

Ctrl + End


InDesign CS5 (Windows)
Move to start or end of story
Navigating Through and Editing Text

Ctrl + Home / Ctrl + End


InDesign CS5 (Windows)
Select start or end of story
Navigating Through and Editing Text

Shift + Ctrl + Home / Ctrl + End


Microsoft Outlook 2007 (Windows)
Display (without selecting) the first or last item on the timeline (if items are not categoryed) or the first item in the category.
Shortcuts for Timeline view (Tasks or Journal)

Ctrl + Home / Ctrl + End


Microsoft Word 2010 (Windows)
Jump to end / to beginning of document
Navigate within Documents

Ctrl + End / Ctrl + Home


Microsoft Word 2010 (Windows)
Move to first page / last page (with focus on preview page)
Print Documents

Ctrl + Home / Ctrl + End