Microsoft Excel Cheat Sheet

Shortcuts for Windows (on macOS most use ⌘ instead of Ctrl). Press Alt to see a letter on every ribbon button. 🇧🇪 Dutch/Belgian Excel: function names are translated and arguments are separated with ; instead of ,. See the table at the bottom.

105 entries
12 sections
Updated 1 Oct 2026

F

105 entries

On this page

Move Around #

Shortcut	Action
`Ctrl + ←/→/↑/↓`	Jump to the edge of the data
`Ctrl + Home` / `Ctrl + End`	Cell A1 / last used cell
`Ctrl + G` or `F5`	Go to a cell or named range
`Ctrl + PgUp/PgDn`	Previous / next sheet
`Ctrl + F6`	Next open workbook
`Alt + PgUp/PgDn`	One screen left / right

Select #

Shortcut	Action
`Shift + arrows`	Extend the selection
`Ctrl + Shift + arrows`	Select to the edge of the data
`Ctrl + A`	Select the current region (twice = whole sheet)
`Ctrl + Space`	Select the column
`Shift + Space`	Select the row
`Ctrl + Shift + End`	Select to the last used cell

Edit #

Shortcut	Action
`F2`	Edit the active cell
`Alt + Enter`	New line inside a cell
`Ctrl + Enter`	Fill all selected cells with the same entry
`Ctrl + D` / `Ctrl + R`	Fill down / right
`Ctrl + E`	Flash Fill (learns a pattern from your example)
`Ctrl + ;` / `Ctrl + Shift + ;`	Insert today's date / current time
`Ctrl + '`	Copy the formula from the cell above
`Ctrl + Alt + V`	Paste Special
`Ctrl + Shift + V`	Paste values only (Microsoft 365)
`Ctrl + Shift + +` / `Ctrl + -`	Insert / delete cells, rows or columns
`Ctrl + 9` / `Ctrl + 0`	Hide rows / columns
`Ctrl + Shift + 9`	Unhide rows
`F4`	Repeat the last action
`Ctrl + Z` / `Ctrl + Y`	Undo / redo

Format #

Shortcut	Action
`Ctrl + 1`	Format Cells dialog
`Ctrl + B` / `I` / `U`	Bold / italic / underline
`Ctrl + Shift + $`	Currency
`Ctrl + Shift + %`	Percentage
`Ctrl + Shift + !`	Number with 2 decimals
`Ctrl + Shift + #`	Date
`Ctrl + Shift + &` / `Ctrl + Shift + _`	Add outline border / remove borders
`Alt, H, O, I`	Autofit column width
Double-click a column border	Autofit that column

Formulas & Data #

