How to Insert a New Row in Excel on Windows and Mac

To insert a new row in Excel for Microsoft 365 on Windows, select the row heading where you want the blank row to appear, then choose Home > Insert > Insert Sheet Rows. Excel adds a row above your selection and shifts existing rows down. You can also right-click the row heading and choose Insert.

Inserting a row is useful when you need space for a new record, task, or heading without overwriting existing information. Before you begin, decide where the new row belongs: Excel inserts it above the selected row, not below it. If your data is formatted as an Excel table, use the table-specific option described below so the new row becomes part of the table.

What You’ll Need

An Excel workbook open in Microsoft Excel. These instructions focus on Microsoft 365 for Windows; the same basic process is available in Excel for Mac and Excel for the web.
Permission to edit the worksheet. A protected sheet may prevent you from inserting rows.
A clear idea of where the row should go. Identify an existing row above which Excel can insert it.

Step-by-Step

Open the worksheet and locate the insertion point. Find the row that should move down to make space. For example, to add a record between rows 8 and 9, select row 9. Excel inserts the blank row above row 9, so the existing contents of row 9 move to row 10. If you want a row at the very top, select row 1.
Select the entire row. Click its numbered heading at the far left of the worksheet, such as the number 9. The whole row should be highlighted across the sheet. Selecting the row heading is the clearest way to avoid inserting only a few cells and leaving the surrounding columns out of alignment. You can select multiple adjacent row headings by dragging over them or by clicking the first heading and Shift-clicking the last.
Insert the row from the ribbon. With the row selected, go to the Home tab. In the Cells group, open the Insert menu and choose Insert Sheet Rows. Excel inserts one worksheet row for each selected row heading. If you selected rows 9 and 10, for instance, it inserts two rows above row 9.
Use the right-click menu if that is quicker. Right-click the selected row heading and choose Insert. When an entire worksheet row is selected, Excel inserts a full row above it. If you right-click inside a cell instead, the menu may offer Insert and open a dialog with choices such as shifting cells down or inserting an entire row. Choose the whole-row option if you want all columns to move together.
Try the keyboard shortcut on Windows. Select a row heading, then press Ctrl+Shift+= (the plus key is commonly entered with Shift and the equals key). Excel inserts a row above the selected row. If you selected a cell rather than its row heading, Excel may show the Insert dialog; choose Entire row and confirm. On some keyboards, the exact plus-key combination depends on the layout, so use the ribbon or right-click menu if the shortcut does not work.
Enter information in the new row. Click a cell in the inserted row and type your data. Press Tab to move across cells; when you reach the last column in a range, check where Excel moves next before entering more information. Use the existing column headings as a guide, and avoid typing a new value into a neighboring row by mistake.
Check formatting and formulas. Excel often carries formatting or formulas down from nearby rows, but the result depends on the worksheet and its settings. Inspect number formats, borders, data validation, and formulas in the new row. If a formula did not appear, copy it from an adjacent row or enter the appropriate formula yourself, then verify that its cell references point to the intended data.

Adding a Row to an Excel Table

An Excel table is a formatted data range with filter buttons in its header row. To insert a table row at a specific position, right-click a cell in the table row that should move down, choose Insert, then choose Table Rows Above. This adds a row within the table rather than merely placing an unrelated worksheet row nearby. The table’s formatting and calculated-column formulas will generally extend into the new row.

You can also add a record at the end of a table by clicking the first blank row immediately below it and typing in a cell. Excel often expands the table to include the new record. Check that the table range expanded and that filters, formulas, and formatting cover the added row. If it did not expand, use the table’s resize option or insert a table row from the right-click menu instead.

Excel for Mac and Excel for the Web

In Excel for Mac, select the row heading, then use Home > Insert > Insert Sheet Rows, or Control-click or right-click the heading and choose Insert. Keyboard shortcuts can differ with Mac keyboard layouts and system settings, so the ribbon route is a dependable alternative. In Excel for the web, select a row heading, right-click it, and choose Insert Rows, or use the Insert command on the Home tab. Browser and keyboard settings can affect shortcuts in the web version.

Common Mistakes

