All hotkeys for Google Sheets (Mac)
Common actionsSelect column |
Ctrl + Space |
Common actionsSelect row |
↑ Shift + Space |
Common actionsSelect all |
⌘ Cmd + A |
Common actions%% Select all |
⌘ Cmd + ↑ Shift + Space |
Common actionsUndo |
⌘ Cmd + Z |
Common actionsRedo |
⌘ Cmd + Y |
Common actionsRedo |
⌘ Cmd + ↑ Shift + Z |
Use formulas(when entering a formula) Absolute/relative references |
Fn + F4 |
Common actionsFind |
⌘ Cmd + F |
Common actionsFind and replace |
⌘ Cmd + ↑ Shift + H |
Common actionsFill range |
⌘ Cmd + ⤶ Enter |
Common actionsFill down |
⌘ Cmd + D |
Common actionsFill right |
⌘ Cmd + R |
Common actionsSave (every change is saved automatically in Drive) |
⌘ Cmd + S |
Common actionsOpen |
⌘ Cmd + O |
Common actions |
⌘ Cmd + P |
Common actionsCopy |
⌘ Cmd + C |
Common actionsCut |
⌘ Cmd + X |
Common actionsPaste |
⌘ Cmd + V |
Common actionsPaste values only |
⌘ Cmd + ↑ Shift + V |
Common actionsShow common keyboard shortcuts |
⌘ Cmd + / |
Common actionsCompact controls |
Ctrl + ↑ Shift + F |
Common actionsInput tools on/off (available in spreadsheets in non-Latin languages) |
⌘ Cmd + ↑ Shift + K |
Common actionsSelect input tools |
⌘ Cmd + ⌥ Option + ↑ Shift + K |
Format cellsBold |
⌘ Cmd + B |
Format cellsUnderline |
⌘ Cmd + U |
Format cellsItalic |
⌘ Cmd + İ |
Format cellsStrikethrough |
⌥ Option + ↑ Shift + 5 |
Format cellsCenter align |
⌘ Cmd + ↑ Shift + E |
Format cellsLeft align |
⌘ Cmd + ↑ Shift + L |
Format cellsRight align |
⌘ Cmd + ↑ Shift + R |
Format cellsApply top border |
⌥ Option + ↑ Shift + 1 |
Format cellsApply right border |
⌥ Option + ↑ Shift + 2 |
Format cellsApply bottom border |
⌥ Option + ↑ Shift + 3 |
Format cellsApply left border |
⌥ Option + ↑ Shift + 4 |
Format cellsRemove borders |
⌥ Option + ↑ Shift + 6 |
Format cellsApply outer border |
⌥ Option + ↑ Shift + 7 |
Format cellsApply outer border |
⌘ Cmd + ↑ Shift + 7 |
Format cellsInsert link |
⌘ Cmd + K |
Format cellsInsert time |
⌘ Cmd + ↑ Shift + ; |
Format cellsInsert date |
⌘ Cmd + ; |
Format cellsInsert date and time |
⌘ Cmd + ⌥ Option + ↑ Shift + ; |
Format cellsFormat as decimal |
Ctrl + ↑ Shift + 1 |
Format cellsFormat as time |
Ctrl + ↑ Shift + 2 |
Format cellsFormat as date |
Ctrl + ↑ Shift + 3 |
Format cellsFormat as currency |
Ctrl + ↑ Shift + 4 |
Format cellsFormat as percentage |
Ctrl + ↑ Shift + 5 |
Format cellsFormat as exponent |
Ctrl + ↑ Shift + 6 |
Format cellsClear formatting |
⌘ Cmd + \ |
Navigate spreadsheetMove to beginning of row |
Fn + ← |
Navigate spreadsheetMove to beginning of sheet |
⌘ Cmd + Fn + ← |
Navigate spreadsheetMove to end of row |
Fn + → |
Navigate spreadsheetMove to end of sheet |
⌘ Cmd + Fn + → |
Navigate spreadsheetScroll to active cell |
⌘ Cmd + ⬅ Backspace |
Navigate spreadsheetMove to next sheet |
⌘ Cmd + ↑ Shift + Fn + ↓ |
Navigate spreadsheetMove to previous sheet |
Ctrl + ↑ Shift + Fn + ↑ |
Navigate spreadsheetDisplay list of sheets |
⌥ Option + ↑ Shift + K |
Navigate spreadsheetOpen hyperlink |
⌥ Option + ⤶ Enter |
Navigate spreadsheetOpen Explore |
⌥ Option + ↑ Shift + X |
Navigate spreadsheetMove focus out of spreadsheet |
Ctrl + ⌘ Cmd + ↑ Shift + M |
Navigate spreadsheetMove to quicksum (when a range of cells is selected) |
⌥ Option + ↑ Shift + Q |
Navigate spreadsheetMove focus to popup (for links, bookmarks, and images) |
Ctrl + ⌘ Cmd then E then P |
Navigate spreadsheetOpen drop-down menu on filtered cell |
Ctrl + ⌘ Cmd + R |
Navigate spreadsheetOpen revision history |
⌘ Cmd + ⌥ Option + ↑ Shift + H |
Navigate spreadsheetClose drawing editor |
↑ Shift + Esc |
Navigate spreadsheetClose drawing editor |
⌘ Cmd + Esc |
Edit notes and commentsInsert/edit note |
↑ Shift + F2 |
Edit notes and commentsInsert/edit comment |
⌘ Cmd + ⌥ Option + M |
Edit notes and commentsOpen comment discussion thread |
⌘ Cmd + ⌥ Option + ↑ Shift + A |
Edit notes and commentsEnter current comment |
Ctrl + ⌘ Cmd then E then C |
Edit notes and commentsMove to next comment |
Ctrl + ⌘ Cmd then N then C |
Edit notes and commentsMove to previous comment |
Ctrl + ⌘ Cmd then P then C |
Open a menuFile menu |
Ctrl + ⌥ Option + F |
Open a menuEdit menu |
Ctrl + ⌥ Option + E |
Open a menuView menu |
Ctrl + ⌥ Option + V |
Open a menuInsert menu |
Ctrl + ⌥ Option + I |
Open a menuFormat menu |
Ctrl + ⌥ Option + O |
Open a menuData menu |
Ctrl + ⌥ Option + D |
Open a menuTools menu |
Ctrl + ⌥ Option + T |
Insert, delete, hide, or unhide rows or columns(with columns selected) Insert columns to the left |
⌘ Cmd + ⌥ Option + = |
Insert, delete, hide, or unhide rows or columns(with rows selected) Delete rows |
⌘ Cmd + ⌥ Option + - |
Open a menuForm menu |
Ctrl + ⌥ Option + M |
Open a menuAdd-ons menu |
Ctrl + ⌥ Option + N |
Open a menu(in Google Chrome) Help menu |
Alt + H |
Open a menu(in other browsers) Help menu |
Alt + ↑ Shift + H |
Open a menu(present when screen reader support is enabled) Accessibility menu |
Ctrl + ⌥ Option + A |
Open a menuSheet menu (copy, delete, and other sheet actions) |
⌥ Option + ↑ Shift + S |
Open a menuContext menu |
⌘ Cmd + ↑ Shift + \ |
Insert, delete, hide, or unhide rows or columns(with rows selected) Insert rows above |
Ctrl + ⌥ Option + I then R |
Insert, delete, hide, or unhide rows or columnsInsert rows below |
Ctrl + ⌥ Option + I then B |
Insert, delete, hide, or unhide rows or columns(with columns selected) Insert columns to the left |
Ctrl + ⌥ Option + I then C |
Insert, delete, hide, or unhide rows or columnsInsert columns to the right |
Ctrl + ⌥ Option + I then O |
Insert, delete, hide, or unhide rows or columns(with rows selected) Delete rows |
Ctrl + ⌥ Option + E then D |
Insert, delete, hide, or unhide rows or columns(with columns selected) Delete columns |
Ctrl + ⌥ Option + - |
Insert, delete, hide, or unhide rows or columns(with columns selected) Delete columns |
Ctrl + ⌥ Option + E then E |
Insert, delete, hide, or unhide rows or columnsHide row |
⌘ Cmd + ⌥ Option + 9 |
Insert, delete, hide, or unhide rows or columnsHide column |
⌘ Cmd + ⌥ Option + 0 |
Use formulasShow all formulas |
Ctrl + ~ |
Use formulasInsert array formula |
⌘ Cmd + ↑ Shift + ⤶ Enter |
Use formulasCollapse an expanded array formula |
⌘ Cmd + E |
Use formulas(when entering a formula) Show/hide formula help |
↑ Shift + Fn + F1 |
Use formulas(when entering a formula) Full / compact formula help |
Fn + F1 |
Use formulas(when entering a formula) Toggle formula result previews |
Fn + F9 |
Use formulasResize formula bar |
Ctrl + ⌥ Option + ↑ ↓ |
Help for screen readersTurn on screen reader support |
⌘ Cmd + ⌥ Option + Z |
Help for screen readersRead column |
⌘ Cmd + ⌥ Option + ↑ Shift + C |
Help for screen readersRead row |
⌘ Cmd + ⌥ Option + ↑ Shift + R |