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
