keyboard

keyboard

Cursor Mode
Hotkey
Effect
Hotkey
Effect
<Ctrl>+1
Advanced number formatting
<Ctrl>+<Shift>+V
Paste to clipboard (windows only)
<Ctrl>+E
Align selected region to centre
<F9>
Recalculate
<Ctrl>+L
Align selected region to left
<Ctrl>+Y
Redo
<Ctrl>+R
Align selected region to right
<Ctrl>+A
Select all
<Del>
Clear cell content
<Shift>+Arrow key
Select region
<Ctrl>+<Shift>+C
Copy from clipboard (windows only)
<Shift>+<PgUp>|<PgDn>
Select region
<Ctrl>+C
Copy selected region
<Shift>+<Home>|<End>
|<Ctrl>+<Home>
|<Ctrl>+<End>
Select region
<Ctrl>+X
Cut selected region
<Ctrl>+<Alt>+S
Sort data
<F2>
Enter edit mode
<Ctrl>+B
Toggle bold formatting in selected region
<Ctrl>+F (FireFox only)
Find
<Ctrl>+I
Toggle italic formatting in selected region
<Ctrl>+3
Freeze/unfreeze pane
<Ctrl>+<Alt>+2
Toggle show/hide cell/region locks
<Ctrl>+2
Lock cell/region
<Ctrl>+U
Toggle underline in selected region
<Ctrl>+V
Paste
<Ctrl>+Z
Undo
<Ctrl>+G
Move to target cell
Edit Mode
Hotkey
Effect
Hotkey
Effect
<Enter>
Complete edit and move cursor down
=
Start a formula
<Shift>+<Enter>
Complete edit and move cursor up
<Ctrl>+X
Cut selection to clipboard
<Tab>
Complete edit and move cursor right
<Ctrl>+C
Copy selection to clipboard
<Shift>+<Tab>
Complete edit and move cursor left
<Ctrl>+V
Paste from clipboard
<Esc>
Cancel edit
<Ctrl>+Z
Undo
<Alt>+<Enter>
Insert line break
<Ctrl>+Y
Redo