📊 Excel Shortcuts

Cheat Sheets

Formulas and shortcuts for daily spreadsheet work — every row copyable

Formulas and shortcuts for daily spreadsheet work

Ctrl+Shift+Ltoggle filters

Ctrl+Tconvert range to table

Alt+= auto-sum

F2edit cell

F4lock references ($A$1) / repeat last action

Ctrl+Arrow keysjump to edge of data

Ctrl+Shift+Arrowselect to edge of data

SUM(range)add numbers

AVERAGE(range)mean value

IF(test, yes, no)conditional value

VLOOKUP(v, table, col, FALSE)find in first column

XLOOKUP(v, find, return)modern lookup, any direction

INDEX(range, n)nth item of a range

MATCH(v, range, 0)position of a value

COUNT(range)count numbers

COUNTIF(range, criteria)conditional count

SUMIF(range, crit, sumRange)conditional sum

CONCAT(a, b)join text

LEFT(text, n)first n characters

TRIM(text)strip extra spaces

TODAY()current date

Ctrl+;insert today's date

Ctrl+1format cells dialog

Alt+Enternew line inside a cell

One of 1095+ instant kits on SlashAI — free forever, nothing uploaded, no account.