Insert Row Shortcut in Excel: Every Shortcut Key, Method, and Fix

You hit Ctrl+Shift+Plus and Excel inserts a row. Press it again, get another row. That single keystroke can shave thirty minutes off a long data-cleanup session — but only if you know the variants. The shortcut behaves differently on Windows and Mac. It does odd things when a table is involved. And it sometimes pops a tiny dialog instead of just inserting the row, which makes people think the shortcut is broken.

This guide walks through every Excel keyboard shortcut for inserting rows — the everyday ones, the multi-row tricks, the mouse-free workflow that finance teams swear by, and the small but maddening fixes when nothing happens at all. By the end you'll know which keys to press, when to use the ribbon instead, and how to handle rows and columns together when you need to restructure a whole sheet.

One quick note before we start. The phrase "insert row shortcut" usually means inserting a new blank row above the current one. Excel doesn't have a single shortcut to insert below a row, but there's a clean workaround that takes two keystrokes total. We'll cover both directions.

The fastest way to insert a single row in Excel for Windows is to select the row first, then press Ctrl + Shift + Plus. Click the row number on the left side to highlight the whole row. The row will turn light grey. Now press and hold Ctrl, then Shift, then tap the Plus key. Excel slides everything down and gives you a blank row in that position. The data that was on that row is now one row lower.

If you skip the row-selection step and just have a single cell active, the same keystroke opens the Insert dialog. The dialog asks whether you want to shift cells right, shift cells down, insert an entire row, or insert an entire column. Pick "Entire row" and click OK. That's three extra clicks compared to selecting the row number first, so the row-number-first method wins for speed.

On older keyboards the Plus key sits on the main keyboard above the equals sign. On full-size keyboards with a numeric keypad, you can use the keypad Plus instead — it's the same shortcut and often more comfortable for the right hand. Laptop keyboards without a numeric keypad behave normally as long as you hold Shift to get the actual plus character.

Mac users get a different but equally short shortcut. Highlight the row by clicking its number on the left edge of the sheet, then press Control + I. The "I" stands for Insert, which is a useful memory hook because the Windows version uses Plus and the Mac version uses a letter. The row inserts directly above the selected one.

Newer Mac builds of Excel also accept Command + Shift + Plus, which mirrors the Windows convention if you're switching between machines. Both shortcuts work in Excel for Microsoft 365, Excel 2021, and Excel 2019 on macOS. Earlier versions only support Control + I.

There's a quirk on the Mac side worth flagging. If you only have a single cell selected (not the entire row), Control + I opens the Format Cells dialog with the Italic option active rather than inserting a row. Always select the row number first. The same rule applies on Windows — selecting a single cell instead of a row makes Ctrl + Shift + Plus open the Insert pop-up instead of inserting silently.

Inserting multiple rows at once is where the shortcut really pays for itself. Suppose you need five blank rows between rows 10 and 11. Click the row number 11 to select it, then drag down to row 15 — or hold Shift and click row 15. Five rows are now highlighted. Press Ctrl + Shift + Plus on Windows or Control + I on Mac. Excel inserts five blank rows above row 11, pushing the existing content down by five.

The rule is simple: Excel inserts as many blank rows as you have selected. Highlight twelve rows, get twelve new rows. Highlight one, get one. This works the same way for tables, ranges, filtered data, and named regions, though filtered rows behave a little oddly — we'll address that in the troubleshooting section.

This is why power users prefer this shortcut over the right-click menu. With the menu, you have to select rows, right-click, hover "Insert", and click. With the shortcut, it's select-and-press. For someone restructuring a thousand-line export, that difference adds up to minutes saved per session.

The Alt-key sequence is the underappreciated method for users who don't want to leave the home row. Press Alt, then H, then I, then R. Each letter activates a ribbon menu — Home tab, Insert dropdown, Insert Sheet Rows. The whole sequence takes about a second once muscle memory kicks in. It works in every modern Excel version and never opens a dialog box.

This sequence has one big advantage over Ctrl + Shift + Plus: it always inserts a row even if your selection is just a single cell. Excel treats Alt + H + I + R as "insert a row at the active cell position" regardless of selection state. That makes it the safer shortcut to use when you're not sure what's selected.

Many corporate Excel users who work mostly in financial models use this method exclusively because it never opens the Insert dialog. Once you've typed Alt + H + I + R a few hundred times, your hands do it automatically and your eyes stay on the data. It's slower than Ctrl + Shift + Plus by about half a second, but it eliminates the dialog-box stumble entirely.

Inserting a row below your current row isn't a single keystroke in Excel, but the workaround is fast. Move down one row first, then insert. Press the Down Arrow to move to the row beneath the one you want to insert below, then press Shift + Spacebar to select that entire row, then press Ctrl + Shift + Plus. Excel inserts a blank row above the new selection — which is below your original position.

The Shift + Spacebar shortcut deserves its own callout. It selects the entire row of whatever cell is active, which is what makes the insert work cleanly. Ctrl + Spacebar does the same thing for columns. Memorizing both pairs makes you significantly faster at row and column manipulation without ever touching the mouse.

One alternative method works for inserting below in a Table (a real Excel Table, not just a range). Click the last cell of the last row in the table and press Tab. Excel adds a new row at the bottom of the table automatically with all the formatting and formulas preserved. Pressing Enter from any cell in the bottom row does the same thing.

Inserting blank rows between every existing row — for example, to add spacing between records before printing — is a common request that has no built-in shortcut. The trick is to use a helper column with sequential numbers, sort by that column, and the alternating numbers create gaps. Type 1, 2, 3 down column A next to your data, then copy that sequence and paste it below your data starting one row lower. Select both ranges and sort by the helper column ascending. The result interleaves your data with the blank pasted rows.

