Wauvel

Excel like a finance pro.

← All tips & shortcuts

Format by meaning instead of by hand

AltH, JFormatting

Define input, formula and link once — then restyle the whole model with one edit.

Difficulty

Good
Practice file

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

AltH, J
  1. 1Alt + H, J opens the Styles gallery. **New Cell Style** to define one.
  2. 2Name it for its meaning — Input, Formula, Link — and set the format.
  3. 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.

or press the keys for real

Blue = typed input · green = link · black = formula

1Price42.00input
2Volume12,000input
3Revenue=B1*B2formula
4Prior year=PY!C7link

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.