Skip to content

Keyboard shortcuts

Subset has native keyboard shortcuts to speed up spreadsheet building.

General

Shortcut name	Keycode(s)
Open command menu	`⌘` + `k`, or `Ctrl` + `k`
Undo	`⌘` + `z`, or `Ctrl` + `z`
Redo	`⌘` + `⇧` + `z`, or `⌘` + `y`, or `Ctrl` + `⇧` + `z`, or `Ctrl` + `y`
Next sheet	`⌘` + `PageDown`, or `⌥` + `⌘` + `→`, or `⌥` + `↓`, or `Ctrl` + `PageDown`
Previous sheet	`⌘` + `PageUp`, or `⌥` + `⌘` + `←`, or `⌥` + `↑`, or `Ctrl` + `PageUp`
Add row/column	`⌘` + `⇧` + `+`
Delete row/column	`⌘` + `⇧` + `-`
Select row	`⇧` + `Space`
Select column	`Ctrl` + `Space`
Move to end of range	`⌘` + `Arrow`
Find	`⌘` + `f`
Close sheet	`⌘` + `w`
Select all cells	`⌘` + `a`
Select multiple cells	`⇧` + `Arrow`

Menus

Shortcut name	Keycode(s)
Command menu	`⌘` + `k`, or `Ctrl` + `k`
Color dropdown menu	`⌥` + `c`
Number dropdown menu	`⌥` + `n`
Border dropdown menu	`⌥` + `b`

Clipboard

Shortcut name	Keycode(s)
Copy	`⌘` + `c`, or `Ctrl` + `c`
Cut	`⌘` + `x`, or `Ctrl` + `x`
Paste	`⌘` + `v`, or `Ctrl` + `v`
Paste special values	`⌘` + `⇧` + `v`
Paste special formats	`⌥` + `⇧` + `v`, or `⇧` + `v`
Paste special formulas	`⌥` + `⌘` + `v`
Escape	`Escape`

Formatting

Shortcut name	Keycode(s)
Align center	`⌥` + `a` + `c`
Align right	`⌥` + `a` + `r`
Align left	`⌥` + `a` + `l`
Decrease decimal	`⌘` + `9`, or `⌥` + `9`
Increase decimal	`⌘` + `0`, or `⌥` + `0`
Bold text	`⌘` + `b`, or `Ctrl` + `b`, or `⌥` + `1`
Italic text	`⌘` + `i`, or `Ctrl` + `i`, or `⌥` + `2`
Underline text	`⌘` + `u`, or `Ctrl` + `u`, or `⌥` + `3`
Cycle color	`⌘` + `⇧` + `;`
Toggle gridlines	`⌥` + `v` + `g`
Auto size columns	`⌥` + `h` + `o` + `i`

Formulas and analysis

Shortcut name	Keycode(s)
Autofill down	`⌘` + `d`, or `Ctrl` + `d`
Autofill right	`⌘` + `r`, or `Ctrl` + `r`
Auto sum	`⌥` + `=`
Sort ascending	`⌥` + `a` + `s` + `a`
Sort descending	`⌥` + `a` + `s` + `d`