Selecting a cell when you meant to select a row. Inserting cells can shift only part of a range, leaving records misaligned across columns. Click the numbered row heading to select the whole worksheet row before inserting.
Choosing the wrong insertion point. Excel inserts above the selected row. If you select row 8 hoping to add a row after row 8, the new row appears before it. Select row 9 instead.
Adding a worksheet row instead of a table row. If your data is an Excel table, a general sheet-row insertion may not behave like adding a record inside the table. Use Insert > Table Rows Above from a cell in the table.
Assuming the new row is completely empty. Excel may copy formatting, formulas, or other attributes from a nearby row. Review the new row before entering data, especially if the worksheet uses formulas or validation rules.
Inserting while data is filtered without checking the result. A filter can hide records, so it may be difficult to see where the inserted row landed. For a regular filtered range, consider clearing the filter, inserting the row at the intended position, and then applying the filter again.
Overlooking merged cells or protection. Merged ranges can complicate row insertion, and sheet protection can block it. Check for these conditions if Excel reports that it cannot complete the action.

Tips

Use row headings for whole-row changes. This keeps information in each record aligned across columns and makes it clear how many rows you are inserting.
Insert several rows at once. Select the same number of row headings as the number of blank rows you need, then use Insert Sheet Rows. For example, select three headings to insert three rows above the first selected heading.
Keep a consistent data structure. If each record uses the same columns, copy an existing row’s layout when appropriate, then replace its contents carefully. Avoid copying values that should not be duplicated, such as an old ID or date.
Check formulas after structural changes. Excel usually adjusts many references when rows are inserted, but do not assume every formula, chart, named range, or external connection is set up as intended. Review important totals and reports after adding rows.
Undo promptly if you insert in the wrong place. Press Ctrl+Z on Windows or Command+Z on Mac to undo the insertion, then select the correct row and try again. If you have made other changes since inserting, check the undo sequence before reversing anything.
Save after confirming the layout. Once the new row contains the correct information and the formulas and formatting look right, save the workbook. This is especially useful when editing a shared or important file.

Troubleshooting

The Insert option is unavailable or Excel refuses to add a row. The worksheet may be protected, the workbook may be in a restricted editing state, or the selection may include merged cells that prevent the change. Check the Review tab for sheet-protection controls and ask the workbook owner for permission if needed. If merged cells are involved, inspect the layout and adjust or unmerge them only if doing so is appropriate for the workbook.

Excel inserted cells but not a full row. You probably selected one or more cells rather than the row heading. Undo the change, click the numbered heading at the left, and insert again. If you choose Insert from a cell’s context menu, select Entire row in the dialog rather than Shift cells down.

The new row appeared in the wrong place. Remember that insertion happens above the selected row. Undo, select the heading immediately below the desired position, and insert again. If filters are active, clear them temporarily so hidden rows do not make the target position confusing.

The new table row does not receive the table style or formulas. Confirm that you inserted a table row using Table Rows Above, or that you entered data directly beneath the table and Excel expanded it. If the new row sits outside the table, use the table’s resize controls or insert within the table, then inspect calculated columns and formatting.

Rows below the insertion point seem to be missing. Excel shifts rows down rather than deleting them, but filters, hidden rows, or the worksheet’s scroll position can make records hard to see. Clear filters, check for hidden rows, and look below the insertion point. If data was overwritten rather than shifted, use Undo immediately if possible.

The shortcut does something else. Keyboard layouts differ, and a shortcut may be intercepted by the operating system or browser. On Windows, select the row heading and try Ctrl+Shift+=. If it opens a dialog, choose Entire row. Otherwise, use Home > Insert > Insert Sheet Rows or the row-heading context menu.

Frequently Asked Questions

Does Excel insert a new row above or below the selected row?
Above. To place a row between rows 8 and 9, select row 9 before inserting.

How do I insert more than one row at a time?
Select the same number of row headings as the number of rows you need, then choose Home > Insert > Insert Sheet Rows. Excel adds that many rows above the first selected row.

Will inserting a row change my formulas?
Excel adjusts many cell references automatically when you insert a worksheet row, but the result depends on how formulas and workbook features are set up. Check key formulas, totals, charts, and reports after the change.

How do I add a row inside a formatted table?
Right-click a cell in the table row that should move down and choose Insert > Table Rows Above. This adds a record within the table and is preferable to inserting an unrelated row outside it.

Can I insert a row in Excel for the web?
Yes. Select the row heading, then use the right-click menu’s Insert Rows command or the Insert command on the Home tab. The web version supports row insertion, though keyboard shortcuts can vary by browser.

Can I insert a row without moving the data below it?
No. Inserting a worksheet row creates space by shifting existing rows downward. If you need to rearrange data without shifting the rest of the sheet, move or sort the relevant records instead, taking care not to separate related columns.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.