Excel like a finance pro.
Format by meaning instead of by hand
AltH, JFormattingDefine input, formula and link once — then restyle the whole model with one edit.
Difficulty
1What it does
Professional models colour cells by what they ARE, not by how they look: blue for a typed input, black for a formula, green for a link to another sheet. That convention is decades old and it exists so anyone opening your file knows instantly which cells they may touch. Cell Styles is how you apply it without hand-formatting — and the real payoff comes later, because editing the style itself updates every cell using it at once. Hand-formatted cells can only be changed one at a time, forever.
2The shortcut
- 1
Alt + H,Jopens the Styles gallery. **New Cell Style** to define one. - 2Name it for its meaning —
Input,Formula,Link— and set the format. - 3To restyle everything later: right-click the style → **Modify**. Every cell using it updates.
3Before → after
Press the shortcut to play it on a sample sheet.
Blue = typed input · green = link · black = formula
| 1 | Price | 42.00 | input |
| 2 | Volume | 12,000 | input |
| 3 | Revenue | =B1*B2 | formula |
| 4 | Prior year | =PY!C7 | link |
Colour by what a cell IS, not how it looks. The convention is decades old and exists so anyone opening the file knows which cells they may touch.
4When you use it
- Mark inputs blue so nobody types over a calculation.
- Change a model's whole look by editing three styles rather than a thousand cells.
- Hand over a file whose colour coding explains itself.
Want these moves already done for you? Wauvel's free tools download as branded, formula-driven Excel models — Tables, named ranges, and all.
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.