keyboard
| Cursor Mode |
|
|
|
| Hotkey |
Effect |
Hotkey |
Effect |
| <F2> |
Enter edit mode |
<Ctrl>+<Home> |
Move cursor to A1 |
| <Ctrl>+X |
Cut selected region |
<Ctrl>+<End> |
Move cursor to last cell |
| <Ctrl>+C |
Copy selected region |
<Enter> |
Move cursor down |
| <Ctrl>+V |
Paste |
<Shift>+<Enter> |
Move cursor up |
| <Ctrl>+B |
Toggle bold formatting in selected region |
<Tab> |
Move cursor right |
| <Ctrl>+I |
Toggle italic formatting in selected region |
<Shift>+<Tab> |
Move cursor left |
| <Ctrl>+U |
Toggle underline in selected region |
<Home> |
Move cursor to first column |
| <Ctrl>+L |
Align selected region to left |
<End> |
Move cursor to last column with content |
| <Ctrl>+E |
Align selected region to centre |
<PgUp> |
Scroll screen upward |
| <Ctrl>+R |
Align selected region to right |
<PgDn> |
Scroll screen downward |
| <Ctrl>+F (FireFox only) |
Find |
<Alt>+<PgUp> |
Scroll screen to the left |
| <Del> |
Clear cell content |
<Alt>+<PgDn> |
Scroll screen to the right |
| <Shift>+Arrow key |
Select region |
<Ctrl>+<Shift>+<PgUp> |
Switch to the previous sheet |
| <Shift>+<PgUp>|<PgDn> |
Select region |
<Ctrl>+<Shift>+<PgDn> |
Switch to the next sheet |
| <Shift>+<Home>|<End>
|<Ctrl>+<Home>
|<Ctrl>+<End> |
Select region |
<Ctrl>+` |
Toggle formula mode |
| <Ctrl>+A |
Select all |
<Ctrl>+2 |
Lock cell/region |
| <Ctrl>+1 |
Advanced number formatting |
<Ctrl>+<Alt>+2 |
Toggle show/hide cell/region locks |
| <Ctrl>+Z |
Undo |
<Ctrl>+<Alt>+S |
Sort data |
| <Ctrl>+Y |
Redo |
|
|
| 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 |