In Excel: select a full row header, then press Ctrl+Shift++ on Windows (⌘+Shift++ on Mac) to insert a blank row above — no mouse required.
Keyboard shortcut: Insert Row
| Platform | Shortcut |
|---|---|
| Windows | Ctrl+Shift++ |
| Mac | ⌘+Shift++ |
Select a full row header first, then press the combo.
Click the row number on the left edge to select the entire row above which you want to insert.
On Windows press Ctrl+Shift++; on Mac press ⌘+Shift++.
Excel inserts a blank row above the selected row immediately.
To insert multiple rows, select that many row headers first, then press the combo once.
Undo with Ctrl+Z (⌘+Z on Mac) if the insertion was in the wrong place.
What this does
The Insert Row shortcut Ctrl+Shift++ inserts a blank row above the selected row instantly. Select the row header first (click the row number on the left) so Excel knows exactly where to insert; then press Ctrl+Shift++ and the new row appears above. On Mac the same action uses ⌘+Shift++. Knowing Ctrl+Shift++ for Insert Row eliminates the right-click → Insert detour and keeps your hands on the keyboard mid-data-entry. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “excel insert row below shortcut” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected rows shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.
A worked example
You are building a list with 200 items and need a blank row between items 47 and 48. Click the "48" row header to select row 48, then press Ctrl+Shift++. A new blank row slides in above row 48 and everything below shifts down. On Mac press ⌘+Shift++ for the same result. To insert three rows at once, drag to select rows 48–50 before pressing the combo. Use Ctrl+Shift++ for Insert Row every time you need to add structure to a table without reaching for the mouse. It is one of the highest-frequency Excel shortcuts because inserting rows is a near-constant task when building or editing data tables. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Here is the takeaway for “excel insert row below shortcut”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Selecting only a cell instead of the full row header — Excel may open the Insert dialog asking what to shift, which slows you down.
- Pressing the wrong combo: Ctrl++ (without Shift) also opens the Insert dialog rather than inserting a row directly when only a cell is selected.
- On Mac confusing ⌘+Shift++ with Ctrl+Shift++ — the Mac version requires ⌘, not Ctrl.
Frequently asked questions
Is there a Mac shortcut to insert a row?
Yes — select the row header, then press ⌘+Shift++. It is the Mac equivalent of the Windows Ctrl+Shift++ and inserts a blank row above instantly.
What if Ctrl+Shift++ doesn't insert a row?
Make sure you have a full row selected (click the row number, not just a cell). If only a cell is selected, Ctrl+Shift++ opens the Insert dialog instead of inserting directly. Press Escape and click the row number first.
Can I insert multiple rows with the shortcut?
Yes — select as many row headers as you want to insert (e.g. drag across row numbers 5–8 to add four rows), then press Ctrl+Shift++ once and Excel inserts that many blank rows.