Quick access toolbar: Undo last command

Cmd+Z

Quick access toolbar: Redo

Cmd+Y

Quick access toolbar: Repeat last command

Cmd+Shift+Y

File | New

Cmd+N

File | Open

Cmd+O

File | Close

Cmd+W or Cmd+F4

File | Save

Cmd+S

File | Print

Cmd+P

File | File manager

F12

File | Exit

Cmd+Q or Alt+F4

Home | Paste

Cmd+V

Home | Paste Special

Cmd+Alt+V

Home | Cut

Cmd+X

Home | Copy

Cmd+C

Home | Format painter (copying step)

Cmd+Shift+C

Home | Format painter (pasting step)

Cmd+Shift+V

Home | group Character:

Open the "Character" dialog box

Cmd+2

Select font from the list

Cmd+D

Bold on/off

Cmd+B

Italics on/off

Cmd+I

Underline on/off

Cmd+U

Superscript

Cmd+Shift+Plus key (numeric keypad)

Subscript

Cmd+Shift+Minus key (numeric keypad)

Remove superscript or subscript

Cmd+Shift+Multiply key (numeric keypad)

Change uppercase/lowercase of selected text
(from "test" to "Test" to "TEST")

Shift+F3

Home | group Alignment:

Open the "Cell" dialog box

Cmd+1

Alignment: Left

Cmd+L

Alignment: Centered

Cmd+E

Alignment: Right

Cmd+R

Alignment: Justified

Cmd+J

Line break for current cell

Cmd+Enter

Home | group Number:

Open the "Cell" dialog box

Cmd+1

Number format: Number

Cmd+Shift+1

Number format: Scientific

Cmd+Shift+2

Number format: Currency

Cmd+Shift+4

Number format: Percentage

Cmd+Shift+5

Home| group Cells:

Insert cells

Cmd+Plus

Delete cells

Cmd+Minus

Hide current row

Cmd+9

Show current row

Cmd+Shift+9

Hide current column

Cmd+8

Show current column

Cmd+Shift+8

Home | Search

Cmd+F

Home | Replace

Cmd+H

Home | Search again (or Replace again)

F3

Home | Go to

Cmd+G or F5

Go to the next error

Cmd+F3

Home| Select all

Ctrl+A

Insert | Table

Cmd+T

Insert | Hyperlink

Cmd+K

Insert | Comment

Shift+F2

Insert | Character | Em dash (—)

Cmd+Alt+Minus key (numeric keypad)

Insert | Character | Non-breaking space

Cmd+Shift+Space

Formula | Insert function

F7

Formula | Update data:

Update charts

F8

Update calculations

F9

Recalculate the current worksheet only

Shift+F9

View | Full screen

F6

Edit the content of the current cell

F2

Expand or collapse the ribbon

Cmd+F1

Move to the next ribbon tab

Ctrl+F12

Move to the previous ribbon tab

Ctrl+Shift+F12

Move to the next worksheet
(for open dialog boxes: move to the next tab)

Ctrl+Tab

Move to the previous worksheet
(for open dialog boxes: move to the previous tab)

Ctrl+Shift+Tab

Select the next object (in object mode)

Tab

Select the previous object (in object mode)

Shift+Tab

Move to the next cell

ß/à/á/â

Move to the next / previous cell horizontally

Tab / Shift+Tab

Move to the next / previous cell vertically

Enter / Shift+Enter

Move to the next filled cell

Cmd+ß/à/á/â

Move to the first cell in the current column

Cmd+PageUpá

Move to the last cell in the current column

Cmd+PageDownâ

Move to the first cell in the current row

Home

Move to the last filled cell in the current row

End

Move to the first cell in the worksheet (A1)

Cmd+Home

Move to the last filled cell in the worksheet

Cmd+End

Move to the next circular reference

Shift+F5

Go to the next error

Cmd+F3

Copy cell above

Ctrl+, (comma)

Copy value from cell above

Ctrl+Shift+, (comma)

Enter an array formula

Cmd+Shift+↵

Select current array formula

Cmd+7

Select current conditional formatting

Cmd+6

Open a selection list with the contents of the cells above or below a cell

Alt+Shift+â

Switch between AUTO and TEXT input mode
(see Status bar)

Cmd+Shift+F4

Insert current date

Ctrl+. (period)

Insert current time

Ctrl+Shift+. (period)

Convert a hexadecimal character code into Unicode characters*

Cmd+Alt+Shift+X