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