a rate locked on both halves is one cell the whole page reads — and the multiply is linear, so the totals convert with everything else.
The revenue pack came in from the European desk and the committee reads dollars. House convention: the rate lives in ONE cell — typed in blue, boxed all round — and every converted number on the page reads that cell, so tomorrow’s rate is a one-cell edit. Build the dollar table off it, comma the figures and box the finished table. The rate, the currency and the table’s spot on the page all change every run.
Alt walks: tap Alt, release, then the letters in sequence — each key steps one ribbon menu. On a Mac, tap ⌥ and use the same letters (KeyTips, Excel 2024+).
Alt h f c⌥ h f c on macFont color
Font color: blue inputs, black formulas — the oldest convention in banking models, still enforced.
Alt h b a⌥ h b a on macAll borders
ALL borders — a line on every edge inside the block; the helper/assumption-cell convention.
F4⌘T · fn F4 on macCycle absolute / relative refs ($) while editing
Cycles $A$1 → A$1 → $A1 → A1 while editing — pin the row, the column, or both before filling across a grid.
Ctrl+R⌘R on macFill right from the cell to the left
Same as fill down, but across — one quarter’s formula becomes the whole year in two keystrokes.
Ctrl+D⌘D on macFill down from the cell above
Build the logic once in the top cell, select down, and stamp it — the standard way to fill a schedule.
Ctrl+1⌘1 on macOpen the Format Cells dialog
The master formatting dialog — number formats, alignment, borders in one place when a ribbon walk would take longer.
Alt h b s⌥ h b s on macOutside borders
OUTSIDE border (S for outSide) — ONE frame around the selection’s perimeter, interior clean. The finished-table look; A is the grid of lines, S is the frame.
the par-setting sequence, straight through:
B3 → 1.07 · alt h f c → blue · alt h b a · B13 =B6*B3 F4 · B13:F13 ctrl+r · B13:F16 ctrl+d · ctrl+1 n · A12:F16 alt h b s · ctrl+s