For users who frequently insert rows at regular intervals, VBA macros remain the cleanest solution. A three-line macro can insert a row every Nth position across thousands of rows in under a second. Most Excel power-user books include this snippet, and recording your own macro with the Macro Recorder will give you a working version even if you don't know VBA. Inserting multiple rows in Excel covers both the manual and macro approaches.

If you're working in a real Excel Table, none of this manual interleaving works well because the Table object preserves formatting and formulas in unexpected ways. Convert the table to a range first if you need to insert alternating blank rows — Table Design > Convert to Range — and you can convert it back when finished.

The "insert" shortcut works inside tables but with rules. When the active cell is inside an Excel Table and you press Ctrl + Shift + Plus, Excel inserts a row within the table rather than across the sheet, preserving table formatting, banded rows, header row references, and any structured formulas that depend on row counts. This is usually what you want, but it can confuse users who expect a sheet-wide row insert.

To insert a sheet-wide row that crosses through a table, click outside the table first and select the row number directly. Then the shortcut behaves the normal way and inserts an entire row that cuts through the table region. The table doesn't break — it just gets shorter by one because the new row is treated as outside table bounds.

This distinction matters for dashboards. If your sheet has a chart at the right edge and a data table at the left, inserting from outside the table moves both the table and the chart down. Inserting from inside the table moves only the table rows. Knowing which behavior you want before you press the keys saves you the undo dance.

When the shortcut "doesn't work," the cause is almost always one of four things. First, your selection state is wrong — you have a single cell active when you need a full row. Click the row number on the left margin to fix this. Second, the worksheet is protected.

Check the Review tab for a Protect Sheet indicator and unprotect with the password if you have one. Third, you're at the last row of the sheet (row 1,048,576). Excel can't insert a new row beyond the maximum, so it silently refuses. Delete some empty rows at the bottom to make space.

Fourth, and most commonly, the worksheet has data on the last row that you can't see — usually because of frozen panes, hidden rows, or accidental data far down the sheet. Press Ctrl + End to jump to the last cell with content. If that lands you on row 1,048,576, delete the stray data and the shortcut will work again. The Excel row limit article walks through this scenario in detail.

Two less common causes: an active filter that's hiding rows can make insert behavior look strange, because the inserted row may be hidden by the filter. Clear filters with Ctrl + Shift + L before inserting. And if you're using a non-English keyboard layout, the Plus key may live in a different position — try the numeric keypad Plus or the Alt + H + I + R sequence which is layout-agnostic.

For users coming from Google Sheets, the muscle memory mismatch trips a lot of people up. Google Sheets uses Ctrl + Alt + Shift + Plus to insert rows, while Excel uses Ctrl + Shift + Plus. Sheets also inserts below the current row by default while Excel inserts above. Both inconsistencies become invisible once you're committed to one platform, but the first week of switching is rough.

Inside Excel, you can also use the ribbon: Home tab > Insert dropdown > Insert Sheet Rows. The dropdown also includes Insert Sheet Columns, Insert Cells, and Insert Sheet, which is a quick way to do related operations without leaving the ribbon. If you customize the Quick Access Toolbar to include "Insert Sheet Rows," you can press Alt + 1 (or whatever position you put it) and skip the H + I + R sequence entirely.

Finally, if you find yourself inserting rows hundreds of times across many sheets, look at Power Query. Instead of restructuring data manually, you can transform the source data in Power Query and have the output sheet rebuild itself. It's a steeper learning curve but completely eliminates the need to insert rows by hand for repeated workflows.

One small detail that ships in newer Excel builds: the Insert dropdown on the Home tab now remembers your last action. If you used "Insert Sheet Rows" last time, the next click on the Insert button (not the dropdown arrow) repeats that action. So after using the menu once, you can click the Insert button repeatedly to keep adding rows without re-navigating. It's a small win, but it saves three clicks per row when you're doing batch work.

Working with frozen panes adds a small wrinkle. When you've frozen rows or columns and try to insert near the freeze line, the new row appears below the frozen pane rather than above it. This is intentional — frozen panes are display-only and don't affect the underlying row positions. If you need to insert above the freeze line, unfreeze first via View > Freeze Panes > Unfreeze, do the insert, and refreeze. The keyboard shortcut Alt + W + F + F toggles the freeze state quickly.

For users on Excel for the Web, the shortcuts work mostly the same but with a few differences. Ctrl + Shift + Plus works on Edge and Chrome. The Alt + H + I + R sequence works but is slower than the desktop version because the web ribbon is slightly heavier. Right-click insert behaves identically. If your browser intercepts Ctrl + Shift + Plus for its own zoom function, the web app falls back to opening a small Insert popup — choose "Entire row" and click Insert.

A common follow-up question: how do you copy a row and then insert it elsewhere as a new row, not just paste-over an existing one? The trick is "Insert Copied Cells." Copy the source row with Ctrl + C, then select the destination row by clicking its row number, then right-click and choose "Insert Copied Cells." Excel inserts the copied row at the destination, pushing existing rows down. The same workflow handles Insert Cut Cells if you want to move rather than duplicate.

There's no direct keyboard shortcut for Insert Copied Cells in standard Excel, but you can record a macro and assign it to a key combo if you do this often. Alt + H + I + E gets you partway through the ribbon path but ends at the Insert Cells dialog — you still have to choose "Shift cells down" and click OK. For one-off operations, the right-click method is faster than building a custom macro.

Lastly, watch out for merged cells. If the row you're trying to insert into contains merged cells that span multiple rows, Excel may refuse to insert or may insert in unexpected places. Unmerge first (Home > Merge & Center, click again to unmerge), do the insert, and re-merge if you need the layout back. Deleting rows in Excel has similar quirks with merged cells worth knowing about if you regularly work with merged layouts.