Excel like a finance pro.
The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.
Line break inside a cell
AltEnterEntry & fillStart a new line within one cell instead of jumping to the next row.
Difficulty
1What it does
Pressing Enter while typing moves to the next cell — so to put a second line *inside* the same cell (a multi-line address, a note, a wrapped header) you press Alt + Enter at the break point. It inserts a real line break and turns on wrap text for that cell.
2The shortcut
- 1Double-click the cell (or press
F2) to start editing. - 2Put the cursor where the new line should start.
- 3Press
Alt + Enter— the text drops to a new line in the same cell.
3Before → after
Press the shortcut to play it on a sample sheet.
Before — everything on one line
Pressing Enter here would jump to the next cell — Alt + Enter keeps the break inside this one.
4When you use it
- Write a two-line address in a single cell.
- Add a short note under a value without using another column.
- Make a tall, wrapped header read on two lines.
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.
Get my free report →