Wauvel

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.

← All tips & shortcuts

Insert or delete rows & columns

CtrlShift=Tables & data

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

Difficulty

Amateur
Practice file

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

CtrlShift=
  1. 1Select a full row (Shift + Space) or column (Ctrl + Space).
  2. 2Press Ctrl + Shift + = to insert a new row/column before it.
  3. 3Press Ctrl + - to delete the selected row/column.

3Before → after

Press the shortcut to play it on a sample sheet.

or press the keys for real

Before — a plain table, Feb row selected

A — MonthB — Revenue
1Jan80,000
2Feb88,000
3Mar96,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.

Get my free report →