Excel Cheat Sheet
Complete reference guide for Excel shortcuts, formulas, and essential tips. Bookmark this page for quick access during your Excel work.
🔥 Essential Keyboard Shortcuts
Navigation & Selection
Go to cell A1Ctrl + Home
Go to last used cellCtrl + End
Jump to edge of dataCtrl + Arrow
Select to edge of dataCtrl + Shift + Arrow
Select entire columnCtrl + Space
Select entire rowShift + Space
Select all cellsCtrl + A
Go to specific cellCtrl + G
Editing & Data Entry
Edit active cellF2
CopyCtrl + C
PasteCtrl + V
CutCtrl + X
UndoCtrl + Z
RedoCtrl + Y
Fill downCtrl + D
Fill rightCtrl + R
Clear cell contentsDelete
New line in cellAlt + Enter
Formatting
BoldCtrl + B
ItalicCtrl + I
UnderlineCtrl + U
Format Cells dialogCtrl + 1
Currency formatCtrl + Shift + $
Percentage formatCtrl + Shift + %
Date formatCtrl + Shift + #
Apply borderCtrl + Shift + &
Formulas & Functions
Start formula=
AutoSumAlt + =
Toggle absolute referenceF4
Insert functionShift + F3
Array formulaCtrl + Shift + Enter
Calculate formulasF9
Show formulasCtrl + `
Name ManagerCtrl + F3
📊 Essential Formulas Reference
Basic Math
SUM
=SUM(A1:A10)Add numbers in a range
AVERAGE
=AVERAGE(A1:A10)Calculate average
COUNT
=COUNT(A1:A10)Count numbers
MAX/MIN
=MAX(A1:A10)Find highest/lowest value
Text Functions
CONCATENATE
=CONCATENATE(A1,B1)Join text strings
LEFT/RIGHT
=LEFT(A1,3)Extract characters from left/right
LEN
=LEN(A1)Count characters in text
UPPER/LOWER
=UPPER(A1)Change text case
Lookup Functions
VLOOKUP
=VLOOKUP(A1,B:D,2,FALSE)Vertical lookup
XLOOKUP
=XLOOKUP(A1,B:B,C:C)Modern lookup function
INDEX
=INDEX(A:A,5)Return value by position
MATCH
=MATCH(A1,B:B,0)Find position of value
Logical Functions
IF
=IF(A1>10,"High","Low")Conditional logic
AND/OR
=IF(AND(A1>5,B1<10),"Yes","No")Multiple conditions
IFERROR
=IFERROR(A1/B1,"Error")Handle errors gracefully
ISBLANK
=ISBLANK(A1)Check if cell is empty
💡 Quick Tips & Tricks
⚡Speed Up Data Entry
- •Use Ctrl+Enter to fill multiple selected cells with the same value
- •Double-click fill handle to auto-fill down to end of adjacent data
- •Use Ctrl+; to insert current date, Ctrl+Shift+; for current time
🎯Formula Best Practices
- •Always use absolute references ($A$1) for lookup tables
- •Use named ranges for better formula readability
- •Break complex formulas into smaller, manageable parts
🔍Data Analysis Tips
- •Convert data to Tables (Ctrl+T) for better functionality
- •Use conditional formatting to highlight important data
- •Apply filters to quickly find specific information
💡Productivity Hacks
- •Freeze panes (View → Freeze Panes) to keep headers visible
- •Use Find & Replace (Ctrl+H) for bulk data changes
- •Create custom number formats for special display needs
📚 Function Categories
Math & Trig
69 functionsText
30 functionsDate & Time
24 functionsLookup & Reference
19 functionsStatistical
109 functionsFinancial
55 functionsLogical
9 functionsInformation
18 functionsDatabase
12 functions📥 Save This Reference
Keep this cheat sheet handy for quick reference during your Excel work.