Excel like a finance pro.
← The libraryPractice · 2 questions →
Rows & columns shortcut
Insert cells, rows, or columns
Ctrl + Shift + + on Windows, ⌘ + Shift + + on Mac.
Very commonDifficulty 950 · Capable
When to use it
Inserts cells, rows, or columns. With whole rows or columns selected it inserts them directly; otherwise a dialog asks which way to shift.
The shape of it
- Windows
Ctrl + Shift + +
- Mac
⌘ + Shift + +
Worked examples
Insert a row
Shift + Space, then Ctrl + Shift + + → A row inserted above
Without the mouse.
Insert a column
Ctrl + Space, then Ctrl + Shift + + → A column inserted to the left
Same for columns.
Several rows
Select three rows, Ctrl + Shift + + → Three rows inserted
Insert several at once.
Worth knowing
- The + is on the = key, so this is Ctrl + Shift + =.
- Inside a Table, a Table row is inserted.
- F4 repeats the insert.
Where it goes wrong
- With a cell selected it opens a dialog; select the whole row or column to skip it.
- Inserting rows breaks ranges that were sized exactly, unless they are Tables.
Related
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.