Ultimate Guide of Keyboard Shortcuts for Google Sheets

Translate in 

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
Print	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

Delete columnsCtrl + Alt + – (with columns selected)

in Google Chrome: Alt + e, then e
other browsers: Alt + Shift + e, then e

Hide rowCtrl + Alt + 9Unhide rowCtrl + Shift + 9Hide columnCtrl + Alt + 0Unhide columnCtrl + Shift + 0Group rows or columnsAlt + Shift + Right ArrowUngroup rows or columnsAlt + Shift + Left ArrowExpand grouped rows or columnsAlt + Shift + Down ArrowCollapse grouped rows or columnsAlt + Shift + Up ArrowUse formulasShow all formulasCtrl + ~Insert array formulaCtrl + Shift + EnterCollapse an expanded array formulaCtrl + eShow/hide formula help
(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
Print	⌘ + 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
Print	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

 

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
Print	⌘ + 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

For the latest tech news and reviews, follow Rohit Auddy on Twitter, Facebook, and Google News.