Every Excel user hits the same wall eventually — you're buried in a spreadsheet, data flying in every direction, and you need to slip a new row in fast. Reaching for the mouse, right-clicking, hunting through menus — it kills your rhythm. That's why knowing the insert row hotkey in Excel is one of those small skills that pays off every single day. Whether you're building financial models, managing a project tracker, or cleaning up imported data, row insertion is something you'll do dozens of times in a single session.

There are two main approaches you'll want in your toolkit. The first is Ctrl+Shift++ (Ctrl + Shift + Plus sign). Press that combo from inside any cell and Excel opens the Insert dialog, where you choose "Entire row" and hit Enter. Quick — but still two steps involving a mouse-less interaction with a dialog box.

The second approach is slightly faster once you get the muscle memory: press Shift+Space first to select the entire current row, then hit Ctrl+Shift++. Because Excel knows you've already selected a whole row, it skips the dialog entirely and inserts immediately above. No dialog, no choosing, no confirmation. Just done.

Why does the distinction matter? If you're inserting a single row occasionally, either method works fine. But if you're building out a template or restructuring a dataset — inserting dozens of rows in a sitting — those saved clicks add up fast. The dialog approach adds roughly 0.5–1 second per insert. Across 50 row insertions in a session, you're losing close to a minute just to a dialog box. Combined with the F4 repeat trick (more on that below), you can insert row after row with almost no friction at all.

There's also a question of which version of Excel you're on. The Ctrl+Shift++ shortcut works identically in Excel 2013, 2016, 2019, 2021, and Microsoft 365. It works on both Windows and in the web version of Excel, though the web version occasionally has keyboard shortcut conflicts with browser shortcuts. The Mac version uses a different primary shortcut (Ctrl+I) due to how the Mac keyboard handles the plus key. All of these get their own sections below.

It's worth knowing these shortcuts work in tandem with everything else covered in the excel cheat sheet. Once you're fluent with row insertion, you'll naturally start combining it with column shortcuts, format-painting, and navigation keys to work at a genuinely different speed. Keyboard-first Excel use is a different experience from clicking around — you stay in a flow state instead of constantly breaking concentration to reach for the mouse.

One more thing before we get into the step-by-step: row insertion and deletion are mirror skills. If you're learning the insert shortcut, bookmark the keyboard shortcut to delete row in excel at the same time — you'll use both constantly, and they follow the same selection-first logic. Select the whole row, then apply the action. Once that pattern clicks, both shortcuts feel natural.

This guide covers every variation: inserting above, inserting below (with the simple workaround), inserting multiple rows at once, the legacy Alt sequence, the Mac shortcut, and how row insertion behaves inside Excel Tables. Let's go through each one.

Ready? Let's start with the core shortcuts and build from there — by the end you'll have the excel shortcut insert row pattern down cold, along with every useful variation.

Main Shortcut: Ctrl+Shift++

Let's walk through the Ctrl+Shift++ method in detail so you understand exactly what's happening and when the dialog appears — because sometimes the dialog is actually what you want.

Start by clicking any cell inside the row where you want to insert above. Say your data starts at row 5 and you need to add a blank row before it — click anywhere in row 5. Now press Ctrl+Shift++. The Insert dialog pops open with four radio buttons: "Shift cells right", "Shift cells down", "Entire row", "Entire column". Choose "Entire row" and hit Enter. Your new blank row slides in above row 5, and everything beneath it shifts down by one.

This dialog-based method has a practical advantage: you can insert an entire column just as easily by choosing "Entire column" instead. So Ctrl+Shift++ is really an all-purpose insert shortcut — not just for rows. When you're deep in keyboard-only mode and need to insert either a row or a column depending on context, this single shortcut handles both.

One gotcha: on some keyboard layouts, especially on laptops, the plus key requires Shift to type. That means Ctrl+Shift++ is effectively Ctrl + Shift + = since the + key is the shifted form of = on most keyboards. If the shortcut isn't working for you, try Ctrl+Shift+= (Ctrl + Shift + equals sign) — it's the same physical keystroke.

Two-Step: Shift+Space Then Ctrl+Shift++

Now here's the version that experienced Excel users almost always prefer. The trick is that if you've already selected an entire row, Excel skips the Insert dialog and inserts immediately. No choosing, no Enter — just done.

How to select the entire row with the keyboard: press Shift+Space from any cell in that row. You'll see the whole row highlight in blue. Now press Ctrl+Shift++ — a blank row appears above instantly. Start over, one more time if needed. That's it. Two keys, then two keys, and you're back to work.

A practical note: if you're in a cell that's inside a formula bar or if you're mid-edit, Shift+Space might type a space character instead of selecting the row. Press Escape first to exit edit mode, then use the shortcut. This catches a lot of people off guard the first few times.

This approach is covered in depth on the insert row shortcut excel reference page, which also covers some edge cases with merged cells and how insertion behaves differently when your selection spans merged areas. For a broader overview of everything you can do when adding rows from scratch — including using the ribbon Home tab and right-click context menu — the how to insert a row in excel guide walks through every method.

One common confusion: does the row go above or below? Always above. That's Excel's default behavior and it can't be changed via the keyboard shortcut — but there's a clean workaround covered in the above-vs-below section. Also worth knowing: if you have a data range that Excel recognizes as a Table (with its blue border and filter arrows), inserting a row inside the Table body works the same way, and Excel automatically extends the Table's formatting and structured references to the new row.

Inserting Above vs Below — and F4 to Repeat

