Calc GuideAAppendix
Keyboard Shortcuts
This PDF is designed to be read onscreen, two pages at atime. If you want to print a copy, your PDF viewer shouldhave an option for printing two pages on one sheet ofpaper, but you may need to start with page 2 to get it toprint facing pages correctly. (Print this cover pageseparately.)CopyrightThis document is Copyright © 2005–2010 by its contributors as listed
in the section titled Authors. You may distribute it and/or modify it
under the terms of either the GNU General Public License, version 3 orlater, or the Creative Commons Attribution License, version 3.0 orlater.
All trademarks within this guide belong to their legitimate owners.

Authors
Richard Barnes
Peter Kupfer
Iain Roberts
Magnus Adielsson
Sandeep Samuel Medikonda
Jean Hollis Weber

Feedback
Please direct any comments or suggestions about this document to:authors@documentation.openoffice.org

Acknowledgments
Much credit for this work is due to the unselfish efforts of Bill Wilson
and Dr. Bob Smith.

Publication date and software version
Published 16 March 2010. Based on OpenOffice.org 3.2.

You can download
an editable version of this document fromhttp://oooauthors.org/english/userguide3/published/

Contents
Copyright............................................................................................... 2
Introduction........................................................................................... 4Navigation and selection shortcuts........................................................4
Function and arrow key shortcuts.........................................................6
Cell formatting shortcuts.......................................................................7
DataPilot shortcuts................................................................................8Keyboard Shortcuts3

Introduction
You can use Calc without a pointing device such as a mouse or
trackball, by using its built-in keyboard shortcuts.
OOo has a general set of keyboard shortcuts, available in allcomponents, and a component-specific set directly related to the workof that component.
For help with OOo’s keyboard shortcuts or using OOo with a keyboard
only, search the OOo online help using the “shortcut” or “accessibility”
keywords.
In addition to using the built-in keyboard shortcuts listed in thisAppendix, you can define your own. See Chapter 14 (Setting Up andCustomizing Calc) for instructions.
Formatting and editing shortcuts are described in Chapter 2 (Entering,Editing, and Formatting Data).

Navigation and selection shortcuts
Table 1: Spreadsheet navigation shortcuts

4

Shortcut Keys

EffectCtrl+Home

Moves the cursor to the first cell in the sheet (cell A1).

Ctrl+End

Moves the cursor to the last cell on the sheet that
contains data.

Home

Moves the cursor to the first cell of the current row.

End

Moves the cursor to the last cell of the current row ina column containing data.

Ctrl+Left Arrow

Moves the cursor to the left edge of the current datarange. If the column to the left of the cell that contains
the cursor is empty, the cursor moves to the next
column to the left that contains data.

Ctrl+Right Arrow

Moves the cursor to the right edge of the current data
range. If the column to the right of the cell that
contains the cursor is empty, the cursor moves to thenext column to the right that contains data.

Ctrl+Up Arrow

Moves the cursor to the top edge of the current data
range. If the row above the cell that contains thecursor is empty, the cursor moves up to the next row
that contains data.

Keyboard Shortcuts

Shortcut Keys

EffectCtrl+Down Arrow

Moves the cursor to the bottom edge of the current
data range. If the row below the cell that contains thecursor is empty, the cursor moves down to the next
row that contains data.

Ctrl+Shift+Arrow

Selects all cells containing data from the current cellto 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 isselected.

Ctrl+Page Up

Moves one sheet to the left. In the page preview it
moves to the previous print page.

Ctrl+Page Down

Moves one sheet to the right. In the page preview it
moves to the next print page.

Page Up

Moves the viewable rows up one screen.

Page Down

Moves the viewable rows down one screen.

Alt+Page Up

Moves the viewable columns one screen to the left.

Alt+Page Down

Moves the viewable columns one screen to the right.

Shift+Ctrl+PageUp

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

Shift+Ctrl+Page
Down

Adds the next sheet to the current selection of sheets.
If all the sheets in a spreadsheet are selected, thiscombination only selects the next sheet. Makes thenext sheet the current sheet.

Ctrl+*

Selects the data range that contains the cursor. A
range is a contiguous cell range that contains data andis bounded by empty rows and columns. The “*” key is
the multiplication sign on the numeric key pad.

Ctrl+/

Selects the matrix formula range that contains thecursor. The “/” key is the division sign on the numeric
key pad.

Enter — in a
selected range

