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