List of Keyboard Shortcuts for Google Sheets
Windows
| Common actions | |
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + a Ctrl + Shift + Space |
| Undo | Ctrl + z |
| Redo | Ctrl + y Ctrl + Shift + z F4 |
| Find | Ctrl + f |
| Find and replace | Ctrl + h |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + d |
| Fill right | Ctrl + r |
| Save (every change is saved automatically in Drive) | Ctrl + s |
| Open | Ctrl + o |
| Ctrl + p | |
| Copy | Ctrl + c |
| Cut | Ctrl + x |
| Paste | Ctrl + v |
| Paste values only | Ctrl + Shift + v |
| Show common keyboard shortcuts | Ctrl + / |
| Insert new sheet | Shift + F11 |
| Compact controls | Ctrl + Shift + f |
| Input tools on/off (available in spreadsheets in non-Latin languages) | Ctrl + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k |
| Search the menus | Alt + / |
| Format cells | |
| Bold | Ctrl + b |
| Underline | Ctrl + u |
| Italic | Ctrl + i |
| Strikethrough | Alt + Shift + 5 |
| Center align | Ctrl + Shift + e |
| Left align | Ctrl + Shift + l |
| Right align | Ctrl + Shift + r |
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7 |
Ctrl + Shift + 7
Insert linkCtrl + kInsert timeCtrl + Shift + ;Insert dateCtrl + ;Insert date and timeCtrl + Alt + Shift + ;Format as decimalCtrl + Shift + 1Format as timeCtrl + Shift + 2Format as dateCtrl + Shift + 3Format as currencyCtrl + Shift + 4Format as percentageCtrl + Shift + 5Format as exponentCtrl + Shift + 6Clear formattingCtrl + \Navigate spreadsheetMove to beginning of the rowHomeMove to beginning of the sheetCtrl + HomeMove to the end of the rowEndMove to end of the sheetCtrl + EndScroll to the active cellCtrl + BackspaceMove to the next sheetAlt + Down ArrowMove to the previous sheetAlt + Up ArrowDisplay a list of sheetsAlt + Shift + kOpen hyperlinkAlt + EnterOpen ExploreAlt + Shift + xGo to the side panelCtrl + Alt + .Ctrl + Alt + ,Move focus out of the spreadsheetCtrl + Alt + Shift + mMove to quick sum
(when a range of cells is selected)Alt + Shift + qMove focus to popup
(for links, bookmarks, and images)holding Ctrl + Alt, press e then pOpen the drop-down menu on filtered cellCtrl + Alt + rOpen revision historyCtrl + Alt + Shift + hClose drawing editorShift + EscEdit notes and commentsInsert/edit noteShift + F2Insert/edit commentCtrl + Alt + mOpen comment discussion threadCtrl + Alt + Shift + aEnter current commentholding Ctrl + Alt, press e then cMove to the next commentholding Ctrl + Alt, press n then cMove to the previous commentholding Ctrl + Alt, press p then cUse keyboard shortcuts on selected commentsReply to the current commentRMove to the next commentJMove to the previous commentKResolve current commentEExit current commentUOpen a menuFile menuin Google Chrome: Alt + f
other browsers: Alt + Shift + fEdit menuin Google Chrome: Alt + e
other browsers: Alt + Shift + eView menuin Google Chrome: Alt + v
other browsers: Alt + Shift + vInsert menuin Google Chrome: Alt + i
other browsers: Alt + Shift + iFormat menuin Google Chrome: Alt + o
other browsers: Alt + Shift + oData menuin Google Chrome: Alt + d
other browsers: Alt + Shift + dTools menuin Google Chrome: Alt + t
other browsers: Alt + Shift + tOpen insert menuCtrl + Alt + Shift + =
Ctrl + Alt + =
(with cells selected)Open delete menuCtrl + Alt + – (with cells selected)Form menu
(present when the spreadsheet is connected to a form)in Google Chrome: Alt + m
other browsers: Alt + Shift + mAdd-ons menuin Google Chrome: Alt + n
other browsers: Alt + Shift + nHelp menuin Google Chrome: Alt + h
other browsers: Alt + Shift + hAccessibility menu
(present when screen reader support is enabled)in Google Chrome: Alt + a
other browsers: Alt + Shift + aSheet menu
(copy, delete, and other sheet actions)Alt + Shift + sContext menuCtrl + Shift + \
Shift + F10Add or change rows and columnsInsert rows aboveCtrl + Alt + Shift + =
Ctrl + Alt + =
(with rows selected)in Google Chrome: Alt + i, then r
other browsers: Alt + Shift + i, then rInsert rows belowin Google Chrome: Alt + i, then w
other browsers: Alt + Shift + i, then wInsert columns to the leftCtrl + Alt + Shift + =
Ctrl + Alt + =
(with columns selected)in Google Chrome: Alt + i, then c
other browsers: Alt + Shift + i, then cInsert columns to the rightin Google Chrome: Alt + i, then o
other browsers: Alt + Shift + i, then oDelete rowsCtrl + Alt + – (with rows selected)
in Google Chrome: Alt + e, then d
other browsers: Alt + Shift + e, then d
in Google Chrome: Alt + e, then e
other browsers: Alt + Shift + e, then e
(when entering a formula)Shift + F1Full/compact formula help
(when entering a formula)F1Absolute/relative references
(when entering a formula)F4Toggle formula result previews
(when entering a formula)F9Resize formula bar
(move up or down)Ctrl + Up / Ctrl + DownHelp for screen readersTurn on screen reader supportCtrl + Alt + zEnable braille supportCtrl + Alt + hRead columnCtrl + Alt + Shift + cRead rowCtrl + Alt + Shift + r
Mac
| Common actions | |
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | ⌘ + a ⌘ + Shift + Space |
| Undo | ⌘ + z |
| Redo | ⌘ + y ⌘ + Shift + z Fn + F4 |
| Find | ⌘ + f |
| Find and replace | ⌘ + Shift + h |
| Fill range | ⌘ + Enter |
| Fill down | ⌘ + d |
| Fill right | ⌘ + r |
| Save (every change is saved automatically in Drive) | ⌘ + s |
| Open | ⌘ + o |
| ⌘ + p | |
| Copy | ⌘ + c |
| Cut | ⌘ + x |
| Paste | ⌘ + v |
| Paste values only | ⌘ + Shift + v |
| Show common keyboard shortcuts | ⌘ + / |
| Insert new sheet | Shift + Fn + F11 |
| Compact controls | Ctrl + Shift + f |
| Input tools on/off (available in spreadsheets in non-Latin languages) | ⌘ + Shift + k |
| Select input tools | ⌘ + Option + Shift + k |
| Search the menus | Option + / |
| Format cells | |
| Bold | ⌘ + b |
| Underline | ⌘ + u |
| Italic | ⌘ + i |
| Strikethrough | Option + Shift + 5 |
| Center align | ⌘ + Shift + e |
| Left align | ⌘ + Shift + l |
| Right align | ⌘ + Shift + r |
| Apply top border | Option + Shift + 1 |
| Apply right border | Option + Shift + 2 |
| Apply bottom border | Option + Shift + 3 |
| Apply left border | Option + Shift + 4 |
| Remove borders | Option + Shift + 6 |
| Apply outer border | Option + Shift + 7 |
⌘ + Shift + 7
Insert link⌘ + kInsert time⌘ + Shift + ;Insert date⌘ + ;Insert date and time⌘ + Option + Shift + ;Format as decimalCtrl + Shift + 1Format as timeCtrl + Shift + 2Format as dateCtrl + Shift + 3Format as currencyCtrl + Shift + 4Format as percentageCtrl + Shift + 5Format as exponentCtrl + Shift + 6Clear formatting⌘ + \Navigate spreadsheetMove to beginning of the rowFn + Left ArrowMove to beginning of the sheet⌘ + Fn + Left ArrowMove to the end of the rowFn + Right ArrowMove to the end of the sheet⌘ + Fn + Right ArrowScroll to the active cell⌘ + BackspaceMove to the next sheetOption + Down ArrowMove to the previous sheetOption + Up ArrowDisplay a list of sheetsOption + Shift + kOpen hyperlinkOption + EnterOpen ExploreOption + Shift + xGo to the side panel⌘ + Option + .⌘ + Option + ,Move focus out of the spreadsheetCtrl + ⌘ + Shift + mMove to quick sum
(when a range of cells is selected)Option + Shift + qMove focus to popup
(for links, bookmarks, and images)holding Ctrl + ⌘, press e then pOpen the drop-down menu on filtered cellCtrl + ⌘ + rOpen revision history⌘ + Option + Shift + hClose drawing editor⌘ + Esc
Shift + EscEdit notes and commentsInsert/edit noteShift + F2Insert/edit comment⌘ + Option + mOpen comment discussion thread⌘ + Option + Shift + aEnter current commentholding Ctrl + ⌘, press e then cMove to the next commentholding Ctrl + ⌘, press n then cMove to the previous commentholding Ctrl + ⌘, press p then cUse keyboard shortcuts on selected commentsReply to the current commentRMove to the next commentJMove to the previous commentKResolve current commentEExit current commentUOpen a menuFile menuCtrl + Option + fEdit menuCtrl + Option + eView menuCtrl + Option + vInsert menuCtrl + Option + iFormat menuCtrl + Option + oData menuCtrl + Option + dTools menuCtrl + Option + tOpen insert menu⌘ + Option + = (with cells selected)Open delete menu⌘ + Option + – (with cells selected)Form menu
(present when the spreadsheet is connected to a form)Ctrl + Option + mAdd-ons menuCtrl + Option + nHelp menuCtrl + Option + hAccessibility menu
(present when screen reader support is enabled)Ctrl + Option + aSheet menu
(copy, delete, and other sheet actions)Option + Shift + sContext menu⌘ + Shift + \
Shift + F10Add or change rows and columnsInsert rows above⌘ + Option + = (with rows selected)
Ctrl + Option + i, then rInsert rows belowCtrl + Option + i, then bInsert columns to the left⌘ + Option + = (with columns selected)
Ctrl + Option + i, then cInsert columns to the rightCtrl + Option + i, then oDelete rows⌘ + Option + – (with rows selected)
Ctrl + Option + e, then dDelete columns⌘ + Option + – (with columns selected)
Ctrl + Option + e, then eHide row⌘ + Option + 9Unhide row⌘ + Shift + 9Hide column⌘ + Option + 0Unhide column⌘ + Shift + 0Group rows or columnsOption + Shift + Right ArrowUngroup rows or columnsOption + Shift + Left ArrowExpand grouped rows or columnsOption + Shift + Down Arrow Collapse grouped rows or columnsOption + Shift + Up Arrow Use formulasShow all formulasCtrl + ~Insert array formula⌘ + Shift + EnterCollapse an expanded array formula⌘ + eShow/hide formula help
(when entering a formula)Shift + Fn + F1Full/compact formula help
(when entering a formula)Fn + F1Absolute/relative references
(when entering a formula)Fn + F4Toggle formula result previews
(when entering a formula)Fn + F9Resize formula bar
(move up or down)Ctrl + Option + Up and Ctrl + Option + DownHelp for screen readersTurn on screen reader support⌘ + Option + zEnable braille support⌘ + Option + hRead column⌘ + Option + Shift + cRead row⌘ + Option + Shift + r
Chrome OS
| Common actions | |
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + a |
| Undo | Ctrl + z |
| Redo | Ctrl + y Ctrl + Shift + z |
| Find | Ctrl + f |
| Find and replace | Ctrl + h |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + d |
| Fill right | Ctrl + r |
| Save (every change is saved automatically in Drive) | Ctrl + s |
| Open | Ctrl + o |
| Ctrl + p | |
| Copy | Ctrl + c |
| Cut | Ctrl + x |
| Paste | Ctrl + v |
| Paste values only | Ctrl + Shift + v |
| Show common keyboard shortcuts | Ctrl + / |
| Compact controls | Ctrl + Shift + f |
| Input tools on/off (available in spreadsheets in non-Latin languages) | Ctrl + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k |
| Search the menus | Alt + / |
| Format cells | |
| Bold | Ctrl + b |
| Underline | Ctrl + u |
| Italic | Ctrl + i |
| Strikethrough | Alt + Shift + 5 |
| Center align | Ctrl + Shift + e |
| Left align | Ctrl + Shift + l |
| Right align | Ctrl + Shift + r |
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7 Ctrl + Shift + 7 |
| Insert link | Ctrl + k |
| Insert time | Ctrl + Shift + ; |
| Insert date | Ctrl + ; |
| Insert date and time | Ctrl + Alt + Shift + ; |
| Format as decimal | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + \ |
| Navigate spreadsheet | |
| Move to beginning of the row | Search + Left Arrow |
| Move to the end of the row | Search + Right Arrow |
| Move to the first cell in row with data | Ctrl + Left Arrow |
| Move to the top left of the sheet | Ctrl + Search + Left Arrow |
| Move to the last cell in the row with the data | Ctrl + Right Arrow |
| Move to the bottom right of the sheet | Ctrl + Search + Right Arrow |
| Scroll to the active cell | Ctrl + Backspace |
| Move to beginning of the sheet | Ctrl + Search + Left Arrow |
| Move to the end of the sheet | Ctrl + Search + Right Arrow |
| Move to the next sheet | Ctrl + Shift + Search + Down Arrow |
| Move to the previous sheet | Ctrl + Shift + Search + Up Arrow |
| Display a list of sheets | Alt + Shift + k |
| Open hyperlink | Alt + Enter |
| Open Explore | Alt + Shift + x |
| Go to the side panel | Alt + Shift + . Alt + Shift + , |
| Move focus out of the spreadsheet | Ctrl + Alt + Shift + m |
| Move to quick sum (when a range of cells is selected) | Alt + Shift + q |
| Move focus to popup (for links, bookmarks, and images) | holding Ctrl + Alt, press e then p |
| Open the drop-down menu on filtered cell | Ctrl + Alt + r |
| Open revision history | Ctrl + Alt + Shift + h |
| Close drawing editor | Ctrl + Esc Shift + Esc |
| Edit notes and comments | |
| Insert/edit note | Shift + Search + 2 |
| Insert/edit comment | Ctrl + Alt + m |
| Open comment discussion thread | Ctrl + Alt + Shift + a |
| Enter current comment | holding Ctrl + Alt, press e then c |
| Move to the next comment | holding Ctrl + Alt, press n then c |
| Move to the previous comment | holding Ctrl + Alt, press p then c |
| Use keyboard shortcuts on selected comments | |
| Reply to the current comment | R |
| Move to the next comment | J |
| Move to the previous comment | K |
| Resolve current comment | E |
| Exit current comment | U |
| Open a menu | |
| File menu | Alt + f |
| Edit menu | Alt + e |
| View menu | Alt + v |
| Insert menu | Alt + i |
| Format menu | Alt + o |
| Data menu | Alt + d |
| Tools menu | Alt + t |
| Open insert menu | Ctrl + Alt + = (with cells selected) |
| Open delete menu | Ctrl + Alt + – (with cells selected) |
| Form menu (present when the spreadsheet is connected to a form) | Alt + m |
| Add-ons menu | Alt + n |
| Help menu | Alt + h |
| Accessibility menu (present when screen reader support is enabled) | Alt + a |
| Sheet menu (copy, delete, and other sheet actions) | Ctrl + Shift + s |
| Context menu | Ctrl + Shift + \ Shift + F10 |
| Add or change rows and columns | |
| Insert rows above | Ctrl + Alt + = (with rows selected) Alt + i, then r |
| Insert rows below | Alt + i, then w |
| Insert columns to the left | Ctrl + Alt + = (with columns selected) Alt + i, then c |
| Insert columns to the right | Alt + i, then o |
| Delete rows | Ctrl + Alt + – (with rows selected) Alt + e, then d |
| Delete columns | Ctrl + Alt + – (with columns selected) Alt + e, then e |
| Hide rows | Ctrl + Alt + 9 |
| Unhide rows | Ctrl + Shift + 9 |
| Hide columns | Ctrl + Alt + 0 |
| Unhide columns | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right Arrow |
| Ungroup rows or columns | Alt + Shift + Left Arrow |
| Expand grouped rows or columns | Alt + Shift + Down Arrow |
| Collapse grouped rows or columns | Alt + Shift + Up Arrow |
| Use formulas | |
| Show all formulas | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + e |
| Show/hide formula help (when entering a formula) | Shift + Search + 1 |
| Full/compact formula help (when entering a formula) | Search + 1 |
| Absolute/relative references (when entering a formula) | Search + 4 |
| Toggle formula result previews (when entering a formula) | Search + 9 |
| Resize formula bar (move up or down) | Ctrl + Shift + Up Arrow and |
Ctrl + Shift + Down Arrow
Help for screen readersTurn on screen reader supportCtrl + Alt + zEnable braille supportCtrl + Alt + hRead columnCtrl + Alt + Shift + cRead rowCtrl + Alt + Shift + r
Android
| Action | Shortcut |
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + a Ctrl + Shift + Space |
| Undo | Ctrl + z |
| Redo | Ctrl + y Ctrl + Shift + z |
| Find | Ctrl + f |
| Find and replace | Ctrl + h |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + d |
| Fill right | Ctrl + r |
| Ctrl + p | |
| Copy | Ctrl + c |
| Cut | Ctrl + x |
| Paste | Ctrl + v |
| Paste values only | Ctrl + Shift + v |
| Paste format only | Ctrl + Alt + v |
| Show common keyboard shortcuts | Ctrl + / |
| Insert new sheet | Ctrl + t |
| Move to sheet at index # | Ctrl + [1-9] |
| Action | Shortcut |
|---|---|
| Bold | Ctrl + b |
| Underline | Ctrl + u |
| Italic | Ctrl + i |
| Strikethrough | Alt + Shift + 5 |
| Center align | Ctrl + Shift + e |
| Left align | Ctrl + Shift + l |
| Right align | Ctrl + Shift + r |
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7 |
| Insert link | Ctrl + k |
| Insert time | Ctrl + Shift + ; |
| Insert date | Ctrl + ; |
| Format as automatic | Ctrl + Shift + ‘ |
| Format as decimal | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + \ |
| Insert rows | Ctrl + Alt + = |
| Insert columns | Ctrl + Alt + = Ctrl + Alt + Shift + = (with columns selected) |
| Delete rows | Ctrl + Alt + – (with rows selected) |
| Delete columns | Ctrl + Alt + – (with columns selected) |
| Group rows or columns | Alt + Shift + Right arrow |
| Ungroup rows or columns | Alt + Shift + Left arrow |
| Expand grouped rows or columns | Alt + Shift + Down arrow |
| Collapse grouped rows or columns | Alt + Shift + Up arrow |
| Action | Shortcut |
|---|---|
| Move to section boundary | Ctrl + Arrow keys |
| Select from current position to section boundary | Ctrl + Shift + Arrow keys |
| Scroll to active cell | Ctrl + Backspace |
| Move to next sheet | Ctrl + Tab |
| Move to previous sheet | Ctrl + Shift + Tab |
| Display list of sheets | Alt + Shift + k |
| Open hyperlink | Alt + Enter |
| Open Explore | Alt + Shift + x |
| Action | Shortcut |
|---|---|
| Insert/edit note | Shift + F2 |
| Insert/edit comment | Ctrl + Alt + m |
| Open comment discussion thread | Ctrl + Alt + Shift + a |
| Action | Shortcut |
|---|---|
| Insert menu | in Google Chrome: Alt + i other browsers: Alt + Shift + i |
| Format menu | in Google Chrome: Alt + o other browsers: Alt + Shift + o |
| Sheet menu (copy, delete, and other sheet actions) | Alt + Shift + s |
| Context menu | Ctrl + Shift + \ |
iPhone & iPad
| Action | Shortcut |
|---|---|
| Bold | ⌘ + b |
| Underline | ⌘ + u |
| Italicize | ⌘ + i |
| Find and replace | ⌘ + f |
| Strikethrough | ⌘ + Shift + x |
| Undo | ⌘ + z |
| Redo | ⌘ + Shift + z |
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | ⌘ + a |
| ⌘ + p | |
| Copy | ⌘ + c |
| Cut | ⌘ + x |
| Paste | ⌘ + v |
| Center align | ⌘ + Shift + e |
| Left align | ⌘ + Shift + l |
| Right align | ⌘ + Shift + r |
| Insert rows above | ⌘ + Option + = (with rows selected) |
| Insert columns to the left | ⌘ + Option + = (with columns selected) |
| Move selection by cell | Up/Down/Left/Right arrow |
| Expand selection by cell | Shift + Up/Down/Left/Right arrow |
| Move to the edge of the current data region | ⌘ + Up/Down/Left/Right arrow |
| Expand the selection of cells to the edge of the current data region if the next cell is filled. Otherwise, expand the selected cell to the next empty cell in the specified direction. | ⌘ + Shift + Up/Down/Left/Right arrow |
| Delete content from cell | Backspace/Delete |
Categories:
keyboard shortcuts