Shortcut	Action
`=`	Start a formula
`Alt + =`	AutoSum
`F4` (while editing a reference)	Cycle `A1` → `$A$1` → `A$1` → `$A1`
`Shift + F3`	Insert Function dialog
Ctrl + `	Show formulas instead of results
`Ctrl + [`	Jump to the cells a formula uses
`F9`	Recalculate (inside the formula bar: evaluate the selected part)
`Ctrl + Shift + U`	Expand / collapse the formula bar
`Ctrl + T`	Turn a range into a Table
`Ctrl + Shift + L`	Toggle filters
`Alt + ↓`	Open the filter dropdown
`Alt + F1` / `F11`	Quick chart / chart on a new sheet
`Shift + F11`	New sheet
`Ctrl + K`	Insert link
`Alt + F11`	VBA editor

References #

Reference	Meaning
`A1`	Relative: shifts when copied
`$A$1`	Absolute: never shifts
`$A1` / `A$1`	Lock the column only / row only
`Sheet2!B3`	Another sheet
`'My Sheet'!B3`	Sheet name with spaces
`Table1[Price]`	A column in a Table (structured reference)
`A2#`	The whole spilled range of a dynamic formula

Essential Functions #

Function	Example
`SUM`, `AVERAGE`, `MIN`, `MAX`	`=SUM(B2:B100)`
`COUNT` / `COUNTA` / `COUNTBLANK`	Numbers / non-empty / empty cells
`ROUND`	`=ROUND(A1, 2)`
`IF`	`=IF(B2>=50, "Pass", "Fail")`
`IFS`	`=IFS(A1>90,"A", A1>75,"B", TRUE,"C")`
`AND` / `OR` / `NOT`	`=IF(AND(A1>0, B1>0), "ok", "")`
`IFERROR`	`=IFERROR(A1/B1, 0)`
`SUMIF` / `SUMIFS`	`=SUMIFS(C:C, A:A, "Bread", B:B, ">10")`
`COUNTIF` / `COUNTIFS`	`=COUNTIF(A:A, "Done")`
`AVERAGEIF(S)`	Average with conditions
`XLOOKUP`	`=XLOOKUP(E2, A:A, C:C, "Not found")`
`VLOOKUP`	`=VLOOKUP(E2, A:C, 3, FALSE)` (older; prefer XLOOKUP)
`INDEX` + `MATCH`	`=INDEX(C:C, MATCH(E2, A:A, 0))`

Dynamic Arrays (Excel 365 / 2021+) #

Function	Example
`FILTER`	`=FILTER(A2:C100, B2:B100="Open")`
`SORT` / `SORTBY`	`=SORT(A2:B20, 2, -1)` (column 2, descending)
`UNIQUE`	`=UNIQUE(A2:A100)`
`SEQUENCE`	`=SEQUENCE(10)` → 1 to 10
`LET`	`=LET(x, A1*2, x + 1)` (name parts of a formula)
`TEXTSPLIT`	`=TEXTSPLIT(A1, ",")`

Text & Dates #

Function	Example
`TEXTJOIN` / `CONCAT` / `&`	`=A1 & " " & B1`
`LEFT` / `RIGHT` / `MID`	`=LEFT(A1, 3)`
`LEN`, `TRIM`, `UPPER`, `LOWER`, `PROPER`	Length, remove extra spaces, change case
`SUBSTITUTE`	`=SUBSTITUTE(A1, ".", ",")`
`TEXTBEFORE` / `TEXTAFTER`	`=TEXTBEFORE(A1, "@")`
`TEXT`	`=TEXT(A1, "dd/mm/yyyy")`
`TODAY()` / `NOW()`	Current date / date + time
`DATE`, `YEAR`, `MONTH`, `DAY`	Build or split dates
`EDATE` / `EOMONTH`	+N months / end of month
`NETWORKDAYS`	Working days between two dates
`DATEDIF`	`=DATEDIF(A1, TODAY(), "y")` → age in years

Error Values #

Error	Usual cause
`#N/A`	Lookup value not found
`#VALUE!`	Wrong data type (text in math)
`#REF!`	Reference to deleted cells
`#DIV/0!`	Division by zero / empty
`#NAME?`	Typo in a function name, or text without quotes
`#SPILL!`	Cells in the way of a dynamic array result
`#####`	Column too narrow

English ↔ Dutch Function Names #

English	Nederlands
`SUM` / `AVERAGE`	`SOM` / `GEMIDDELDE`
`COUNT` / `COUNTA`	`AANTAL` / `AANTALARG`
`IF` / `IFERROR`	`ALS` / `ALS.FOUT`
`SUMIF` / `COUNTIF`	`SOM.ALS` / `AANTAL.ALS`
`VLOOKUP` / `XLOOKUP`	`VERT.ZOEKEN` / `X.ZOEKEN`
`MATCH`	`VERGELIJKEN`
`ROUND`	`AFRONDEN`
`TODAY` / `NOW`	`VANDAAG` / `NU`
`UNIQUE` / `SORT`	`UNIEK` / `SORTEREN`
`LEFT` / `RIGHT` / `MID`	`LINKS` / `RECHTS` / `DEEL`
`LEN` / `TRIM` / `TEXT`	`LENGTE` / `SPATIES.WISSEN` / `TEKST`

Example: =IF(A1>10,"yes","no") becomes =ALS(A1>10;"ja";"nee").

Tips #

Turn data into a Table (Ctrl + T) first. Formulas, filters, formatting and charts then grow automatically with new rows.
PivotTable: select a cell in your data → Insert → PivotTable. Drag fields to Rows, Columns and Values.
Freeze headers: View → Freeze Panes → Freeze Top Row.
Data validation dropdown: Data → Data Validation → List.