Voir iotafinance en FrançaisYou are viewing the English version of iotafinance.comIotafinance auf Deutsch sehen
Icon for the financial resource section

Keyboard shortcuts in Open Office Calc for macOS

EDITING

Copy
command  +   C

Cut
command  +   X

Define a name for a cell
command  +  Shift  +   T

Display shortcut menu
Shift  +   F10

Edit active cell
F2

Insert column
command  +   +

Insert or edit cell comments
command  +  option  +   C

Insert row
command  +   +

Paste
command  +   V

Paste special
command  +  Shift  +   V

Repeat last command or action
Shift  +  command  +   Z

Start new line within cell
command  +   Enter

Sum selected cells
command  +  Shift  +   T

Toggle references
Shift  +   F4

Undo last command or action
command  +   Z

FORMATTING

Bold characters
command  +   B

Display format cells menu
command  +   1

Italic characters
command  +   I

Underline text
command  +   U

NAVIGATE

Move one cell down

Move one cell to the left

Move one cell to the right

Move one cell to the right in a worksheet
Tab

Move one cell up

Move one screen height down in a worksheet

Move one screen height up in a worksheet

Move one screen width to the left in a worksheet
option  +   Page Up

Move one screen width to the right in a worksheet
option  +   Page Down

Open the list of validation choices on a cell that uses data validation
option  +   Arrow down

FILES

Close the active workbook
command  +   W

Create a new workbook
command  +   N

Display «Save as » dialog box
command  +  Shift  +   S

Open workbook
command  +   O

Save file
command  +   S

SELECTION

Extend current selection by one cell or row downwards
Shift  +   Arrow down

Extend current selection by one cell or row to the left
Shift  +   Arrow left

Extend current selection by one cell or row to the right
Shift  +   Arrow right

Extend current selection by one cell or row to the top
Shift  +   Arrow up

Group active worksheet with worksheet to the left
control  +  Shift  +   Page Up

Group active worksheet with worksheet to the right
control  +  Shift  +   Page Down

Select entire column
command  +  Shift  +   Space

Select entire row
Shift  +   Space

Select entire sheet
command  +   A

OTHERS

Calculate all worksheets on all open workbooks
F9

Find and replace
command  +   F