Keyboard shortcuts for open and libre office calc


Tony Ballou
 

Hi folks,


Here's the second half of this ballgame. 


Tony


Open and libre office calc keyboard shortcuts

Open office and libre office calc keyboard shortcuts

 

 Modifier Key

Key

Description of shortcut

  Shift

1

Two decimal places, thousands separator

  Shift

2

Standard exponential format

  Shift

3

Standard date format

  Shift

4

Standard currency format

  Shift

5

Standard percentage format (two decimal places)

  Shift

6

Standard format

Alt  

C

Copies or moves the current field into the “column” area

Alt  

D

Copies or moves the current field into the “data” area

 

Delete

Removes the current field from the area

 

Down Arrow

Moves the focus down one item in the current dialog area

 

Down Arrow

Moves the current field down one place

 

End

Selects the last field in the current layout area

 

End

Move the current field to the last place

 

Home

Selects the first field in the current layout area

 

Home

Moves the current field to the first place

 

Left Arrow

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

 

Left Arrow

Moves the current field one place to the left

Alt  

O

Displays the options for the current field

Alt  

R

Copies or moves the current field into the “row” area

 

Right Arrow

Moves the focus one item to the right in the current dialog area

 

Right Arrow

Moves the current field one place to the right

 

Tab

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

  Shift

Tab

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

 

Up Arrow

Moves the focus up one item in the current dialog area

 

Up Arrow

Moves the current field up one place

Alt  

Down Arrow

Increases the height of current row

 

F1

Displays the ooo help browser. When the help browser is already open f1 jumps to the main help page

  Shift

F1

Displays context help

 

F1

Displays the note that is attached to the current cell

 

F11

Opens the styles and formatting window where you can apply a formatting style to the contents of the cell or to the current sheet

  Shift

F11

Creates a document template

  Shift

F11

Updates the templates

 

F12

Groups the selected data range

 

F12

Ungroups the selected data range

 

F2

Switches to edit mode and places the cursor at the end of the contents of the current cell. 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

Opens the function wizard

  Shift

F2

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

 

F3

Opens the define names dialog

 

F4

Shows or hides the database sources menu

  Shift

F4

Rearranges the relative or absolute references (for example, a1, $a$1, $a1, a$1) in the input field

 

F5

Shows or hides the navigator

  Shift

F5

Traces dependents

  Shift

F5

Moves the cursor to the name box

 

F7

Checks spelling in the current sheet

  Shift

F7

Traces precedents

 

F7

Opens the thesaurus if the current cell contains text

 

F8

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

Highlights cells containing numeric values (not text)

 

F9

Recalculates all of the formulas in the sheet

 

F9

Updates the selected chart

Join nvda@nvda.groups.io to automatically receive all group messages.