Wauvel

Excel like a finance pro.

Tips & shortcuts

Each one has its own page — what it does, the keystrokes, and a before/after you can play.

Entry & fill

Flash FillCtrlE

Type one example and Excel fills the rest of the column by pattern.

See it work → Practice file
AutoSumAlt=

Total the cells above or to the left in a single keystroke.

See it work → Practice file
Fill down / rightCtrlD

Copy the cell above (or to the left) down a whole selection.

See it work → Practice file
Insert today's dateCtrl;

Stamp a static date that won't change tomorrow.

See it work → Practice file
Fill a whole selection at onceCtrlEnter

Type once, then drop the same entry into every selected cell in one press.

See it work → Practice file
Line break inside a cellAltEnter

Start a new line within one cell instead of jumping to the next row.

See it work → Practice file

Editing & references

Paste values onlyCtrlAltV

Drop the formulas and formatting — keep just the numbers.

See it work → Practice file
Toggle absolute referencesF4

Cycle a reference through A1 → $A$1 → A$1 → $A1 while editing.

See it work → Practice file
Named ranges

Name a cell or range so formulas read like English.

See it work → Practice file
Jump to the edge of your dataCtrlArrow

Leap to the end of a column or row — and add Shift to select everything on the way.

See it work → Practice file
Edit the active cell in placeF2

Jump into edit mode and see, in colour, exactly which cells a formula uses.

See it work → Practice file
Evaluate part of a formulaF9

Select a piece of a formula and see the value it produces — the best debugging trick.

See it work → Practice file
Show all formulasCtrl`

Flip the whole sheet between showing results and showing the formulas behind them.

See it work → Practice file
Jump to the start or the endCtrlHome

Leap to cell A1, or to the last used cell, from anywhere in the sheet.

See it work → Practice file
Switch between worksheetsCtrlPage Down

Move to the next or previous tab without touching the mouse.

See it work → Practice file
Undo and redoCtrlZ

Step backward through your changes — and forward again if you went too far.

See it work → Practice file

Formatting

Format Cells dialogCtrl1

Open the full formatting dialog — number formats, borders, alignment — in one press.

See it work → Practice file
Instant number formatsCtrlShift$

One chord each for currency, percent, or comma style — no ribbon trip.

See it work → Practice file

Tables & data

Format as TableCtrlT

Turn a range into a structured Table that grows and reads in plain English.

See it work → Practice file
Toggle filtersCtrlShiftL

Add or remove the filter dropdowns on your header row.

See it work → Practice file
Go To SpecialCtrlG

Select only the blanks, formulas, or constants in one move.

See it work → Practice file
Insert or delete rows & columnsCtrlShift=

Add or remove whole rows and columns from the keyboard, no right-click needed.

See it work → Practice file

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.