Excel like a finance pro.
Format as Table
CtrlTTables & dataTurn a range into a structured Table that grows and reads in plain English.
Difficulty
1What it does
Ctrl + T converts a range into an Excel Table: banded rows, filter dropdowns, and structured references so formulas read as Table[Amount] instead of C2:C500. New rows join automatically, and formulas and charts expand to include them.
2The shortcut
- 1Click anywhere in your data range.
- 2Press
Ctrl + T. - 3Confirm the range and 'My table has headers', then
Enter.
3Before → after
Press the shortcut to play it on a sample sheet.
Before — a plain range
| Account | Amount |
| Revenue | 80,000 |
| COGS | 32,000 |
| Opex | 28,000 |
Total formula
4When you use it
- Make a range that auto-expands as you add rows.
- Reference columns by name instead of by cell range.
- Get instant filtering and a banded, readable layout.
5Related functions
- SUBTOTAL — see its own page, with a live demo.
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.