Keyboard Shortcuts Excel Formulas and Functions

Excel formulas do the math, lookups, and logic that make spreadsheets powerful. Keyboard shortcuts for entering, editing, and auditing formulas speed up data work considerably — especially when building complex models or debugging errors across many cells.

Entering Formulas

  = (equals sign)       → Start a formula in any cell
  Enter                 → Confirm formula and move down
  Tab                   → Confirm formula and move right
  Ctrl + Shift + Enter  → Enter as an ARRAY formula (older Excel)
  Esc                   → Cancel formula entry without saving

AutoSum — Alt + = (Equals)

AutoSum is the fastest way to sum a column or row of numbers without typing the SUM function manually.

  Select the cell below a column of numbers
  Press Alt + =
  → Excel writes =SUM(A1:A10) automatically
  → Press Enter to confirm

  SELECT A RANGE FIRST, THEN Alt + =:
  Select B2:B11 (a range that includes the numbers + one empty cell below)
  → Alt + = → SUM applied instantly
  → Works for rows too: select D2:G2 and one empty cell to the right

  EXAMPLE:
  A1: 100
  A2: 250
  A3: 175
  A4: (empty — cursor here)
  Press Alt + =
  A4: =SUM(A1:A3)   → shows 525

Function Autocomplete

  Type = then start typing a function name:
  =SU → Excel shows a dropdown: SUM, SUMIF, SUMIFS, SUMPRODUCT...
  Down Arrow → select a function
  Tab → complete the function name
  Then fill in the arguments

  AFTER OPENING PARENTHESIS:
  Ctrl + Shift + A  → Insert the function's argument names as placeholders
  Example: =VLOOKUP( → Ctrl + Shift + A
  → =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Show and Hide Formulas

  Ctrl + ` (grave accent / backtick)  → Toggle formula view

  NORMAL VIEW:           FORMULA VIEW (after Ctrl + `):
  A1: 525                A1: =SUM(A1:A10)
  B1: 1050               B1: =A1*2
  C1: TRUE               C1: =A1>500

  Formula view shows the actual formula in every cell
  instead of the calculated result.
  Toggle back with Ctrl + ` again.

Trace Precedents and Dependents

These commands draw arrows showing which cells feed into a formula (precedents) and which cells use a formula's result (dependents).

  Ctrl + ] (right bracket)   → Select direct precedents
  Ctrl + [ (left bracket)    → Select direct dependents
  (These navigate to the referenced cells)

  VIA RIBBON:
  Alt + M → P → Trace Precedents (draws blue arrows)
  Alt + M → D → Trace Dependents (draws blue arrows)
  Alt + M → A → Remove Arrows (clears all arrows)

  USE CASE: A formula returns an unexpected value.
  Trace Precedents to see exactly which cells feed into it.

F4 — Absolute vs Relative Cell References

  WHILE TYPING OR EDITING A FORMULA:
  Click or type a cell reference → press F4 to cycle through:

  A1        → relative (moves when copied)
  $A$1      → absolute row and column (never moves)
  A$1       → relative column, absolute row
  $A1       → absolute column, relative row

  EXAMPLE:
  You want to always refer to B1 as a tax rate, no matter where the
  formula is copied. Click B1 in the formula → press F4 → becomes $B$1.

Evaluate a Formula Step by Step

  Select a cell with a complex formula
  Alt + M → V → Evaluate Formula
  (or Formulas tab → Evaluate Formula)

  EVALUATE FORMULA DIALOG:
  Shows the formula with each part highlighted
  Click "Evaluate" → replaces one piece with its calculated value
  Step through until you find the error or unexpected result

  EXAMPLE:
  =IF(VLOOKUP(A2,Table1,2,0)>100,"High","Low")
  Step 1: VLOOKUP(A2,Table1,2,0) → 75
  Step 2: 75>100 → FALSE
  Step 3: IF(FALSE,"High","Low") → "Low"

Common Formula Shortcuts

  Alt + =               → AutoSum
  Ctrl + `              → Toggle formula/value view
  F4                    → Toggle absolute/relative reference
  Ctrl + Shift + Enter  → Array formula (legacy)
  F9 (in formula bar)   → Calculate the selected part of a formula
                          (shows the result without confirming)
  Ctrl + A              → After function name, open function arguments dialog
  Shift + F3            → Open Insert Function dialog (browse all functions)

Quick Reference

  ACTION                        SHORTCUT
  ──────────────────────────────────────────────────────
  Start formula                 = (equals key)
  AutoSum                       Alt + =
  Toggle formula view           Ctrl + `
  Toggle absolute reference     F4
  Open function library         Shift + F3
  Insert function arguments     Ctrl + Shift + A
  Evaluate formula              Alt + M → V
  Trace precedents              Alt + M → P
  Remove audit arrows           Alt + M → A
  Calculate selected part       F9 (in formula bar)

Alt + = for AutoSum and Ctrl + ` for formula view are the two Excel formula shortcuts to learn immediately. AutoSum eliminates manual SUM typing for the most common calculation in any spreadsheet. Formula view is the fastest way to audit an entire sheet for errors — it reveals every formula at once so you can spot mistakes without clicking into individual cells one by one.