By default, moves the cursor down one cell in a
selected range. To specify the direction that the cursor
moves, choose Tools > Options > OpenOffice.org
Calc > General.

Navigation and selection shortcuts

5

Function and arrow key shortcuts
Table 2: Function key shortcuts

6

Shortcut Keys

EffectF1

Displays the OOo help browser. When the help browser
is already open F1 jumps to the main help page.

Shift+F1

Displays context help.

Ctrl+F1

Displays the note that is attached to the current cell.

F2

Switches to Edit mode and places the cursor at the endof the contents of the current cell. If the cursor is in an
input box in a dialog that has a minimize button, thedialog is hidden and the input box remains visible.
Press F2 again to show the whole dialog.

Ctrl+F2

Opens the Function Wizard.

Shift+Ctrl+F2

Moves the cursor to the input line where you can enter
a formula for the current cell.

Ctrl+F3

Opens the Define Names dialog.

F4Shows or hides the Database Sources menu.

Shift+F4

Rearranges the relative or absolute references (forexample, A1, $A$1, $A1, A$1) in the input field.

F5Shows or hides the Navigator.

Shift+F5

Traces dependents.

Shift+Ctrl+F5

Moves the cursor to the Name box.

F7

Checks spelling in the current sheet.

Ctrl+F7

Opens the Thesaurus if the current cell contains text.

Shift+F7

Traces precedents.

F8Turns 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.

Ctrl+F8

Highlights cells containing numeric values (not text).

F9

Recalculates all of the formulas in the sheet.

Ctrl+F9

Updates the selected chart.

F11

Opens the Styles and Formatting window where you
can apply a formatting style to the contents of the cellor to the current sheet.

Shift+F11

Creates a document template.
Keyboard Shortcuts

Shortcut Keys

EffectShift+Ctrl+F11

Updates the templates.

F12Groups the selected data range.

Ctrl+F12

Ungroups the selected data range.

Table 3. Arrow key shortcuts
Shortcut Keys

EffectAlt+Down Arrow

Increases the height of current row.

Alt+Up Arrow

Decreases the height of current row.

Alt+Right Arrow

Increases the width of the current column.

Alt+Left Arrow

Decreases the width of the current column.

Alt+Shift+Arrow
KeyOptimizes the column width or row height based on
the current cell.

Cell formatting shortcuts
Ctrl+1 open the Format Cells dialog.

NoteThe shortcuts listed in Table 4 do not work under any Linux
desktop tested. If you would like to have the functionalitydescribed in this table, you must create custom key sequences
as explained in Chapter 14 (Setting Up and Customizing Calc).

NoteThe shortcut keys shown in Table 4 do not use the number keys
on the number pad. They use the number keys above the letter
keys on the main keyboard.

Table 4: Formatting shortcut keys
Shortcut Keys

EffectCtrl+Shift+1

Two decimal places, thousands separator

Ctrl+Shift+2

Standard exponential format

Ctrl+Shift+3

Standard date format

Ctrl+Shift+4Standard currency format

Ctrl+Shift+5Standard percentage format (two decimal places)

Ctrl+Shift+6

Standard format

Cell formatting shortcuts

7

DataPilot shortcuts
Table 5: DataPilot shortcut keys

8

Shortcut Keys

EffectTab

Changes the focus by moving forward through theareas and buttons of the dialog.

Shift+Tab

Changes the focus by moving backward through theareas and buttons of the dialog.

Up arrow

Moves the focus up one item in the current dialog
area.

Down arrow

Moves the focus down one item in the current dialog
area.

Left arrow

Moves the focus one item to the left in the current
dialog area.

Right arrowMoves the focus one item to the right in the current
dialog area.

Home

Selects the first field in the current layout area.

End

Selects the last field in the current layout area.

Alt+R

Copies or moves the current field into the “Row” area.

Alt+C

Copies or moves the current field into the “Column”
area.

Alt+D

Copies or moves the current field into the “Data” area.

Ctrl+Up Arrow

Moves the current field up one place.

Ctrl+Down Arrow

Moves the current field down one place.

Ctrl+Left Arrow

Moves the current field one place to the left.

Ctrl+Right Arrow

Moves the current field one place to the right.

Ctrl+Home

Moves the current field to the first place.

Ctrl+End

Move the current field to the last place.

Alt+O

Displays the options for the current field.

DeleteRemoves the current field from the area.

Keyboard Shortcuts