The Ultimate Excel & Google Sheets Formula Shortcuts Cheat Sheet

Speed and efficiency in spreadsheet modeling rely on minimizing mouse usage and leveraging keyboard shortcuts.

---

⚡ Master Shortcut Speed Table

Action / Capability	Windows Shortcut	Mac Shortcut	Description
Cycle Reference Locking ($)	F4	Cmd + T	Cycles $A$1 $\rightarrow$ A$1 $\rightarrow$ $A1 $\rightarrow$ A1
Edit Active Cell	F2	Enter / Ctrl + U	Enters cell formula edit mode
Toggle Show Formulas	`Ctrl + “	`Ctrl + “	Displays all formulas instead of values
AutoSum	Alt + =	Cmd + Shift + T	Instantly creates =SUM(...) across range
Format as Percentage	Ctrl + Shift + %	Ctrl + Shift + %	Formats as 0.0%
Format as Currency ($)	Ctrl + Shift + $	Ctrl + Shift + $	Formats as $#,##0.00
Format as Date	Ctrl + Shift + #	Ctrl + Shift + #	Formats as DD-MMM-YY
Insert Current Date	Ctrl + ;	Cmd + ;	Hardcodes today’s date timestamp
Insert Current Time	Ctrl + Shift + ;	Cmd + Shift + ;	Hardcodes current time timestamp
Fill Down from Above	Ctrl + D	Cmd + D	Copies formula from cell directly above
Fill Right from Left	Ctrl + R	Cmd + R	Copies formula from cell directly left
Open Name Manager	Ctrl + F3	Cmd + F3	Create and manage named ranges & Lambdas
Evaluate Formula Step-by-Step	Alt + M + V	—	Audits complex nested formulas step-by-step
Trace Precedents (Arrows)	Ctrl + [	Ctrl + [	Jumps directly to cells referenced by formula
Jump to Edge of Data Block	Ctrl + Arrow	Cmd + Arrow	Jumps to first/last populated row/column
Select to Edge of Data Block	Ctrl + Shift + Arrow	Cmd + Shift + Arrow	Selects continuous block of formula data

---

🎯 Pro Tip: The F4 Power Habit

When writing any lookup (XLOOKUP, VLOOKUP, INDEX/MATCH) or aggregation (SUMIFS, COUNTIFS), highlight the range with your cursor and press F4 once immediately. This guarantees your lookup tables remain locked with dollar signs ($A$2:$D$100) when dragging formulas across rows.