In Excel for Microsoft 365 on Windows, select the row where the new row should go with Shift+Space, then press Ctrl+Shift++ (the plus key). Excel inserts a worksheet row above the selected row; on a Mac, use Control+Shift+= after selecting the row, or use the Insert menu if your keyboard layout handles the plus key differently.
The fastest way to insert a row
The shortcut works in two parts: first select a whole row, then issue the insert command. Click a cell in the row that should sit immediately below the new blank row, press Shift+Space to select that entire worksheet row, and press Ctrl+Shift++. For example, if you want a blank row between rows 8 and 9, select a cell in row 9, select the row, and insert. The new row becomes row 9, and the previous row 9 moves down.
On most Windows keyboards, the plus sign shares the equals key. In that case, hold Ctrl and Shift and press the equals/plus key. The shortcut is sometimes written Ctrl++ or Ctrl+Plus, but including Shift makes clear that you are entering the plus sign. If Excel opens an Insert dialog instead of inserting immediately, check that you selected the entire worksheet row rather than just a cell.
- Click any cell in the row that should move down.
- Press Shift+Space to select the full row.
- Press Ctrl+Shift++ to insert a blank row above it.
Why the selected row matters
Excel inserts a row above the current selection. That placement rule is easy to miss: selecting row 9 does not add a row below row 9; it adds one before it. If you want a row after your current last record, select the row directly below the last record and insert there. If that row is already the bottom of the worksheet, Excel cannot add another one because a worksheet has a fixed maximum of 1,048,576 rows.
Selection also determines what Excel inserts. With a single cell selected, the insert command may show an Insert dialog asking whether to shift cells right, shift cells down, insert an entire row, or insert an entire column. Selecting a full row first removes that ambiguity. Clicking the row number at the left edge of the worksheet is another way to select the whole row, after which the keyboard shortcut works the same way.
Insert several rows at once
You can insert more than one blank row in a single operation. Select the same number of existing worksheet rows as the number you want to add, then use the insert shortcut. To add three rows above row 10, select rows 10 through 12 and press Ctrl+Shift++. Excel inserts three rows above the selection; it does not matter that those selected rows contain data, because the existing rows are shifted down rather than overwritten.
To select a block with the keyboard, click a cell in the first row and press Shift+Space. Then extend the selection down with Shift+Down Arrow twice to include three rows in total, and press the insert shortcut. You can also drag across row numbers or click the first row number and Shift-click the last. Check the highlighted row headers before inserting, especially when the worksheet is filtered or scrolled far from the top.
Other ways to insert a worksheet row
Keyboard shortcuts are quick, but the ribbon and context menu make the operation easier to discover and can be more practical when you are unsure what is selected.
- Ribbon: Select a worksheet row, then choose Home > Insert > Insert Sheet Rows.
- Context menu: Right-click the selected row number and choose Insert.
- Key Tips: On Windows, press Alt, then H, I, and R in sequence to use the Home tab’s Insert Sheet Rows command. Key Tips can vary if ribbon customization or localization changes the displayed letters.
These methods insert a worksheet row, not merely a blank cell in one column. That distinction matters when a sheet contains related information across columns: inserting an entire row keeps the records aligned. By contrast, choosing to shift cells down in only one column can move values out of alignment with the rest of the record.
Using the shortcut on Mac or Excel for the web
In Excel for Mac, select the row with Shift+Space and use Control+Shift+= to enter the plus command on a common keyboard layout. Mac keyboards and regional layouts differ, and some combinations can be intercepted by macOS or another application. If the shortcut does not work, select the row and use the ribbon’s Home > Insert options or the row-header context menu instead. The exact menu wording can depend on whether the selection is a worksheet row or a table row.
Excel for the web runs in a browser, where keyboard shortcuts can interact with browser shortcuts and operating-system settings. The row-selection and insert shortcut may work in many setups, but the reliable fallback is to select the row header and choose the insert command from Excel’s ribbon or context menu. If a shortcut opens a browser feature or does nothing, use the menu rather than repeatedly pressing keys. Excel’s available shortcuts can also depend on the browser and the keyboard configuration.
Worksheet rows versus Excel table rows
An Excel table is a formatted, structured data range with filter buttons and features such as automatically extending formulas. A worksheet row, by comparison, spans the entire sheet. If you are entering a record inside a table, it is often better to insert a table row rather than an unrelated blank worksheet row. Right-click a cell in the table row where the new record belongs and look for the table-specific insert option, such as inserting a table row above. The wording and available options depend on the selected cell and Excel version.
Pressing the worksheet-row shortcut while a table cell is selected may insert a whole sheet row, which can affect cells outside the table too. That may be exactly what you intend, but it is not always the same as adding a record within the table. For an ordinary table, typing into the row immediately below it can also expand the table automatically in many cases. If you need a blank record in the middle, use the table’s own insert command and then confirm that the new row has the table formatting and filter behavior you expect.
What happens to formulas, formatting, and references
When Excel inserts a complete worksheet row, cells below the insertion point move down. Formulas that refer to affected cells are generally adjusted so they continue to refer to the corresponding data. For example, a formula summing a continuous column may expand to include an inserted row when it lies within the referenced range, but the exact result depends on the formula’s original references and where the row is inserted. Do not assume every formula, named range, chart, or external link will update in the way a particular workbook requires.
Excel also carries formatting into a new row based on nearby rows. After inserting, a small Insert Options control may offer choices about formatting, including using formatting from above or below, or clearing the inserted row’s formatting. This is useful when the surrounding rows have different borders, fills, or number formats. If the inserted row looks wrong, check its number format as well as its font and fill; a date or currency format can make an empty cell appear unusual once you enter a value.
In shared or complex workbooks, review formulas and dependent items after structural changes. Inserting a row is usually reversible with Ctrl+Z on Windows or Command+Z on Mac, provided you have not performed an action that clears the undo history. Saving a copy before making substantial changes is sensible when the sheet contains important reporting logic.
Common problems and quick fixes
- The shortcut opens a dialog: You likely selected a cell rather than the row. Press Escape, select the row with Shift+Space, and try again.
- The plus key does not register: On a typical Windows keyboard, use Ctrl+Shift with the equals key. On a laptop or regional layout, the key position may differ; the ribbon command is a dependable alternative.
- Excel says it cannot shift objects off the sheet: A comment, shape, chart, or other object near the bottom of the worksheet may block the shift. Review objects near the insertion area or move them before trying again.
- The new row appears in the wrong place: Excel inserts above the selected row. Undo, then select the row that should move down.
- Only one column seems affected: You may have inserted cells rather than an entire row. Undo and select the row header before inserting.
Filters can create another source of confusion. A filtered worksheet may hide some records, but inserting a worksheet row still affects the sheet’s row structure rather than simply adding a visible record to the filtered results. If the goal is to add a data record to a filtered list or table, use the table’s row-insertion method and verify where the record appears after the filter is cleared.
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++ (Ctrl+Shift and the plus key). Excel inserts above the selected row.
How do I insert a row below the current row?
Select the row immediately below the position where you want the blank row, then insert. Excel always adds the new worksheet row above the selected row.
Can I insert multiple rows at once?
Yes. Select as many existing rows as you want to add, then use the insert command. Selecting four rows inserts four blank rows above the selected block.
What is the Excel row-insert shortcut on a Mac?
Select the row with Shift+Space, then try Control+Shift+=. If your keyboard layout or macOS settings prevent it, use the Home > Insert menu or the row-header context menu.
How do I add a row inside an Excel table?
Use the table-specific insert option from the context menu when you right-click a table row or cell. This inserts a table record; inserting a worksheet row affects the whole sheet and may not be what you want.
Related
- Excel Power Query: Merge All Files in a Folder
- Excel Power Query Merge Table Types and When to Use Them
- Excel Power Query: Enable Background Refresh
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Sum COUNTIF in Google Sheets With SUMIFTo add values that match a condition in Google Sheets, use SUMIF, not COUNTIF. With item names in…
- Comparison Plot in Excel With R²: Steps and MeaningTo make a comparison plot with R² in Excel, put the shared X values and each dataset’s Y…
- How to Change Outlook View Back to the Original LayoutTo restore the familiar layout in classic Outlook for Windows, select the affected folder, open View > Reset…
- Excel Text Direction: Change Cells and Sheet LayoutIn Excel for Microsoft 365 on Windows, change the direction of text in a cell by opening Format…
- How to Add Multiple Audio Files in PowerPoint SlidesTo add multiple audio files in PowerPoint, insert each file separately using Insert > Audio, then choose how…
- Date in Google Sheets: Enter, Format, and CalculateTo enter a date in Google Sheets, type it into a cell in a format your spreadsheet recognizes,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.