Row Insert Shortcut Key in Excel: Add Rows in Seconds
Adding rows one at a time with your mouse gets old fast, especially when you are working with a big sheet. There is a faster way. Excel already includes a row insert shortcut key that adds a new row in less than a second. Once you know it, you will not want to right-click your way through a spreadsheet again.
This article gives you the exact keys to press on Windows and Mac, shows you how to add many rows at once, explains why the shortcut sometimes fails, and shares a few extra tricks to keep your sheet clean after you insert new rows.
The Row Insert Shortcut Key in Excel (Quick Answer)
- Windows: Select the row, then press Ctrl + Shift + Plus (+)
- Mac: Select the row, then press Command + Shift + Plus (+)
- On a full keyboard with a numpad, you can skip Shift and press Ctrl + Plus once the entire row is already selected.
That is the whole shortcut key to insert a row in Excel. The steps below show how to use it the right way, so it works every time.
How to Use the Row Insert Shortcut on Windows
- Click the row number on the left side of the sheet to select the whole row, or click any cell in that row and press Shift + Space.
- Hold down Ctrl and Shift.
- Press the Plus (+) key on the top row of your keyboard.
- A new blank row appears above the row you selected.
If your keyboard has a full numpad and you already selected the entire row, you only need Ctrl and the + key on the numpad. You can skip Shift in that case.
How to Use the Row Insert Shortcut on Mac
Mac keyboards work almost the same way, with one small difference.
- Click the row number to select the full row.
- Hold Command (⌘) and Shift.
- Press Plus (+).
- Excel drops in a new row right above your selection.
Older versions of Excel for Mac used Control + I instead. If you are on an older build and Command + Shift + Plus does nothing, try Control + I. Most Mac users on Excel 365 today only need Command + Shift + Plus.
How to Insert Multiple Rows at Once
You do not need to repeat the shortcut key over and over. Select as many rows as you want to add first, then press the shortcut one time.
For example, if you need five new rows, click and drag across five row numbers to select them, then press Ctrl + Shift + Plus on Windows or Command + Shift + Plus on Mac. Excel adds five blank rows above your selection in one move.
You can also select rows that are not next to each other. Hold Ctrl on Windows or Command on Mac while clicking each row number, then use the shortcut. Excel inserts a blank row above every row you picked.
Why the Shortcut Might Not Work
A few small things cause this shortcut key to fail. Below are the most common reasons and how to fix each one.
- You selected a cell, not a row. If only a cell is active, pressing Ctrl + Shift + Plus opens the Insert dialog box instead of adding a row right away. Pick “Entire Row” in that box and click OK, or select the full row first next time.
- You are inside a Table. If your data is set up as an Excel Table, the shortcut still works, but it only adds a row inside the table, not across the whole sheet.
- You used the wrong plus key. On a laptop without a numpad, use the Plus key that sits with the Equals sign near the top of the keyboard, along with Shift. The numpad Plus key does not need Shift, but the top-row Plus key does.
- Nothing happens at all. Check that your row is truly selected. The whole row should be highlighted in gray or blue, not just one cell.
Other Ways to Insert Rows Without a Mouse
The Plus key shortcut is the fastest, but Excel gives you a backup option too. Press Alt, then I, then R, one after another, not at the same time. This opens the classic menu path and inserts a row above your cursor. It works well if your keyboard layout does not respond to the Plus key shortcut for some reason.
If you use Excel often, it helps to know a few more Excel keyboard shortcuts for copying, moving, and formatting cells. Learning a handful of these can cut your work time by half.
Keep Your Formulas and Formatting Correct After You Insert a Row
New rows can shift your formulas around. Excel usually updates cell references for you, but it is worth checking your totals after a big insert, especially in sheets with a subtraction formula in Excel or other math that depends on exact row numbers.
If you build reports that track growth over time, such as a compound growth rate formula, inserting rows in the middle of your data can break a chart range. Always check your charts and formulas after adding new rows to make sure nothing points to the wrong cell.
For repeat tasks, like adding the same block of rows every week, you can also record a short macro. If you are new to that side of Excel, our post on Excel VBA macros shows how to save time on tasks you do again and again.
Undo a Row Insert in One Step
Added a row in the wrong place? Press Ctrl + Z on Windows or Command + Z on Mac right away. Excel removes the new row and puts your sheet back the way it was. This works even if you inserted many rows at once, as long as you undo before making any other change.
Frequently Asked Questions
What is the row insert shortcut key in Excel?
On Windows, press Ctrl + Shift + Plus after selecting a row. On Mac, press Command + Shift + Plus. Both add a new blank row right above your selection.
Can I insert a row without selecting the whole row first?
Yes, but Excel will show a small Insert dialog box asking what you want to insert. Choose “Entire Row” and click OK.
Why does my shortcut open a dialog box instead of adding a row?
This happens when only a cell is selected instead of the full row. Select the entire row by clicking its row number, then try again.
Does this shortcut work in Excel Online or the mobile app?
Excel Online supports the same Ctrl + Shift + Plus shortcut on most browsers. The mobile app relies more on touch menus, so tapping the row number and choosing Insert is usually faster there.
How do I insert a row above a specific row without breaking my formulas?
Select the row, use the shortcut, then check any nearby formulas. Excel adjusts most references on its own, but formulas that use fixed row numbers may need a quick manual fix.
Final Thoughts
Once this shortcut key becomes a habit, adding rows in Excel takes a second, not a scroll-and-click routine. Practice it a few times on a test sheet, and it will stick.