Excel always inserts the new row above the selected row. There's no built-in "insert below" shortcut in any version of Excel — it's just not part of the design. But the workaround is dead simple: if you want a row below row 7, just select row 8 instead, then press Ctrl+Shift++ (or your Shift+Space combo). The new row lands above row 8 — which is exactly below row 7. Problem solved, no extra settings needed.

Now for the F4 trick, which is genuinely one of Excel's most underused features. F4 repeats your last action in Excel — whatever that action was. So: insert one row using any method, then press F4 once for each additional row you need. Click a different row, press F4, click another, press F4. You can insert rows one by one across an entire worksheet without ever re-invoking the full shortcut. This is especially handy when you need to insert rows at irregular intervals — every third row, or between specific data groups — rather than all in one block.

For inserting rows in a chunk — say, adding 5 blank rows in one spot — the multi-row selection method is faster: click 5 row numbers while holding Shift, then Ctrl+Shift++. But for scattered insertions across a large sheet, F4 is the right tool. You get the exact same result without selecting multiple non-contiguous rows (which Excel doesn't support for insertion anyway).

The same selection logic applies when inserting multiple rows at once, which is covered comprehensively on the excel insert multiple rows page. The key principle always holds: Excel inserts as many rows as you had selected, and they always land above the selection. Select 3 rows, get 3 new blank rows. Select 10 rows, get 10. There's no cap — you can technically select 1,000 rows and insert 1,000 blank rows in one keypress, though your data may not thank you.

Working inside an Excel Table (the structured kind with blue borders and auto-filter arrows, created via Ctrl+T)? The same shortcuts apply — and Excel automatically extends the Table's formatting, column headers, and structured reference formulas to the new rows. This is actually one of the best reasons to work in Tables rather than plain ranges when your data has any formula-driven columns.

One edge case worth knowing: if you have rows hidden in your spreadsheet and you insert near them, Excel inserts the new row in the correct position — it doesn't accidentally reveal hidden rows. The hidden rows stay hidden, and your insert goes where you intended.

Another practical scenario: you're working with a budget or schedule template and need to add rows between every existing row — essentially doubling the row count to add space. Instead of inserting rows one by one, try this approach: select all existing data rows, copy them to a blank area, then use a sort trick to interleave blank rows.

Or, for small datasets, select two rows at a time and insert two, then use F4 to repeat. For large-scale insertions like this, a quick VBA macro is often the cleanest solution — but for most everyday work, the manual shortcuts covered here are all you need.

Also worth noting: inserting rows doesn't affect conditional formatting rules — they expand to cover the new rows automatically if they were applied to a range or column. Same goes for data validation. If column B had a dropdown list validation applied to rows 2–100, inserting a row in that range extends the validation to the new row. You don't need to reapply anything.

Alt+I+R — The Legacy Shortcut

Before the ribbon existed, Excel used a full menu-driven interface reachable entirely by keyboard. Many of those old menu sequences still work today — Microsoft kept them for backward compatibility because so many longtime users had them memorized. The classic insert row sequence is Alt+I (opens the Insert menu) followed by R (Rows). Type them in sequence, not simultaneously: press and release Alt, press I, press R. You'll see a tooltip tooltip in the Name Box area showing the menu path as you type.

This works in Excel 2016, 2019, 2021, and Microsoft 365 on Windows. It skips any selection requirement — you just need to be somewhere in the row you want to insert above, and Alt+I+R does the job. It's a three-key sequence compared to two keys (Shift+Space then Ctrl+Shift++), so it's not the fastest option. But if you learned Excel before the ribbon era — or if you're supporting users who did — your fingers might already have this sequence baked in. Don't fight muscle memory. Use what works for you.

The right-click method is the mouse equivalent: right-click any row number in the grey left margin and choose "Insert" from the context menu. A new blank row appears above. This is slower than the keyboard methods but perfectly reliable — and it's the method most new Excel users discover first, before they learn the shortcuts. It's also useful in edge cases where keyboard shortcuts conflict with remote desktop software or browser extensions that intercept certain key combinations.

One more option worth knowing: you can insert an entire column with the same Ctrl+Shift++ shortcut by selecting an entire column first. Press Ctrl+Space to select the current column, then Ctrl+Shift++ to insert a new column to the left. This symmetry is deliberate — Ctrl+Shift++ is the unified "insert" shortcut for both rows and columns, with the selection determining what gets inserted. Learn one shortcut, get both.

Speaking of Excel shortcuts that build on each other — once you've got row insertion down, it's worth exploring what else lives in the keyboard layer. The Excel hotkeys reference covers navigation, selection, formatting, and formula shortcuts that compound with each other.

And if you're working with complex formulas alongside your row insertions, brushing up on countifs excel syntax is genuinely useful — COUNTIFS is one of those functions where inserting rows into a data table can shift which rows fall inside your range references. If your COUNTIFS uses fixed references like $A$2:$A$100, inserting rows beyond row 100 means those new rows aren't counted. Switch to Table references or dynamic ranges to avoid that issue entirely.

For column-width and indentation adjustments that often go hand-in-hand with inserting rows and restructuring layouts, check out how to indent in excel and how to change column width in excel — these are the kinds of formatting tweaks you'll reach for right after inserting new rows into a structured report or template.

One final practical tip: if you find yourself inserting rows frequently at the start of every work session — say, adding header rows or date separators to a daily log — consider recording a macro for it.

Excel's macro recorder captures the insert action, and you can assign it to a custom keyboard shortcut via the Macro dialog (Alt+F8). This is overkill for occasional inserts, but for workflows where you do the same structural edits repeatedly, a macro shortcut is faster than any built-in key combination. The keyboard skills covered here are the foundation — and they scale into automation when you need them to.