To insert a row in Excel for Microsoft 365 on Windows, select the row where the new one should appear by pressing Shift+Space, then press Ctrl+Shift+= (the plus key). Excel inserts a blank row above the selected row. On a Mac, select the row with Shift+Space, then press Control+Shift+=. Save or undo as needed; the shortcut adds space without replacing the existing row’s contents.
What You’ll Need
- A workbook open in the desktop version of Excel, with permission to edit the sheet.
- A keyboard with a plus key, or an equals key that produces a plus when combined with Shift. On Windows, a numeric keypad plus key can also work.
- The row number or cell location where you want the new row. Excel inserts it above the selected row.
If the worksheet is protected, or if you are using Excel for the web, the keyboard method may behave differently. The troubleshooting section explains alternatives. The examples below assume a standard English-language Excel for Microsoft 365 desktop installation on Windows unless a Mac difference is noted.
Step-by-Step
- Choose the insertion point. Find the row above which the blank row should go. For example, if you want a new row between the current rows 6 and 7, select row 7. Excel inserts the new row above the selected row, so selecting row 6 instead would put the new row between rows 5 and 6.
- Make sure Excel is not editing a cell. If you see a text cursor inside a cell or the formula bar, press Esc to cancel the edit, or press Enter to accept it. Keyboard shortcuts can act on the text being edited rather than on the worksheet when a cell is in edit mode.
- Select the entire row. Click a cell anywhere in the row you chose, then press Shift+Space. Excel highlights the full worksheet row, and its row number is highlighted at the left edge. You can also click the row-number header itself; that selects the entire row without using a shortcut. If the sheet contains a table, click a cell in the table row you intend to shift.
- Insert the row on Windows. Hold Ctrl and Shift, then press the key that produces a plus sign. On a standard US keyboard, this is usually Ctrl+Shift+=, because the plus sign shares the equals key. If you have a numeric keypad, Ctrl plus the keypad’s + key may work as well. Press the keys together rather than typing them one after another.
- Insert the row on a Mac. With the whole row selected, press Control+Shift+=. Excel for Mac commonly uses Control rather than Command for this insert shortcut. Keyboard layouts vary, so use the key that produces a plus sign if the equals key is in a different location.
- Check the result. A blank row should appear above the selected row, and the selected row and those below it should move down by one. Confirm that the new row is in the intended place before entering data. If Excel instead opens an Insert dialog, choose Entire row and click OK.
- Enter or copy the new row’s contents. Type into the blank row, or copy cells from a nearby row if you need similar formatting or formulas. Check copied formulas and references: Excel may adjust relative references to match the new location. If the row is part of a formatted table, Excel may extend the table’s formatting automatically.
The same command can add several rows at once. Select the same number of complete rows as the number you want to insert, starting at the intended insertion point, then use the shortcut. For example, select rows 7 through 9 and insert to add three blank rows above the original row 7. Verify the selection count before pressing the shortcut; selecting one row will add only one, regardless of how many rows you hoped to create.
If you prefer the ribbon, select a cell or row and use Home > Insert > Insert Sheet Rows. In Windows desktop Excel, the KeyTip sequence Alt, H, I, R can also invoke Insert Sheet Rows. KeyTip availability and letters can vary with Excel version, language, and ribbon configuration, so use the visible ribbon command if that sequence differs on your computer.
Common Mistakes
- Selecting only a cell and expecting a whole row. With only one cell selected, the insert command can open the Insert dialog instead of inserting an entire worksheet row. Use Shift+Space first, or choose Entire row in the dialog.
- Using the wrong plus-key combination. On many keyboards, plus is the shifted character on the equals key. Pressing Ctrl and equals without Shift may not invoke the same command. Use Ctrl+Shift+= on a typical Windows keyboard, or the Mac equivalent noted above.
- Selecting the row below or above the intended location. Excel inserts above the selection. If a new row is needed between rows 6 and 7, select row 7, not row 6. Check the row headers before inserting.
- Using Command instead of Control on a Mac. Many Mac shortcuts use Command, but this insertion shortcut uses Control in Excel. If Command+Shift+= does nothing, select the row and try Control+Shift+=.
- Trying the shortcut while typing in a cell. In edit mode, Excel may treat the keystrokes as text or fail to insert a row. Finish or cancel the cell edit before selecting the row.
- Assuming new rows copy all desired details automatically. Excel may carry over formatting or table styles, but it will not necessarily supply the content you want. Review formulas, validation, and formatting after insertion.
Tips
- Use the row headers for certainty. Clicking a row number makes it obvious that the whole worksheet row is selected. This is useful when you are learning the shortcut or when the sheet has a complex layout.
- Insert multiple rows in one operation. Select the number of rows you want to add, beginning at the insertion point, then run the shortcut once. This is quicker and reduces the chance of selecting a different location for each row.
- Use Undo if the result is wrong. Press Ctrl+Z on Windows or Command+Z on Mac immediately after an unintended insertion. Check that the insertion has been undone before continuing with other edits.
- Use the ribbon when the keyboard layout is awkward. Choose Home > Insert > Insert Sheet Rows when you cannot easily type the plus key, when a remote desktop changes the key mapping, or when Excel does not recognize the shortcut.
- Remember that a worksheet row spans the sheet. Inserting a sheet row shifts cells across all columns, not just the columns in your visible data. If you only mean to shift a small block of cells, select that block and use the Insert dialog to choose the appropriate direction instead.
- Be careful with large selections. If you select several full rows, Excel inserts that many rows. Before using the shortcut, confirm that the highlighted row numbers cover exactly the intended range.
Troubleshooting
Nothing happens. First, click a worksheet cell, press Esc if you are editing, and select the full row with Shift+Space. Then try the correct key combination for your operating system and keyboard. On Windows, check that Shift is held while you press the equals key to produce plus. If the shortcut still fails, use Home > Insert > Insert Sheet Rows to determine whether the issue is limited to the keyboard shortcut.
An Insert dialog appears. This usually means Excel has a cell or cell range selected rather than a complete row. In the dialog, choose Entire row and confirm, or close it, press Shift+Space to select the whole row, and run the shortcut again. If you intended to insert cells rather than a full worksheet row, use the dialog’s shift options instead.
Excel says it cannot shift cells in a worksheet. The sheet may have data or formatting extending to the final worksheet row, leaving no room to push cells down. Check the bottom of the sheet for stray entries or formatting, and remove unnecessary content below your data before trying again. A worksheet supports up to 1,048,576 rows; Excel cannot insert beyond that limit.
The command is unavailable or the sheet will not change. Check whether the worksheet is protected. If you have authorization, use Review > Unprotect Sheet and enter the password if Excel requests one, then try again. If you do not have permission or the password, ask the workbook owner to enable row insertion. In a shared or read-only workbook, you may also need edit access.
The shortcut behaves differently in Excel for the web. Browser shortcuts can conflict with Excel shortcuts, and keyboard behavior may depend on the browser and operating system. Use the ribbon command Home > Insert > Insert Rows or the row-header context menu instead. If you are using a Mac, remember that Excel for Mac desktop and Excel in a browser are different environments; use the available ribbon command if the desktop shortcut is intercepted.
A table row appears in the wrong place or the table changes unexpectedly. If your data is an Excel table, click inside the table and use the table’s row controls or the worksheet insertion command as appropriate. A worksheet row insertion shifts the entire sheet, while adding a table row changes the table’s size. Check that you selected the intended operation and confirm the table boundaries afterward.
Frequently Asked Questions
What is the shortcut to insert a row in Excel on Windows?
Select the row with Shift+Space, then press Ctrl+Shift+= on a typical keyboard, where Shift and equals produce the plus sign. A numeric keypad’s plus key may also work with Ctrl. Excel inserts above the selected row.
What is the Excel row-insert shortcut on a Mac?
Select the row, usually with Shift+Space, and press Control+Shift+=. This shortcut uses Control rather than Command in Excel for Mac. If your keyboard layout places the plus sign elsewhere, use the corresponding plus key.
Can I insert more than one row at a time?
Yes. Select as many complete rows as you want to add, starting at the row where insertion should begin, then use the insert shortcut once. Selecting three rows inserts three blank rows above the top selected row.
Does Excel insert the new row above or below my selection?
It inserts above. To place a blank row between rows 10 and 11, select row 11 before running the shortcut. The selected row and the rows below it move down.
Why does Ctrl+Shift+= open a dialog instead of inserting a row?
Excel may have only a cell selected. Press Esc to close the dialog, select the entire row with Shift+Space, and repeat the shortcut. You can also choose Entire row in the dialog and confirm.
Will inserting a row change formulas?
Excel adjusts many cell references when rows are inserted, but the outcome depends on the formulas and where they point. After inserting, inspect formulas near the affected area, especially formulas that refer to ranges, named ranges, or data outside the inserted section.
Related
- Excel Group and Ungroup Shortcuts for Rows and Columns
- Group Cells in Excel Without Merging: A Step-by-Step Guide
- Group Dates by Month in an Excel PivotTable: Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change Slide Size in PowerPointTo change slide page size in PowerPoint for Microsoft 365 on Windows, open the presentation and select Design…
- Actual vs Forecast in Excel: Compare ResultsActual vs forecast in Excel means comparing what happened with what was expected. Put the forecast in one…
- Indent Within the Same Cell in Excel: Step-by-StepTo indent only one line within an Excel cell, insert a line break with Alt+Enter on Windows, then…
- How to Find a Table in Excel: Search and NavigationTo find a table in Excel, search for a word or value you expect it to contain, then…
- Data Validation Interview Questions and Strong AnswersData validation interview questions test whether you can define rules for acceptable data, detect records that break those…
- Excel Custom Number Format: Show Zero as a DashYes. In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Custom, and enter #,##0.00;(#,##0.00);"-";@…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.