To add a worksheet row in Excel for Microsoft 365 on Windows, select the row where you want the new one to appear, then press Ctrl+Shift++ (the plus key). Excel inserts a blank row above the selected row. If you have selected only a cell, the shortcut opens the Insert dialog; choose Entire row and confirm. The steps below explain both methods and the Mac equivalent.
What You’ll Need
- A workbook open in desktop Excel or Excel for the web, with permission to edit it.
- A clear idea of where the blank row should go. Excel inserts a row above the selected row, not below it.
- A keyboard with a plus key. On many Windows keyboards, plus is printed above the equals sign, so you press Shift while pressing that key.
If the worksheet contains important data, save your workbook before making a large batch of changes. Adding a row normally does not delete existing content, but saving first makes it easier to recover from an unexpected edit.
Step-by-Step
- Choose the insertion point. Find the row that should move down to make room for the new blank one. For example, to add a row between rows 8 and 9, select row 9. The new row will appear above it. If you want a row at the bottom of a list, select the current last row and insert above it, or use the table-specific option described below.
- Select the whole worksheet row. Click the row number at the far left of the sheet. The full row should become highlighted. You can do this without the mouse: click a cell in the target row and press Shift+Space. Check that the row number is highlighted, rather than just one cell, before continuing.
- Insert the row with the shortcut. On Windows, press Ctrl+Shift++. On a standard keyboard, hold Ctrl and Shift, then press the key marked =/+. Excel inserts one blank worksheet row above the selected row, shifting existing rows and their contents downward. On some keyboards, the numeric keypad plus key may also work with Ctrl.
- Check the result. Look at the row numbers and nearby values to confirm that the blank row is in the intended location. Formulas and references often adjust automatically when you insert a worksheet row, but review important totals, charts, and linked data if the sheet has complicated formulas or external connections.
- Use the cell-selection version if needed. If you click a single cell rather than selecting its whole row, press Ctrl+Shift++. Excel opens the Insert dialog. Select Entire row, then choose OK or press Enter. The row containing the selected cell is inserted above. This is useful when you want to keep working from a cell and do not want to select the row heading first.
- Use the ribbon if the key combination is unavailable. Select a cell in the target row, then choose Home > Insert > Insert Sheet Rows. Excel adds a row above the active cell’s row. This route is also a helpful way to confirm that you are inserting a worksheet row rather than shifting only a few cells.
- For a structured Excel table, use a table-row method. If your data is formatted as a table, click a cell in the table row where the new row should go. Right-click and choose Insert, then select Table Rows Above, if that option is shown. To add a row at the end of a table, click the last cell in its final row and press Tab; Excel creates a new table row. These methods keep the new record inside the table so table formatting and calculated columns can extend to it.
Mac: Select the target row with a click on its row number, or select a cell in it and press Shift+Space. Then press Control+Shift+= to insert a row. On some Mac keyboard layouts, the plus sign requires the equals key with Shift. If the shortcut does not work, use Home > Insert > Insert Sheet Rows. Do not substitute Command for Control; the insert shortcut uses Control in Excel for Mac.
Excel for the web: Keyboard shortcuts can depend on the browser and its settings. Try selecting the row and using the Windows combination if Excel accepts it. If the browser intercepts the keys or nothing happens, use Home > Insert > Insert Sheet Rows, or right-click a row heading and choose Insert Rows. The ribbon or context-menu method is the more dependable fallback in a browser.
Common Mistakes
- Selecting the wrong row: Excel inserts above the selected row. If you select row 8, the new row goes between the old rows 7 and 8. To put a blank row below a particular row, select the row immediately beneath it before inserting.
- Having only a cell selected and expecting an immediate insert: With one cell active, the shortcut generally displays the Insert dialog. Choose Entire row; otherwise Excel may shift cells rather than insert a complete worksheet row.
- Pressing the wrong plus-key combination: On a typical Windows keyboard, the plus sign shares a key with equals. Pressing Ctrl+Shift and that key produces the plus command. The exact physical keys can differ by keyboard layout, so the menu method is a good check.
- Confusing a table row with a worksheet row: A formatted table has its own rows and expands as records are added. Use Table Rows Above or press Tab from the table’s last cell when you want a new table record. Inserting a worksheet row elsewhere can place space around the table without adding a record to it.
- Assuming only visible rows are affected: Inserting a worksheet row shifts the sheet’s grid below the insertion point, including data in other columns. Check the whole worksheet area, especially if separate lists share the same sheet.
Tips
- Insert several rows at once: Select the same number of row headings as the number of blank rows you need, then use the insert shortcut once. For example, select three row numbers and insert; Excel adds three rows above the first selected row. Selecting only one row and repeating the shortcut is slower and makes it easier to lose your place.
- Repeat the last action: After inserting a row, F4 may repeat the insertion in desktop Excel. Depending on your keyboard, you may need Fn+F4. Confirm that the active selection is where you want the next row before repeating. The repeat command may not be available for every action or in every Excel version.
- Keep your hands on the keyboard: Click a cell in the destination row, press Shift+Space to select the row, then use the insert shortcut. This sequence avoids needing to click a row number. If a laptop treats function or navigation keys differently, use the ribbon as a fallback.
- Preserve consistent formatting: Excel typically carries formatting from a neighboring row into an inserted row. If the result has an unexpected fill, border, or number format, use the insert options button that appears nearby, or apply the desired formatting from an adjacent row. For a table, its style should extend automatically when you add a table row correctly.
- Undo a mistaken insertion promptly: Press Ctrl+Z on Windows or Command+Z on Mac if the insertion was the most recent action and you have not made other changes you need to keep. Undo is not a substitute for checking a complicated workbook, especially if later edits depend on the inserted row.
Troubleshooting
Nothing happens when I press the shortcut. First, make sure Excel has focus: click a cell or row heading, then try again. Confirm that you are pressing the plus key combination, not just Ctrl+Shift. Some keyboard layouts or laptop settings handle the key differently. Select the row and use Home > Insert > Insert Sheet Rows to continue.
The Insert dialog appears instead of a row appearing. That is expected when a single cell is selected. Choose Entire row and confirm. If you want the shortcut to insert directly without the dialog, select the full row first by clicking its number or pressing Shift+Space.
The new row appears in the wrong place. Undo immediately if appropriate, then select the row heading just below the desired position and insert again. Remember that selecting row 12 adds a blank row above row 12. If the sheet is filtered or has hidden rows, check the visible row numbers and consider clearing the filter temporarily so you can identify the intended location.
Excel says it cannot insert more cells. A worksheet has a fixed row limit, so it cannot add a row beyond that limit. Another common cause is content or formatting far below or to the right of the visible data, which makes Excel treat more of the sheet as in use. Save a copy, inspect whether there is unwanted content or formatting at the sheet’s edges, and remove only what you know is unnecessary. If the workbook is protected, ask for permission or use Review > Unprotect Sheet if you are authorized and have the password.
The row is added but formulas or table formatting look different. Check whether you inserted a worksheet row or a table row. In a table, add a table row using its context-menu option or the Tab method at the end. For formulas outside a table, inspect nearby formulas and references; Excel commonly adjusts references during insertion, but complex formulas, named ranges, external links, and manually specified ranges may need review.
Frequently Asked Questions
What is the keyboard shortcut to insert a row in Excel on Windows?
With a full worksheet row selected, press Ctrl+Shift++. On many keyboards, hold Ctrl and Shift and press the equals/plus key. With only a cell selected, the shortcut opens the Insert dialog instead.
Does Excel insert the new row above or below my selection?
It inserts above. Select the row that should move down. For example, select row 5 to place a blank row between the existing rows 4 and 5.
How do I add a row in Excel on a Mac?
Select the target row, then press Control+Shift+=. Keyboard layouts can change how you enter the plus sign. If it does not work, choose Home > Insert > Insert Sheet Rows.
Can I insert multiple rows with one shortcut?
Yes. Select the same number of row headings as the number of rows you want, then run the insert shortcut once. Selecting four row headings inserts four blank rows above the first selected row.
How do I add a row at the end of an Excel table?
Click the final cell in the table’s last row and press Tab. Excel creates another table row. This is preferable to inserting an unrelated worksheet row when you are adding a record to a structured table.
Will adding a row change my formulas?
Excel often updates worksheet references when a row is inserted, but results depend on how the formulas and ranges are set up. Review totals, charts, named ranges, and external links after inserting rows in a complex workbook.
Related
- Freeze in Excel: Keep Rows and Columns Visible
- Free Excel Alternatives: Which Spreadsheet Fits You?
- Free Excel Comparison Template: Build One That Fits
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Split Cell Color in Excel: What Works and What Doesn’tExcel cannot natively fill one cell with two separate solid colors. For a clear split-color effect, use two…
- Working With Styles in Word: Apply, Edit, and ManageIn Microsoft Word for Microsoft 365 on Windows, apply a style by selecting text and choosing a style…
- Excel Header Drop-Downs: Add Filters or Choice ListsTo add a drop-down arrow for sorting or filtering, turn your data into an Excel table: select the…
- Can You Shuffle Names in Excel? Methods and ExamplesYes. In Excel for Microsoft 365 on Windows, add a random number beside each name and sort the…
- Can You Lock Certain Cells in Google Sheets? Here’s HowYes. In Google Sheets in a web browser, select the cells, choose Data > Protect sheets and ranges,…
- Google Sheets UK Date Format: Change Dates CorrectlyTo use UK dates in Google Sheets, open the spreadsheet in a browser and choose File > Settings,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.