Microsoft Excel Shortcuts — Dev Shortcuts Hub

Navigation

Shortcut	Description
`Ctrl`+`HomeCmd`+`Home`	Go to cell A1
`Ctrl`+`EndCmd`+`End`	Go to last used cell
`Ctrl`+`ArrowCmd`+`Arrow`	Jump to edge of data region
`Ctrl`+`BackspaceCmd`+`Delete`	Scroll to show active cell
`Ctrl`+`GCmd`+`G`	Go To dialog (jump to named range)
`Ctrl`+`FCmd`+`F`	Find
`Ctrl`+`HCmd`+`H`	Find and Replace
`Page Up/DownPage Up/Down`	Move one screen up/down
`Alt`+`Page Up/DownOption`+`Page Up/Down`	Move one screen left/right
`Ctrl`+`Page Up/DownCmd`+`Page Up/Down`	Next / previous worksheet

Data Entry & Editing

Shortcut	Description
`F2Ctrl`+`U`	Edit active cell (enter edit mode)
`Ctrl`+`EnterCtrl`+`Return`	Fill selection with entry
`Ctrl`+`DCmd`+`D`	Fill down from cell above
`Ctrl`+`RCmd`+`R`	Fill right from cell to left
`Ctrl`+`;Ctrl`+`;`	Insert current date
`Ctrl`+`Shift`+`;Ctrl`+`Shift`+`;`	Insert current time
`Ctrl`+`'Ctrl`+`'`	Copy formula from cell above
`Alt`+`EnterCtrl`+`Option`+`Return`	New line within cell
`DeleteDelete`	Clear cell contents
`Ctrl`+`ZCmd`+`Z`	Undo
`Ctrl`+`YCmd`+`Y`	Redo

Selection Tricks

Shortcut	Description
`Ctrl`+`ACmd`+`A`	Select all / select current region
`Ctrl`+`Shift`+`EndCmd`+`Shift`+`End`	Extend selection to last used cell
`Ctrl`+`Shift`+`ArrowCmd`+`Shift`+`Arrow`	Extend selection to data edge
`Ctrl`+`SpaceCtrl`+`Space`	Select entire column
`Shift`+`SpaceShift`+`Space`	Select entire row
`Shift`+`ClickShift`+`Click`	Extend selection to clicked cell
`Ctrl`+`ClickCmd`+`Click`	Add individual cells to selection

Formulas & Functions

Shortcut / Formula	Action / Description
`==`	Start a formula
`F4Cmd`+`T`	Toggle absolute/relative reference ($A$1)
`Alt`+`=Cmd`+`Shift`+`T`	AutoSum selected range
`Ctrl`+`Shift`+`EnterCmd`+`Shift`+`Return`	Enter array formula (legacy)
`Ctrl`+``Ctrl`+`	Toggle show formulas / values
`F9Cmd`+`=`	Recalculate all formulas
`Ctrl`+`[Cmd`+`[`	Select precedent cells (what feeds this)
`Ctrl`+`]Cmd`+`]`	Select dependent cells (what uses this)
`=VLOOKUP(A1,range,col,FALSE)`	Exact match lookup (old method)
`=XLOOKUP(A1,range,return_range)`	Modern flexible lookup
`=SUMIF(range,"criteria",sum_range)`	Conditional sum
`=COUNTIF(range,"criteria")`	Count cells matching criteria
`=IF(A1>10,"High","Low")`	Conditional logic
`=IFERROR(formula,"Error msg")`	Graceful error handling
`=TEXT(A1,"MM/DD/YYYY")`	Format date as text string

Formatting

Shortcut	Description
`Ctrl`+`1Cmd`+`1`	Format Cells dialog
`Ctrl`+`BCmd`+`B`	Bold
`Ctrl`+`Shift`+`$Cmd`+`Shift`+`$`	Currency format
`Ctrl`+`Shift`+`%Cmd`+`Shift`+`%`	Percentage format
`Ctrl`+`Shift`+`#Cmd`+`Shift`+`#`	Date format (DD-MMM-YY)
`Ctrl`+`Shift`+`!Cmd`+`Shift`+`!`	Number format with commas
`Alt`+`H`+`HOption`+`H`+`H`	Fill color picker
`Alt`+`H`+`BOption`+`H`+`B`	Border picker