LibreOffice Calc

Navigating

In the print preview: Moves to the next print page

Ctrl + Page Down

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


Eclipse Helios (Windows)
Switch to next editor / switch to previous editor
Editor Window

Ctrl + Page Down / Ctrl + Page Up


Adobe Reader 9 (Linux)
Jump one page down / one page up
Navigation

Ctrl + Page Down / Ctrl + Page Up


Adobe Reader X (Windows)
Jump one page down / one page up
Navigation

Ctrl + Page Down / Ctrl + Page Up


Microsoft Word 2007 (Windows)
Move to the next edit location.
Working with documents: Switch to another view

Ctrl + Page Down


Firefox (Linux)
Jump to next browser tab
Navigation

Ctrl + Tab / Ctrl + Page Down


Firefox (Windows)
Jump to next browser tab
Navigation

Ctrl + Tab / Ctrl + Page Down


Google Chrome (Windows)
Switch to the previous tab
Manage Tabs

Ctrl + Shift + Tab / Ctrl + Page Down


Microsoft OneNote 2010 (Windows)
Go to the next / previous page in the section.
Managing Pages, Notebooks and Sections

ctrl + page down / ctrl + page up


SharpDevelop 4.0 (Windows)
Toggle mode between editor / designer mode
Standard Editor Shortcuts

Ctrl + Page Up / Ctrl + Page Down


Inpage (Windows)
To go one screen right
For Page Movement

Ctrl + Page Down


SharpDevelop 4.0 (Windows)
Toggle mode between editor mode and designer mode
Manage Windows

Ctrl + Page Up / Ctrl + Page Down


Access 2010 (Windows)
Move right one screen / left one screen
Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Page Down / Ctrl + Page Up


Microsoft Word 2007 (Windows)
To the top of the next page
Edit and move text and graphics: Move through your document

Ctrl + Page Down


Microsoft PowerPoint 2003 (Windows)
Switch to the next tab in a dialog box
40 Shortcuts for Microsoft PowerPoint 2003 (Windows)

Ctrl + Tab / Ctrl + Page Down


Microsoft Excel 2011 (MacOS)
Move to the next sheet / to the previous sheet in the workbook
Moving and scrolling in a sheet or workbook

Ctrl + Page Down / Ctrl + Page Up


Total Commander 8 (Windows)
Open directory/archive (also self extracting .EXE archives)
Main Shortcuts

Ctrl + Page down


Open Office Impress (Linux)
Go to the next slide.
Slide Shows

Ctrl + Page Down


Tekla Structures 14.0 (Windows)
Open next drawing / open previous drawing
Drawing shortcuts

Ctrl + Page Down / Ctrl + Page Up


Microsoft Excel 2011 (MacOS)
Move to a new record
Data forms

Ctrl + Page Down


Sublime Text (Windows)
Move to next/ previous open tab
Manage Sublime Window, Files and Tabs

Ctrl + Page Down / Page Up


Access 2010 (Windows)
Move right one screen / left one screen
Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Page Down / Ctrl + Page Up


CATIA V5 (Windows)
Zoom in / zoom out the model or tree whichever is active
38 Shortcuts for CATIA V5 (Windows)

Ctrl + Page Up / Ctrl + Page Down


Visual Studio 2015 (Windows)
Cycle between design, split and source
For HTML Pages

Ctrl + Page Down / Page Up


HoneyView 5.03 (Windows)
previous 10 images / nexst 10 images
Main Shortcuts

Ctrl + Page Up / Ctrl + Page Down


Adobe Reader X (Linux)
Jump one page down / one page up
Navigation

Ctrl + Page Down / Ctrl + Page Up


Microsoft Word 2013 (Windows)
Move to beginning of next page / beginning of previous page
Navigate in Word Documents

Ctrl + Page Down / Page Up


Virtual DJ (Windows)
Crossfader 4096
All Shortcuts

Ctrl + Page Down


Access 2010 (Windows)
Move right one screen / left one screen
Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Page Down / Ctrl + Page Up


Adobe Acrobat Pro (Windows)
Next page
Navigation - Navigating a PDF

Arrow Right / Ctrl + Page Down


Microsoft Excel 2013 (Windows)
Move to the next / previous worksheet in current workbook
Manage Multipe Worksheets

Ctrl + Page Down / Page Up


Microsoft Excel 2013 (Windows)
Move to a new record
Data Forms

Ctrl + Page Down


Microsoft Excel 2010 (Windows)
Move to the next / previous worksheet in current workbook.
Manage Multipe Worksheets

Ctrl + Page Down / Ctrl + Page Up


