Google Sheets Shortcuts — Dev Shortcuts Hub

Navigation & Selection

Shortcut	Description
`Ctrl`+`HomeCmd`+`Home`	Go to cell A1
`Ctrl`+`EndCmd`+`End`	Go to last cell with data
`Ctrl`+`ArrowCmd`+`Arrow`	Jump to edge of data
`Ctrl`+`FCmd`+`F`	Find
`Ctrl`+`HCmd`+`H`	Find and Replace
`Ctrl`+`Shift`+`EndCmd`+`Shift`+`End`	Select to last data cell
`Ctrl`+`ACmd`+`A`	Select all
`Ctrl`+`SpaceCtrl`+`Space`	Select column
`Shift`+`SpaceShift`+`Space`	Select row
`Alt`+`i`+`rOption`+`i`+`r`	Insert row above
`Alt`+`i`+`bOption`+`i`+`b`	Insert row below

Editing

Shortcut	Description
`F2Return`	Edit active cell
`Ctrl`+`EnterCmd`+`Return`	Fill selection with entry
`Ctrl`+`DCmd`+`D`	Fill down
`Ctrl`+`RCmd`+`R`	Fill right
`Ctrl`+`;Cmd`+`;`	Insert current date
`Ctrl`+`Shift`+`;Cmd`+`Shift`+`;`	Insert current time
`Alt`+`EnterCtrl`+`Return`	New line within cell
`Ctrl`+`ZCmd`+`Z`	Undo
`Ctrl`+`YCmd`+`Shift`+`Z`	Redo
`DeleteDelete`	Clear cell

Google Sheets Unique Features

Formula / Shortcut	Description
`=IMPORTRANGE("url","Sheet1!A1:B10")`	Pull data from another Google Sheet
`=GOOGLEFINANCE("GOOGL","price")`	Live stock price
`=GOOGLETRANSLATE(A1,"en","es")`	Translate text in a cell
`=IMAGE("url")`	Display image from URL in cell
`=SPARKLINE(range)`	Mini chart inside a cell
`=ARRAYFORMULA(A1:A10*2)`	Apply formula to whole range without dragging
`=QUERY(range,"SELECT A,B WHERE C>100")`	SQL-like queries on data
`=UNIQUE(range)`	Return only unique values
`=SPLIT(A1,",")`	Split text by delimiter into columns
`=REGEXEXTRACT(A1,"\d+")`	Extract text matching regex pattern

Formatting

Shortcut	Description
`Ctrl`+`BCmd`+`B`	Bold
`Ctrl`+`ICmd`+`I`	Italic
`Ctrl`+`UCmd`+`U`	Underline
`Ctrl`+`Shift`+`ECmd`+`Shift`+`E`	Center align
`Ctrl`+`\Cmd`+`\`	Clear formatting
`Ctrl`+`Shift`+`$Cmd`+`Shift`+`$`	Currency format
`Ctrl`+`Shift`+`%Cmd`+`Shift`+`%`	Percentage format
`Alt`+`O`+`C`+`AOption`+`O`+`C`+`A`	Resize column to fit content