Excel Formula Shortcuts: F4, AutoSum, Edit Mode, and More
Speed up formula writing with F2, F4 absolute references, Alt+= AutoSum, Ctrl+` show formulas, and other keys every spreadsheet user needs.
Writing formulas is only part of spreadsheet speed. Editing references, filling ranges, auditing calculations, and summing columns from the keyboard keeps you inside the model instead of hunting through menus.
Edit and confirm formulas
F2— Edit the active cell. Arrow keys then move inside the formula instead of changing the selected cell.Enter— Confirm and move down.Ctrl + Enter— Confirm and stay on the same cell (also fills all selected cells with what you typed).Shift + Enter— Confirm and move up.Tab— Confirm and move right.
New users often press Enter when they meant to stay put. Ctrl + Enter is the fix for in-place confirmation and multi-cell entry.
Absolute references with F4
While editing a reference, press F4 to cycle: A2 → $A$2 → A$2 → $A2 → back to A2. This is essential for tax rates, FX rates, and lookup keys that must stay fixed when filled down.
Practice: type =B2*C1, place the cursor on C1, press F4 until it reads $C$1, then fill down. That single habit prevents a whole class of broken models.
AutoSum and function tools
Alt + =— AutoSum for a contiguous numeric block.Shift + F3— Insert Function dialog when you need help with arguments.Ctrl + `— Toggle formula view across the sheet.
AutoSum is perfect for quick totals during exploration. Formula view is perfect before you send a workbook to someone else — you catch hardcoded numbers posing as calculations.
Fill and copy formula patterns
Ctrl + D— Fill down from the top cell of the selection.Ctrl + R— Fill right from the leftmost cell.Ctrl + C/Ctrl + V— Copy formulas to non-adjacent areas.- Paste Special Values when you need to freeze results.
Combine selection shortcuts with Fill Down: jump to the column edge with Ctrl + Shift + Down, then Ctrl + D. That pairing is a staple of analyst workflows.
Drill these in Formulas & Functions practice and review examples in Scenarios. For a broader reference, keep the cheat sheet open while you build your first models of the week.
Practice what you learned
Open a free interactive mode and turn these shortcuts into muscle memory.