Quick access toolbar: Undo last command

Ctrl+Z

Quick access toolbar: Redo

Ctrl+Y

Quick access toolbar: Repeat last command

Ctrl+Shift+Y

File | New

Ctrl+N

File | Open

Ctrl+O

File | Close

Ctrl+W or Ctrl+F4

File | Save

Ctrl+S

File | Print

Ctrl+P

File | File manager

F12

File | Exit

Ctrl+Q or Alt+F4

Home | Paste

Ctrl+V

Home | Paste Special

Ctrl+Alt+V

Home | Cut

Ctrl+X

Home | Copy

Ctrl+C

Home | Format painter (copying step)

Ctrl+Shift+C

Home | Format painter (pasting step)

Ctrl+Shift+V

Home | group Character:

Open the "Character" dialog box

Ctrl+2

Select font from the list

Ctrl+D

Bold on/off

Ctrl+B

Italics on/off

Ctrl+I

Underline on/off

Ctrl+U

Superscript

Ctrl+Shift+Plus key (numeric keypad)

Subscript

Ctrl+Shift+Minus key (numeric keypad)

Remove superscript or subscript

Ctrl+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

Ctrl+1

Alignment: Left

Ctrl+L

Alignment: Centered

Ctrl+E

Alignment: Right

Ctrl+R

Alignment: Justified

Ctrl+J

Line break for current cell

Ctrl+Enter

Home | group Number:

Open the "Cell" dialog box

Ctrl+1

Number format: Number

Ctrl+Shift+1

Number format: Scientific

Ctrl+Shift+2

Number format: Currency

Ctrl+Shift+4

Number format: Percentage

Ctrl+Shift+5

Home| group Cells:

Insert cells

Ctrl+Plus

Delete cells

Ctrl+Minus

Hide current row

Ctrl+9

Show current row

Ctrl+Shift+9

Hide current column

Ctrl+8

Show current column

Ctrl+Shift+8

Home | Search

Ctrl+F

Home | Replace

Ctrl+H

Home | Search again (or Replace again)

F3

Home | Go to

F5 or Ctrl+G

Go to the next error

Ctrl+F3

Home| Select all

Ctrl+A

Insert | Table

Ctrl+T

Insert | Hyperlink

Ctrl+K

Insert | Comment

Shift+F2

Insert | Character | Em dash (—)

Ctrl+Alt+Minus key (numeric keypad)

Insert | Character | Non-breaking space

Ctrl+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

Display help content

F1

Edit the content of the current cell

F2

Show/hide ribbon

Ctrl+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

Ctrl+ß/à/á/â

Move to the first cell in the current column

Ctrl+PageUpá

Move to the last cell in the current column

Ctrl+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)

Ctrl+Home

Move to the last filled cell in the worksheet

Ctrl+End

Move to the next circular reference

Shift+F5

Go to the next error

Ctrl+F3

Copy cell above

Ctrl+, (comma)

Copy value from cell above

Ctrl+Shift+, (comma)

Enter an array formula

Ctrl+Shift+↵

Select current array formula

Ctrl+7

Select current conditional formatting

Ctrl+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)

Ctrl+Shift+F4

Insert current date

Ctrl+. (period)

Insert current time

Ctrl+Shift+. (period)

Convert a hexadecimal character code into Unicode characters*

Ctrl+Alt+Shift+X