Shortcut Key for Inserting a Row in Excel (Windows & Mac)
You are typing away in Excel. Then you realize you forgot a row. So you grab your mouse, right-click, scroll down, click “Insert,” and wait for the menu to catch up. It feels slow. It breaks your flow. And if you do this ten times a day, it adds up to real lost time.
After years of building spreadsheets for work and side projects, I stopped doing that. I learned one simple shortcut key for inserting a row in Excel, and I never went back to the mouse. This article covers that same shortcut, plus a few extra software eggs and productivity tricks that most articles skip, like what to do when the shortcut stops working and how it behaves differently inside Excel Tables.
The Main Shortcut: Ctrl + Shift + Plus
On Windows, the shortcut key for inserting a row in Excel is simple: Ctrl + Shift + Plus (+). This one combo inserts a new blank row right above the row you have selected.
Here is how to use it, step by step:
- Click on any cell in the row where you want the new row to appear.
- Press Shift + Spacebar. This selects the entire row.
- Press Ctrl + Shift + Plus (+) at the same time.
- A new, blank row appears above your selected row. Everything below moves down to make room for it.
Your data stays safe. Nothing gets deleted or overwritten. Excel simply pushes everything down to make room.
Pro tip: If you skip step 2 and only select a single cell instead of the whole row, Excel will not insert a row right away. Instead, it opens a small dialog box asking whether you want to shift cells right, shift cells down, or insert an entire row or column. Always select the full row first to skip that extra step.
Two Keyboards, Two Slightly Different Shortcuts
Here is something a lot of guides get confusing: there are two versions of this shortcut, and which one you use depends on your keyboard.
- Full keyboard with a number pad: Press Ctrl and the Plus (+) key on the number pad. You do not need Shift here, because the numpad plus key does not need a shift press to type a plus sign.
- Laptop keyboard with no number pad: Press Ctrl + Shift + Plus using the main keyboard, since the plus sign shares a key with the equals sign, and Shift is needed to type it.
If your shortcut is not working, this is often the reason, which is why mastering standard microsoft excel shortcuts based on your specific keyboard layout saves so much confusion.
How to Insert Multiple Rows at Once
Need five new rows instead of one? You do not have to repeat the shortcut five times. Excel lets you insert several rows in a single move.
- Click and drag across the row numbers on the left side of the screen to select several rows. For example, select rows 5 through 9 to prepare for five new rows.
- Press Ctrl + Shift + Plus.
- Excel inserts that same number of blank rows above your selection.
This trick saves even more time than the single-row shortcut, especially when you are building large reports or budgets.
The Shortcut Key for Inserting a Row in Excel on Mac
Mac users get a similar shortcut, but with the Command key instead of Ctrl.
- Modern Excel for Mac (2016 and later): Select the row, then press Command + Shift + Plus.
- Older versions of Excel for Mac: Select the row, then press Control + I. Note that in newer versions, Control + I now switches text to italics instead, so this only works on older releases.
If your Mac shortcut suddenly stops working, check whether a recent Excel update changed your keyboard settings, or try restarting Excel first.
An Alternative: The Alt Key Shortcut
If you would rather use letter keys than symbols, Excel offers a second path using the Alt key. This works through what is called the ribbon shortcut system.
- Select the row where you want the new row to appear above.
- Press Alt, then H, then I, then R, pressing each key one after another rather than all at once.
- Excel inserts a new row instantly.
Some longtime Excel users still rely on the older Alt, I, R combination from Excel’s classic menu days. Microsoft kept this legacy shortcut working even after switching to the ribbon layout, so it still functions in current versions.
Why the Shortcut Might Not Be Working
Most articles stop at the shortcut itself and never explain why it sometimes fails. Here are the most common reasons, based on real troubleshooting:
- You selected a cell, not a row. This triggers the Insert dialog box instead of a direct insert. Select the whole row with Shift + Spacebar first.
- You used the wrong plus key. Numpad Plus needs only Ctrl. Main keyboard Plus needs Ctrl + Shift.
- The worksheet is protected. If your sheet has protection turned on, row insertion may be blocked entirely, no matter what shortcut you use.
- You are inside a filtered or grouped range. Filters and grouped rows can sometimes change how Excel inserts new rows, so double-check your view first.
Inserting a Row Inside an Excel Table Works Differently
This part gets left out of most guides, but it matters a lot if you use Excel Tables (the formatted ranges you create with Ctrl + T). Inside a real Excel Table, you do not need to select the entire row first. Just click any single cell in the table, press Ctrl + Shift + Plus, and Excel adds a new table row above it right away, no dialog box, no extra clicks. The table’s formatting and formulas carry over into the new row on their own, which does not always happen in a normal, non-table range.
Quick Reference: Every Insert Row Shortcut in One Place
- Windows, numpad keyboard: Ctrl + Plus
- Windows, laptop keyboard: Ctrl + Shift + Plus
- Windows, ribbon method: Alt, H, I, R
- Windows, legacy method: Alt, I, R
- Mac, modern versions: Command + Shift + Plus
- Mac, older versions: Control + I
- Select entire row first: Shift + Spacebar
Frequently Asked Questions
What is the fastest shortcut key for inserting a row in Excel?
On Windows, the fastest method is selecting the row with Shift + Spacebar, then pressing Ctrl + Shift + Plus. On Mac, use Command + Shift + Plus after selecting the row.
Why does pressing Ctrl + Shift + Plus open a dialog box instead of inserting a row?
This happens when only a single cell is selected instead of the full row. Select the entire row first, and the shortcut will insert directly without any pop-up.
Can I insert more than one row at a time using a shortcut?
Yes. Select as many rows as you want to add, then press Ctrl + Shift + Plus. Excel will insert that exact number of new rows above your selection.
Does the shortcut work the same way inside an Excel Table?
Not exactly. Inside a Table, you only need to select one cell, not the whole row, and Excel will still insert a new row correctly while keeping your formatting and formulas.
Why is my insert row shortcut not working at all?
Check three things first: whether the worksheet is protected, whether you are using the correct plus key for your keyboard type, and whether you have a full row selected rather than a single cell.
Once this shortcut becomes a habit, you will notice how much smoother your Excel work feels. No more hunting through right-click menus, no more breaking your focus to grab the mouse. Just select, press, and keep moving.
