GOOGLE SHEETS
Shortcuts
Master Google Sheets with these essential productivity keys
Keyboard cheat sheet
Select a shortcut below to locate its keys.
Core shortcuts · 10
View in list ↓An editorial selection to learn recurring tasks first, in the same order as the core list below.
How core shortcuts are selected
These are editorial recommendations, not usage rankings. We prioritize recurring tasks, fewer mouse trips, and combinations that are easy to learn. App-specific actions are labeled.
The same layout at every screen size.
Core shortcuts · 10
CmdShiftLCreate or remove filter
F2Edit active cell
CmdEnterFinish formula entry or toggle checkboxes
CmdOptShiftK / CInsert row above / column left
CmdShiftVPaste without formatting
Cmd/Show keyboard shortcuts help
Cmd\Clear all formatting
CmdShift1-5Apply quick data formats (Number, Percentage, etc.)
CmdOpt9 / 0Hide row or column
CmdKInsert or edit link
01 — Cell Interaction
F2Edit active cell
CmdShiftVPaste without formatting
Cmd\Clear formatting
CmdKInsert link
CmdEnterToggle checkbox
02 — Rows & Columns
CmdOptShiftKInsert row above
CmdAltShiftCInsert column left
CmdOpt-Delete row
CmdAlt-Delete column
CmdjSelect row
CmdShiftjSelect column
CmdOpt9Hide row
CmdOpt0Hide column
03 — Navigation & Formatting
CmdShiftLToggle filter
CmdShift1Format as decimal
CmdShift2Format as time
CmdShift3Format as date
CmdShift4Format as currency
CmdShift5Format as percentage
CmdShift7Apply border
04 — Formulas & Help
CmdShiftEnterInsert ArrayFormula
Cmd/Show all keyboard shortcuts
OptionShiftISearch the menus