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