Microsoft OneNote 2016 (Windows)
Go to next/ previous page in section
Manage Pages, Notebooks and Sections

Ctrl + Page Down / Page Up


Microsoft Excel 2010 (Windows)
Move to a new record.
Data Forms

Ctrl + Page Down


Access 2010 (Windows)
Move right one screen / left one screen
The Rest - Navigate in Datasheet, Subdatasheet, and Form View

Ctrl + Page Down / Ctrl + Page Up


Microsoft Excel 2016 (Windows)
Move to a new record
Select Cells - Data Forms

Ctrl + Page Down


Microsoft Excel 2016 (Windows)
Move to a new record
Format Cells - Data Forms

Ctrl + Page Down


FileMaker Pro (Windows)
Scroll the document to the left / to the right
Navigation and Window Display

Ctrl + Page Up / Ctrl + Page Down


Microsoft Excel 2016 (Windows)
Move to a new record
Formulas - Data Forms

Ctrl + Page Down


Dynamics NAV 2015 (Windows)
Display next Document or card in a list
Documentaion

Ctrl + Page Down


Microsoft Excel 2016 (Windows)
Move to a new record
Manage Workbooks - Data Forms

Ctrl + Page Down


AutoCAD 2016 (Windows)
Moves to the next layout tab
General

Ctrl + PAGE DOWN


AutoCad Architecture 2017 (Windows)
Moves the cursor to the bottom of the currently visiblepage of text
Text Editing

Ctrl + Page down


Microsoft Excel 2016 (Windows)
Move to a new record
Excel Auto Tables and Data Forms - Data Forms

Ctrl + Page Down


Autodesk 3ds Max 2017 (Windows)
Select children
Hierarchies

Ctrl + Page down


Microsoft Excel 2016 (Windows)
Move to the next/ previous worksheet in current workbook
Manage Worksheet Tabs

Ctrl + Page Down / Page Up


Corel Draw X8 (Windows)
Back one
Object Ordering

Ctrl + Page down


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

Ctrl + Page Down


Houdini (Windows)
Next pan tab
Main Menu

Ctrl + Page down


Corel Draw X8 (Windows)
Cursor to end of text
Cursor Moves Using Text Tool

Ctrl + Page down


Soundforge (Windows)
Move 100% of the current view past the cursor position
Cursor Movements

Ctrl + Page Down


Quickbooks Desktop (Windows)
First item on list / last item on list (or first/previous month in register)
General Editing

Ctrl + Page Up / Ctrl + Page Down


Vivaldi
Next tab (by order)
Tab

Ctrl + Page Down


CuteFTP (Windows)
Download
General

Ctrl + Page Down


Inkscape (Windows)
In a multi-tab dialog, switch tabs
Dialog

Ctrl + Page Up / Ctrl + Page Down


Browser tab management
Go to next tab
KDE / GNOME

Ctrl + Page Down


Ableton Live 9 (Windows)
Scroll Editor Horizontally
Clip View MIDI Editor

Ctrl + Ppage up / Ctrl + Page Down


Altium Designer (Windows)
Fit all objects into view
Schematic Editor Only Shortcuts

Ctrl + Page Down


Altium Designer (Windows)
Fit document into view
PCB Editor Only Shortcuts

Ctrl + Page Down


Google Chrome
Jump to the next open tab
Tab and window shortcuts

Ctrl + Page Down


Altium Designer (Windows)
Fit document
SimData Editor Shortcuts

Ctrl + Page Down


Altium Designer (Windows)
Move cursor to bottom of window
Common Shortcuts

Ctrl + Page Down


AutoCAD
Switch to next tab in current drawing
Manage Drawings

Ctrl + Page Down


Shotcut
Forward 5 Seconds
Player

Ctrl + Page Down


QuickBooks Desktop
Move to the last item in a list or register
Maneuvering

Ctrl + Page Down


PyCharm 2018.2
Move the caret down to the page bottom.
Basic editing

Ctrl + Page Down


Telegram
Move to next chat
General

Ctrl + Page Down


Quicken 2018
Next month
Moving around in windows and fields

Ctrl + Page Down


Atom (Windows)
pane:show-next-item
All shortcuts

Ctrl + Page Down


ActivePresenter 7
Arrange: Order backward
Text

Ctrl + Page Down


jEdit
Go to next buffer.
Files

Ctrl + Page Down


CorelDRAW Graphics Suite 2018
Back One
General

Ctrl + Page Down


Nuance Power PDF
Scroll to top of next page
Page

Ctrl + Page Down


Virtual DJ 2018
Crossfader 0%
General

Ctrl + Page Down


