To insert a row in Excel for Microsoft 365 on Windows, select the row number where the new row should go, then choose Home > Insert > Insert Sheet Rows. Excel adds a blank row above the selected row; you can also right-click its row number and choose Insert.
What inserting a row does
An Excel worksheet is arranged in numbered rows and lettered columns. Inserting a row adds a new horizontal space across the worksheet and shifts existing cells downward. If you select an entire worksheet row, Excel inserts a complete row, not just a blank cell in one column. This is usually the right choice when you need to add a record to a list, a line to a schedule, or a calculation between existing entries.
The position of the selection determines where the blank row appears. Select row 8, for example, and the new row appears above the existing row 8. The old row 8 and the rows below it move down, so their contents are not overwritten. Excel adjusts many formulas and cell references to account for the shift, though it is wise to inspect important calculations after changing a complex worksheet.
Insert a row with the ribbon
The ribbon method is easy to find and works well when you are learning Excel or do not use keyboard shortcuts. In the Windows desktop app, follow these steps:
- Find the row number at the left edge of the worksheet for the row above which you want the blank row.
- Click that row number. The entire row should be highlighted.
- Go to Home > Insert > Insert Sheet Rows.
For example, to add a line between the current rows 7 and 8, select the row number 8 and choose Insert Sheet Rows. The new blank row becomes row 8, and the former row 8 moves to row 9. If you select a cell rather than a row header, the ribbon command still inserts a worksheet row at the active cell’s position.
The Insert button may appear as an icon in the Cells group on the Home tab. Use its dropdown arrow to see the specific Insert Sheet Rows command. The nearby Delete and Format controls are separate commands, so check that you have chosen Insert rather than Delete.
Use the right-click menu
For a quick, local operation, right-click the row number where the new row should appear and choose Insert. This is the same basic operation as inserting through the ribbon. Selecting the row header first matters: right-clicking inside an ordinary cell may show cell-level options, and choosing Insert from that menu can open a dialog asking whether to shift cells right, shift cells down, insert an entire row, or insert an entire column.
When adding a row to a list, right-click the row number of the first existing record that should move down. For instance, if a heading is in row 1 and the first record is in row 2, right-click row 2 and choose Insert to make room directly below the heading. Avoid selecting the heading row unless the new row is meant to go above the heading.
Insert rows with a keyboard shortcut
On Windows, select a whole row by clicking its row number, then press Ctrl+Shift+= (the plus key is often typed as Ctrl+Shift+plus). Excel inserts a row above the selected row. If you have selected a cell instead of a whole row, the shortcut may bring up the Insert dialog; choose Entire row if you want to insert a complete worksheet row.
You can select a row without using the mouse: click a cell in the target row and press Shift+Space. Then press Ctrl+Shift+=. This is useful when working in a large sheet where scrolling to the row header is inconvenient. On a Mac, the corresponding row-selection shortcut is Shift+Space; the insert shortcut is generally Control+Shift+= in Excel for Mac, although keyboard layouts can affect how the plus sign is entered. If a shortcut does not work on your Mac, use the ribbon or row-header context menu instead.
Excel lets you select adjacent rows before inserting. Click and drag over their row numbers, or select a cell in the first row and extend the selection with Shift+Space and the selection keys. Then use the insert shortcut or ribbon command. The number of blank rows inserted matches the number of rows selected: selecting rows 5 through 7 and inserting adds three rows above row 5.
Insert several rows at once
To create multiple blank rows efficiently, select the same number of existing rows as the number you want to add. Suppose a list needs four new lines above row 12. Select row numbers 12 through 15, then use Home > Insert > Insert Sheet Rows, right-click and choose Insert, or use the keyboard shortcut. Excel adds four blank rows above the original row 12.
This method is more predictable than repeating the insert command four times, especially when you need to preserve the position of a particular record. If the rows are not adjacent, insert them separately or make a plan for the changing row numbers: each insertion shifts rows below it, which can make a later selection point to a different record than before.
Adding a row inside an Excel table
An Excel table is a formatted range with features such as filter buttons and structured column references. Table rows are not quite the same as ordinary worksheet rows. To add a record at the bottom of a table, click the last cell in its last row and press Tab; Excel creates a new table row. You can also type directly in the row immediately below the table, and Excel will often expand the table automatically when the adjacent data is entered. That automatic expansion can depend on Excel’s settings and the surrounding worksheet layout.
To add a table row in the middle, right-click a cell in the table row that should move down and choose Insert, then choose Table Rows Above if that option is shown. This inserts a row within the table rather than merely adding worksheet space outside its boundaries. The new table row generally inherits the table’s formatting and calculated-column behavior. If you need to insert a complete worksheet row that also shifts cells outside the table, use the row number and the worksheet-row command, then check whether the table expanded as intended.
Tables can make lists easier to maintain because sorting and filtering apply to the table’s records, and formulas may use column names instead of fixed cell addresses. But adding a worksheet row near a table is not automatically identical to adding a table record. Check the table outline and filter buttons to confirm that the new line is part of the table.
Formatting, formulas, and what happens to data
Excel commonly copies formatting from a neighboring row when inserting a row. The exact appearance depends on the location and surrounding formatting, and the inserted row may inherit borders, number formats, fill colors, or styles that you do not want. After inserting, look for the small Insert Options button near the new row. Its choices can include formatting from the row above, formatting from the row below, or clearing formatting. If the button is not visible, use the Home tab’s formatting tools to adjust the row manually.
Formulas that refer to cells moved by an insertion are often updated by Excel. For example, if a total uses a range of cells and a row is inserted within that range, Excel generally expands the reference to include the new position. However, formula behavior depends on how the reference was constructed and where the new row is inserted. Formulas using fixed text references, external workbooks, named ranges, indirect references, or carefully designed models may need extra review. Inserting a row does not automatically fill every blank cell with a formula; in a table, calculated columns are more likely to propagate a formula to the new record.
Before making a major change, save the workbook or use Undo (Ctrl+Z on Windows; Command+Z on Mac) if the result is not what you intended. Undo is useful for a recent worksheet edit, but it should not replace saving a copy before substantial restructuring.
Common problems and how to fix them
- The new row appears in the wrong place: Excel inserts above the selected row. Undo, select the row number immediately below the desired position, and insert again.
- Only some cells shift: You likely selected individual cells and chose a shift option in the Insert dialog. Undo, select the row header, and insert a sheet row to shift the entire worksheet row.
- The command is unavailable or Excel reports that it cannot shift cells: A worksheet has a fixed maximum of 1,048,576 rows. If non-empty or formatted cells at the bottom of the sheet would be pushed past that limit, Excel may refuse an insertion. Check the bottom of the worksheet for stray content or formatting; remove only material you know is unnecessary, then try again.
- Formulas or formatting look different afterward: Inspect the formulas and the Insert Options button. Excel may have adjusted references or copied a neighboring row’s style; correct the formula or formatting if needed.
- The sheet is protected: A protected worksheet may prevent row insertion unless the sheet’s protection settings allow it. Ask the workbook owner or review the protection options rather than trying to work around the restriction.
When to insert a row instead of a cell
Choose an entire row when the new information belongs across the same set of columns as the records around it. This keeps data aligned. For example, if columns A through E contain date, item, category, quantity, and status, inserting a full row creates space across all five fields and any other columns on that worksheet.
Inserting only cells can be appropriate for a small layout adjustment, such as making room in one part of a worksheet without shifting unrelated content in other columns. In that case, select the target cell or range and choose Home > Insert > Insert Cells. Excel asks how to move surrounding cells. This can disrupt aligned records if used in the middle of a conventional data table, so use it only when shifting a limited area is intentional.
Frequently Asked Questions
How do I insert a row above the current row in Excel?
Select the row number of the current row, then choose Home > Insert > Insert Sheet Rows. The new row appears above it, and the existing row moves down.
What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift+=. If you have selected a cell rather than a whole row, Excel may display the Insert dialog. On Mac, Control+Shift+= is generally the equivalent; use the ribbon if your keyboard layout handles the plus key differently.
How can I add two or more rows at once?
Select as many row headers as the number of rows you want to add, starting at the position where the blank rows should begin. Then use Insert Sheet Rows or the insert shortcut. Excel inserts the same number of rows above the selection.
Can I insert a row in the middle of an Excel table?
Yes. Right-click a cell in the table row that should move down and choose Insert, then select Table Rows Above when available. To add a row at the bottom, press Tab from the last cell in the table’s last row.
Will inserting a row change my formulas?
Excel updates many cell references when rows are inserted, but the result depends on the formula and where the insertion occurs. Check totals, references to external workbooks, and other important calculations after changing the layout.
Related
- Excel X Y Scatter Plot with Multiple Series Explained
- Excel Won’t Remove Duplicates? Causes and Fixes
- Excel Won’t Insert a Row? Causes, Fixes, and Workarounds
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Consolidate: How to Combine Data Across SheetsExcel has no worksheet function named CONSOLIDATE. To combine ranges, use Data > Data Tools > Consolidate; if…
- Excel Analysis Methods: Tools, Steps, and ExamplesExcel analysis methods include formulas, PivotTables, charts, conditional formatting, Power Query, and statistical tools. Choose a method based…
- Share a Specific Calendar in Outlook: Access and StepsTo share one calendar in Outlook, select that calendar—not just the Calendar view—open its sharing settings, add the…
- Hotel Laundry List Template Excel: Setup and UseA hotel laundry list template in Excel is a tracking sheet for recording laundry sent out, returned, missing,…
- Quartile 1 and 3 in Excel: Find Q1 and Q3 CorrectlyTo find the first and third quartiles in Excel, use QUARTILE.INC with 1 for Q1 and 3 for…
- Google Sheets Filter Columns: How It WorksTo filter data in Google Sheets, select your table and choose Data > Create a filter, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.