Insert a Row Below in Excel: Steps, Shortcuts, and Fixes

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select the row immediately below where you want the new one, then choose Home > Insert > Insert Sheet Rows; Excel inserts the row above your selection, which puts it below the row you chose as your target. You can also right-click the lower row’s number and choose Insert.

How Excel places an inserted row

Excel inserts a worksheet row above the selected row, not below it. That is why the simplest way to insert below a particular row is to select the next row down first. For example, to add a blank row between rows 6 and 7, select row 7 and insert a sheet row. The old row 7 moves down, and the new blank row occupies position 7.

To select a whole row, click its number in the gray row-heading strip at the left of the worksheet. The selection should extend across the sheet. If you select only a cell, Excel may insert a cell or open an Insert dialog instead of inserting an entire worksheet row. Choosing the row heading avoids that ambiguity.

Rows are numbered on the left, while columns are lettered across the top. The same principle applies wherever you are working in a worksheet: choose the row immediately below the intended insertion point. If you mean “below” a particular cell within a table rather than across the entire worksheet, see the table-specific instructions below.

Three ways to insert a worksheet row

Use whichever method suits your workflow. Each of these methods inserts a whole worksheet row when a row heading is selected:

  • Ribbon: Select the row below the desired position, then choose Home > Insert > Insert Sheet Rows.
  • Right-click: Right-click the heading of the row below the desired position and choose Insert. If you right-click a cell rather than a row heading, Excel may offer cell-specific insertion choices instead.
  • Keyboard: Select the row heading and press Ctrl+Shift++ on Windows. On many keyboards, the plus sign is entered with the equals key, so the keystroke is Ctrl+Shift+=. If Excel displays an Insert dialog because only cells are selected, choose the option to insert an entire row.

The ribbon is easy to identify and works well when you are learning the process. Right-clicking is often quicker when the row numbers are visible. The keyboard shortcut can be fastest for repeated edits, but its exact key feel depends on the keyboard layout. On a Mac, the Windows shortcut may not apply; use the row-heading context menu or the Insert command on the ribbon, and check Excel’s shortcut listing for your keyboard and version.

Insert a row inside an Excel table

An Excel table is a structured data range with its own header row, filters, and table formatting. When you insert a row within a table, Excel can extend the table and its formatting rather than treating the change as an unrelated blank worksheet row. Click in the table row below the intended insertion point, open the context menu, and look for the table-row insertion option, such as Insert or Insert Table Rows Above. The wording can vary with the selection and Excel version.

To add a new record at the end of a table, another convenient method is to click the last cell in the final table row and press Tab. Excel moves to a new row and expands the table. This is useful when entering records consecutively, but it is not the same as inserting a row in the middle: use the table’s insertion command when the new record belongs between existing records.

Table rows are different from worksheet rows. An inserted table row adds space to the table, while a whole-sheet row shifts cells across all columns at that position. If the surrounding worksheet contains other data, consider which behavior you need before inserting. A table-specific row is usually appropriate for adding a record to the table without intending to create a blank row across the entire worksheet.

What happens to data, formulas, and formatting

Inserting a full worksheet row shifts existing cells below the insertion point downward. It does not normally overwrite the contents that were already in those rows. However, it affects the whole width of the worksheet, so data in other columns moves too. Before inserting, check whether unrelated information to the right of your main dataset shares those same rows.

Excel generally adjusts formula references when cells are moved by an insertion. For instance, a total that refers to a range may expand or change references to keep pointing at the intended data, depending on where the new row is added and how the formula is constructed. Do not assume every formula will produce the intended result automatically: inspect important totals, charts, named ranges, and formulas that use fixed references after a structural change.

Formatting may also be carried into the new row from neighboring rows, especially when the new row is inserted within a formatted region or table. The result can depend on the surrounding cells and worksheet settings. If the new row has unwanted formatting, use the Insert Options button that appears after insertion, if available, or use Home > Clear > Clear Formats on the selected row. Clearing formats removes visual formatting, so avoid that command if the row contains formatting you need to keep.