Microsoft FrontPage
Move between Code, Design, Split, and Preview views.
Access and use views

Ctrl + Page Down


Microsoft Word 2016
To the top of the next page
Move around in a document

Ctrl + Page Down


Microsoft Paint
Zoom out
Powers of Ctrl

Ctrl + Page Down


Comodo IceDragon
Next Tab
Windows and Tabs

Ctrl + Page Down


NetBeans
Switch between open documents by order of tabs
Opening and toggling between views

Ctrl + Page Down


LibreOffice Impress
Go to the next slide
Slide shows

Ctrl + Page Down


Microsoft PowerPoint (Slideshows)
Scroll down one screenful in the Notes pane
Maneuver in Presenter View during a presentation

Ctrl + Page Down


LibreOffice Base
Jumps between tabs
Creating Basic dialogs

Ctrl + Page Down


LibreOffice Draw
Switch to next layer
Shortcut keys specific to drawings

Ctrl + Page Down


LibreOffice Writer
Switch cursor between text and footer
General

Ctrl + Page Down


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

Ctrl + Page Down


Maple
Move forward through multiple open worksheet and document tabs in a Maple window
General

Ctrl + Page Down


LibreOffice
Moves pointer to the last row
Selecting rows and columns in a database table

Ctrl + Page Down


Tekla Structures 20
Open next drawing
Drawing

Ctrl + Page Down


NewsBin Pro
Move to down
Download tab

Ctrl + Page Down


Midnight Commander
move to the child directory
File panel actions

Ctrl + Page Down


KompoZer
Switch to Next Tab (when using Tabbed Browsing with more than one tab)
General

Ctrl + Page Down


Sublime Text
Cycle down through tabs
Tabs

Ctrl + Page Down


Lightworks
Go to last row in Bin
General

Ctrl + Page Down


Vuze
Tab to the left or right (doesn't work to get out of sub-tabs like in statistics)
General

Ctrl + Page Down


WPS Office
Switches between worksheet tabs, from right-to-left
General

Ctrl + Page Down


Eclipse
Switch to previous editor
Editor

Ctrl + Page Down


REAPER
View: Zoom out project
Section: Main

Ctrl + Page Down


FileZilla
Switch to previous tab
Advanced

Ctrl + Page Down


Delphi
Moves to the bottom of a screen
General

Ctrl + Page Down


Microsoft Excel 2016
Switches between worksheet tabs, from right-to-left
CTRL combination shortcut keys

Ctrl + Page Down


SQL Server Management Studio (SSMS)
Moves to the next tab in the document
Cursor movement

Ctrl + Page Down


7-Zip
Open current item as folder inside 7-Zip
File menu

Ctrl + Page Down


Notepad++
Previous document
File menu

Ctrl + Page Down


Microsoft Access 2016
Move to the current field in the next record
Form view: Navigate between fields and records

Ctrl + Page Down


Firefox Quantum
Next tab
Windows and tabs

Ctrl + Page Down


Everything
Navigate item focus
Result list

Ctrl + Page Down


Opera
Move one screen-full to the right
Movement

Ctrl + Page Down


Adobe Acrobat Reader DC
Jump one page down
Navigation

Ctrl + Page Down


Mozilla Thunderbird
Next tab
Controlling Thunderbird windows and tabs

Ctrl + Page Down


Adobe Acrobat 2017 (Windows and Unix)
Next page
Navigating PDF

Ctrl + Page Down


Wordpad
Move down one page
General

Ctrl + Page Down


Microsoft OneNote
Go to the next page in the section
Work with notebooks and sections

Ctrl + Page Down


Adobe Reader 9 (Windows)
Jump one page down / one page up
Navigation

Ctrl + Page Down / Ctrl + Page Up


Microsoft Excel 2007 (Windows)
Moves to the next sheet in a workbook.
Navigating in Worksheets and Selecting Cells

Ctrl + Page Down


Google Spreadsheets (Web Application)
Move to next / move to previousworksheet
Movement within worksheets

Ctrl + Page Down / Ctrl + Page Up


Open Office Writer 3 (Windows)
Switch cursor between text and footer
General OpenOffice Writer Shortcuts

Ctrl + Page Down


Open Office Impress (Windows)
Go to the next slide.
Slide Shows

Ctrl + Page Down


Tupi (Windows)
Extend current frame
Animation Module

Ctrl + Page Down


Microsoft Word 2010 (Windows)
Move to next / move to previous browser object as set in Browse Options
Navigate within Documents

Ctrl + Page Down / Ctrl + Page Up


Xactimate
Go to Next Level
Additional shortcut keys

Ctrl + Page Down