In Microsoft Excel for Microsoft 365 on Windows, select the row where the new row should go, then press Ctrl+Shift+= (the plus key). Excel inserts a blank row above the selected row; on a Mac, select the row and press Control+Shift+=. If you select only a cell rather than the whole row, the shortcut opens the Insert dialog so you can choose what to insert.
The Windows shortcut and what to select
The shortcut is easiest to remember as Ctrl plus the plus sign. On most standard keyboards, the plus sign shares the equals key, so you press Ctrl+Shift+=. If your keyboard has a separate numeric keypad, Ctrl plus the keypad’s plus key may also work. Keyboard layouts differ, so the important point is to invoke the plus-sign shortcut while Excel is active.
To add one worksheet row above a particular row, click its row number at the left edge of the sheet first. For example, if a new line should appear above row 8, click the number 8 so the entire row is highlighted, then use the shortcut. The existing row 8 and everything beneath it move down. Excel does not overwrite the selected row.
- Click the row heading for the row that should move down.
- Press Ctrl+Shift+=.
- Check that the blank row appears above the selected row, then enter the new data.
If you are already positioned in a cell in the target row, you can select the full row with Shift+Space and then press the insert shortcut. This is useful when navigating with the keyboard. The row heading should become selected before you insert if your intention is to add a complete worksheet row.
Why selecting a whole row matters
Excel uses the current selection to decide what the shortcut means. With an entire worksheet row selected, it inserts a complete row. With a single cell selected, Excel cannot assume whether you want a cell, a row, or a column, so it opens the Insert dialog. That dialog offers choices such as shifting cells down or inserting an entire row.
This distinction explains why users sometimes report that the shortcut did not insert a row: it may have opened a dialog instead. Choose Entire row in the dialog if that is what you intend. If you are inserting into a range of ordinary cells and want to preserve the cells to the right, choose an appropriate shift option instead. Inserting a whole row affects every column in the worksheet, not just the visible part of your table.
The row number is a reliable visual cue. A highlighted row heading indicates that the full worksheet row is selected. A border around one cell, or a highlighted rectangular range that does not extend across the sheet, is a cell selection, not a full-row selection.
Insert several rows at once
To insert more than one row, select the same number of existing row headings as the number of blank rows you need, then use the shortcut once. For instance, select rows 8 through 10 and press Ctrl+Shift+= to insert three rows above the former row 8. Excel bases the number of inserted rows on the number of rows in the selection.
This is generally quicker and less error-prone than inserting one row repeatedly, especially in a large worksheet. Take care to select consecutive row headings if you want a continuous block of new rows. If you select nonadjacent rows with Ctrl-click, the resulting behavior may not match the simple consecutive-row case, so use a contiguous selection when you need a predictable block.
When adding rows at the bottom of a data list, decide whether you need a worksheet row or just another record in an Excel Table. Tables can expand as you type in the row immediately below them, and table-specific insertion options can be more suitable than changing the whole worksheet.
What happens to data, formulas, and formatting
Inserting a worksheet row shifts existing cells down in that row position and keeps the surrounding content rather than replacing it. References in formulas may adjust when rows are inserted, but the exact result depends on where the formula and referenced cells are. If a formula refers to a range that is extended by the insertion, Excel often updates the reference to reflect the changed layout. Do not assume every formula, chart, named range, or external link will behave exactly as intended in a complex workbook.
New rows also need suitable formatting. Excel may carry formatting from a neighboring row or show an insert-options control that lets you choose how the new row is formatted. Review number formats, borders, data validation, conditional formatting, and formulas after inserting rows into a carefully designed worksheet. A blank-looking cell can still contain formatting or validation rules, and a row that looks consistent may not have the same formulas as its neighbors.
For an important workbook, check calculations and totals after structural changes. A total using a range may update automatically, but a manually specified range or a formula outside the inserted area might not include the new record. This is one reason Excel Tables are useful for ongoing lists: table formulas and structured references can make expanding data easier to manage, though workbook design still matters.
Inserting a row inside an Excel Table
An Excel Table is a formatted, filterable data region, and it behaves differently from an ordinary worksheet range in some respects. To add a record within a table, right-click a cell in the table row where the new record belongs and look for Insert followed by the table-row option, such as Table Rows Above. The exact available wording can depend on where you right-click.
You can also add a record by entering data in the first row immediately below a table; Excel commonly expands the table to include the new entry. Confirm that the table range expanded, particularly if adjacent content or workbook settings affect automatic expansion. Adding a complete worksheet row with the row-heading shortcut is a broader operation: it inserts across the sheet and can affect unrelated data in other columns.
If you use the keyboard shortcut while working in a table, pay attention to the selection and the result. A selected worksheet row and a selected table row are not always equivalent in scope. Use the table’s context-menu command when your goal is specifically to add a table record and avoid changing more of the worksheet than necessary.
Ribbon and mouse alternatives
If the keyboard shortcut is inconvenient or unavailable, Excel provides menu commands that perform the same basic task. On Windows, select a row heading, then use Home > Insert > Insert Sheet Rows. You can also right-click the selected row heading and choose Insert. These commands make the intended scope clear and are useful when helping someone who does not use keyboard shortcuts.
For a cell-only selection, the ribbon’s Insert menu may offer an option to insert sheet rows, while the shortcut’s dialog lets you choose the insertion type. Check which command is available in your current selection and version. Inserting a row above the target is the standard result when the target row is selected; Excel does not add it below merely because you clicked a cell in that row.
Undo is usually available immediately after an insertion with Ctrl+Z on Windows, or Command+Z on Mac. However, undo may not be available after certain operations, after closing the workbook, or when a macro or external process has changed the file. Save a copy before making major structural changes to a workbook that is difficult to recreate.
Mac and Excel for the web
In Excel for Mac, select the whole row and use Control+Shift+= to insert it. Mac keyboard layouts and keyboards with a numeric keypad can handle the plus sign differently, so if the keystroke is awkward, use the row-heading context menu or the ribbon’s Insert command instead. Do not substitute Command automatically: the insert shortcut uses Control on common Excel for Mac shortcut references, while Command is used for many other Mac commands.
Excel for the web runs in a browser, where some keyboard combinations can be affected by browser or operating-system shortcuts. If the key combination does not work, select the row heading and use the ribbon command Home > Insert > Insert Sheet Rows, or right-click the row heading and choose the insert command. The web interface can change over time, but the row-selection principle remains the same: select the worksheet row above which you want the blank row.
Common problems and quick checks
- The Insert dialog appears: You probably selected a cell or range rather than the entire row. Choose Entire row in the dialog, or select the row heading first.
- Nothing happens: Make sure Excel has focus and that you are not editing text inside a cell. Press Enter or Escape to leave cell-edit mode, then try again.
- The worksheet is protected: Sheet protection may prevent inserting rows unless that action is allowed. Check the workbook’s protection settings or ask its owner before changing them.
- The new row appears in the wrong place: The selected row is the row Excel moves down. Select the row immediately below where you want the new blank row.
- The layout changes unexpectedly: Review merged cells, formulas, formatting, and table boundaries. A whole-sheet row insertion affects all columns, including columns outside the visible data block.
Also check whether a filter is active and whether you are working inside a structured table. The visible records may not tell the whole story about the worksheet’s underlying row positions. If insertion is restricted, or a workbook uses complex formulas and linked data, save a copy and confirm the intended effect before continuing.
Frequently Asked Questions
What is the shortcut to insert a row in Excel on Windows?
Select the row heading, then press Ctrl+Shift+=, which is the plus-sign shortcut on most keyboards. Excel inserts a blank row above the selected row.
How do I insert a row without using the mouse?
Move to a cell in the target row, press Shift+Space to select the entire row, then press Ctrl+Shift+= on Windows. On Mac, use Control+Shift+= after selecting the row.
Can I insert multiple rows with one shortcut?
Yes. Select the number of consecutive row headings you want to add, then invoke the insert shortcut once. Selecting three rows inserts three blank rows above the first selected row.
Why does Excel show an Insert dialog instead of adding a row?
The selection is likely a cell or cell range rather than a full worksheet row. Select the row heading to insert a complete row directly, or choose Entire row in the dialog.
Does the shortcut add a row above or below?
It adds the new row above the selected row. To put a row between two existing rows, select the lower row and insert; the lower row moves down to make room.
Is the shortcut different in Excel for the web?
The same key combination may work depending on your browser and keyboard, but browser shortcuts can interfere. If it does not, select the row heading and use Home > Insert > Insert Sheet Rows.
Related
- Machine ROI Calculator in Excel: Build and Use One
- Mac Numbers vs Excel: Which Spreadsheet Should You Use?
- Machine Checklist Format in Excel: A Practical Template
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut Keys to Select a Column: Quick GuideIn Excel for Microsoft 365 on Windows, press Ctrl+Space to select the entire column containing the active cell.…
- How to Find Links in an Excel SpreadsheetTo find links in an Excel spreadsheet, press Ctrl+F, search for a visible URL or the word HYPERLINK,…
- Microsoft Excel Transpose Table: Methods, Limits and TipsTo transpose a table in Microsoft Excel for Microsoft 365 on Windows, copy the source range, select a…
- Excel Shortcut to Capitalize All Letters in a Cell?Excel has no dedicated keyboard shortcut that directly changes selected text to ALL CAPS. The quickest reliable method…
- Excel Data Model vs Power Query: How They Work TogetherPower Query cleans, reshapes, and imports data; the Excel Data Model stores related tables so you can analyze…
- Box and Whisker Plot Creator in ExcelExcel has a built-in box and whisker plot creator: in Excel for Microsoft 365 on Windows, arrange each…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.