Excel like a finance pro.
Insert or delete rows & columns
CtrlShift=Tables & dataAdd or remove whole rows and columns from the keyboard, no right-click needed.
Difficulty
1What it does
Select a whole row or column (with Shift + Space for a row, Ctrl + Space for a column), then Ctrl + Shift + = inserts a new one and Ctrl + - deletes the selected one. Do it on a cell rather than a full row and Excel asks which way to shift — but selecting the entire row or column first makes it one clean keystroke.
2The shortcut
- 1Select a full row (
Shift + Space) or column (Ctrl + Space). - 2Press
Ctrl + Shift + =to insert a new row/column before it. - 3Press
Ctrl + -to delete the selected row/column.
3Before → after
Press the shortcut to play it on a sample sheet.
Before — a plain table, Feb row selected
| A — Month | B — Revenue | |
|---|---|---|
| 1 | Jan | 80,000 |
| 2 | Feb | 88,000 |
| 3 | Mar | 96,000 |
Select a whole row first (Shift + Space), then Ctrl + Shift + = inserts above it — no right-click.
4When you use it
- Insert a row mid-table without reaching for the mouse.
- Delete a stray column from an export in one keystroke.
- Add several rows fast by selecting several first.
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.