Choosing between a whole row and inserted cells

Use a whole worksheet row when every column below the insertion point should move down together. This is the usual choice for adding a record to a simple list whose columns all belong to the same records. For example, if a sales list uses columns A through F, inserting a whole row keeps the entries in those columns aligned as the rows shift.

Use inserted cells only when you deliberately want to move part of a worksheet and leave other columns in place. Selecting a cell and choosing Home > Insert may open a dialog with choices such as shifting cells down or shifting cells right. Shifting only some cells can break the alignment between related fields. If a row represents one complete record, inserting just a few cells is usually the wrong choice.

There is also a difference between a blank worksheet row and a blank table row. The first creates space across the worksheet; the second adds space to a table’s data region. When working with several adjacent lists on one sheet, decide whether you want to move all of them or only the table before choosing the command.

Common problems and how to fix them

  • The row appeared in the wrong place: Excel inserts above the selected row. Undo with Ctrl+Z on Windows, then select the row below the intended position and insert again.
  • Only a cell or a few cells moved: Select the row number rather than an individual cell, then use Insert Sheet Rows. This makes the operation apply to the complete worksheet row.
  • Excel will not insert the row: The worksheet may be protected, or the insertion could push existing data beyond the worksheet’s limit. Check Review > Unprotect Sheet if you have permission to unprotect it. A worksheet has 1,048,576 rows, so there is no row below the final row into which Excel can insert another.
  • The new row looks different: Excel may have copied formatting from neighboring cells. Review the Insert Options button or adjust the formatting afterward.
  • Filters or hidden rows make the position confusing: A filtered or hidden row can affect what you see, but the worksheet still has row numbers and positions. Confirm the selected row heading before inserting, especially if the visible rows are not consecutive.

For a protected sheet, the available actions depend on the protection settings. If you cannot change them, ask the workbook owner rather than trying to work around the protection. If the sheet is shared or several people are editing it, communicate the structural change so collaborators can account for rows moving.

Excel for Mac and Excel for the web

The basic rule is the same in Excel for Mac: insert above the selected row to create a row below the row you have in mind. Select the row heading, then use the Insert command on the ribbon or the row’s context menu. Keyboard shortcuts can differ from Windows and may also depend on the keyboard layout, so the menu method is the dependable alternative when a shortcut does not work as expected.

In Excel for the web, select the row heading and use the available Insert command from the ribbon or context menu. The interface may place commands differently from the Windows desktop app, and browser keyboard shortcuts can conflict with Excel shortcuts. If a shortcut is intercepted or behaves differently, use the visible menu command. Excel for the web supports inserting worksheet rows, but some workbook features and editing behaviors can vary from the desktop application.

Frequently Asked Questions

Can I insert a row below without moving the rows above it?
Yes. Select the row immediately below the place where the new row should go, then insert a sheet row. Rows above the insertion point stay where they are; rows at and below the selected row move down.

What is the shortcut to insert a row in Excel?
On Windows, select a row heading and press Ctrl+Shift++ (often typed as Ctrl+Shift+=). If you select a cell instead, Excel may show an Insert dialog. On Mac or with another keyboard layout, use the ribbon or context menu if the shortcut differs.

Can I add a row at the bottom of an Excel table?
Yes. You can enter data in the row directly below the table and Excel may expand the table as you type, depending on the surrounding data and settings. You can also press Tab from the last cell of the table’s final row to create a new table row.

Will inserting a row change my formulas?
Excel adjusts many references when rows are inserted, but the outcome depends on the formula and where the row is added. Check important calculations, charts, and references after inserting, particularly if formulas use fixed ranges or the worksheet has complex layouts.

Why is Insert unavailable in my worksheet?
The sheet may be protected, or the insertion may exceed the worksheet’s row limit. Check whether the workbook owner has protected the sheet and whether you have permission to change it. Excel worksheets support up to 1,048,576 rows.

Related

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.