Excel Insert Row: How to Shift Cells Down

To insert a row in Excel and shift the existing rows down, select the row header where the new row should go, then choose Home > Insert > Insert Sheet Rows, or right-click the row number and choose Insert. To move only selected cells down, select the cells and choose Home > Insert > Insert Cells > Shift cells down.

What “shift down” means in Excel

Excel offers two related operations that are easy to confuse. Inserting a worksheet row creates a complete blank row across the sheet and moves the rows below it down by one. Inserting cells with the Shift cells down option affects only the selected area: Excel moves those cells down and leaves cells elsewhere in the same rows where they were.

For example, imagine a worksheet where column A contains names, column B contains departments, and column C contains start dates. If you need to add a person between the current second and third records, inserting a whole worksheet row keeps the three fields together and moves the later records down. Shifting just cells in column A could separate a name from its department and date, so that is usually the wrong choice for a normal table of records.

The destination matters: Excel inserts above the selected row or cell. If you select row 5, the new row appears in position 5, and the former row 5 becomes row 6. Excel does not insert below the selection by default.

Insert a whole worksheet row

Use a full-row insertion when the new record needs space across the worksheet, including neighboring columns that may contain related information or formulas. In Excel for Microsoft 365 on Windows, do this:

Click the row number on the left edge of the worksheet where the blank row should appear. The entire row is selected.
On the ribbon, choose Home > Insert > Insert Sheet Rows. Excel adds a blank row above the selected row.
Enter the new information in the blank row. If the row belongs in the middle of a formatted list, check that its number formats, borders, and formulas are appropriate.

You can also right-click the selected row number and choose Insert. Selecting several row headers before using Insert adds the same number of rows as the number selected. For instance, selecting rows 5 and 6, then inserting, adds two rows above row 5.

To add a row at the bottom of a data list, select the row immediately below the last record and insert there. If the data is an Excel Table rather than an ordinary range, you can often type in the first cell directly below the table to extend it, or use the table’s last cell and press Tab to create a new table row. A table row is part of the table structure, so it can inherit table formatting and calculated-column formulas automatically.

Shift selected cells down without inserting a full row

Choose Shift cells down only when the change should be limited to a specific range. This is useful for a small block of data that is independent of the rest of the worksheet, but it can disrupt alignment if other columns contain corresponding information.

Select the cell or range where you need space. The selected range should be the size of the cells you want to move, not necessarily the entire row.
Choose Home > Insert > Insert Cells.
In the Insert dialog box, select Shift cells down and choose OK.

The selected cells and the cells below them in that column or block move down to make room. Cells outside the selected columns do not move. For example, if you select B4:B7 and insert cells shifted down, Excel moves the existing values in column B down within that column. Values in column C stay put. If B and C are two fields belonging to the same records, the records may no longer match.

Right-clicking a selected cell or range and choosing Insert also opens the insertion choices. Depending on the selection, Excel may offer Shift cells right, Shift cells down, Entire row, or Entire column. Read the dialog before confirming; the choice determines what moves.

Keyboard shortcuts for inserting rows

On Windows, select a row by clicking its row number, then press Ctrl+Shift+=. The plus sign is commonly entered as Ctrl+Shift+plus, because the plus key shares the equals key on many keyboards. Excel inserts a row above the selection. Selecting multiple row headers first inserts multiple rows.

Another Windows route is to select the target row and press Ctrl++ if your keyboard has a dedicated plus key. Keyboard layouts differ, so the ribbon or right-click method is a dependable alternative if the shortcut does not work as expected. If you have selected cells rather than an entire row, the shortcut can bring up the Insert dialog, where you choose how to shift cells.

In Excel for Mac, the Home tab’s Insert controls and the row-header context menu are also available. The shortcut depends on the keyboard layout and Excel version; try Control+Shift+= with the row selected, or use the ribbon command if that key combination is intercepted by the system or behaves differently. Do not assume that pressing the plus key alone inserts a row.

What happens to formulas and formatting?

When you insert a full row, Excel generally adjusts references in formulas to account for the inserted space. For instance, a formula that refers to a cell below the insertion point will commonly continue referring to the same underlying data after the rows move. Formulas that calculate a range may expand to include the new row in some circumstances, especially when the row is inserted within the referenced range. The exact result depends on the formula, the location of the insertion, and whether the data is an Excel Table.

Insertion does not mean every new cell will contain the value or formula you intend. A blank inserted worksheet row may inherit formatting from nearby rows, but you should inspect number formats, borders, data validation, conditional formatting, and formulas. In a table, calculated columns typically fill formulas into new table rows; in an ordinary range, you may need to copy a formula or fill it down yourself.

For example, suppose a total in D10 adds values from D2 through D9. Inserting a row inside that set of records can cause Excel to update the referenced range, but inserting a row above or below the range may not make the new row part of the calculation. After inserting, click the total cell and inspect the formula bar if inclusion of the new record matters. Do not rely only on the displayed result, especially if the new row currently contains blanks.

How to choose the right insertion method

Choose based on how the worksheet is organized and what needs to stay together:

Use Insert Sheet Rows when adding a complete record to a conventional worksheet list, or when neighboring columns contain connected information.
Use Shift cells down when you intentionally need to make space in only one column or a compact, independent block.
Use an Excel Table row when the data is already a table and you want its structured formatting, filters, and calculated columns to continue with the new record.
Insert several rows together by selecting the same number of row headers as the number of blank rows needed, then inserting once.

A useful check is to ask whether the values across a row describe one item or event. If they do, move the whole row so the record remains intact. If a worksheet contains unrelated sections side by side, a limited cell shift may be appropriate, but check every neighboring area for alignment and formulas afterward.

Common problems and how to fix them

Excel shifted the wrong cells. If only one column moved when you expected a full row, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the row header and insert a sheet row. Undo is most reliable before you make additional edits.

The Insert command is unavailable. The worksheet may be protected, or the workbook may have restrictions that prevent structural changes. Check Review > Protect Sheet and the workbook’s sharing or protection settings. If you are authorized to edit it, remove the relevant protection using the required password or ask the workbook owner; do not try to bypass protection.

Excel says it cannot insert cells. A worksheet can have content or formatting far below the visible data that makes Excel treat the bottom edge as occupied. Check for stray entries or formatting near the bottom of the sheet, and remove only material you have confirmed is unnecessary. Also consider whether merged cells in the affected area are interfering with the insertion.

Rows appear to be missing after insertion. They may be hidden by a filter or hidden-row setting rather than deleted. Clear or review the filter, and inspect row numbers for gaps. In a filtered list, make sure you understand whether you are changing the table structure or working with visible records only.

The new row does not match nearby formatting. Use the Insert Options button that appears near the inserted row, if available, to choose how formatting is applied. You can also copy a suitable neighboring row and use Paste Special for formats, while taking care not to overwrite existing values or formulas.

Undo, alternatives, and good habits

For an accidental insertion, use Ctrl+Z on Windows or Command+Z on Mac before making unrelated changes. If undo is no longer available, select the inserted row header and use Home > Delete > Delete Sheet Rows, or right-click the row number and choose Delete. Deleting the blank row removes that row and shifts rows below it up; it is not the same as clearing the row’s contents.

Before making a large structural change in an important workbook, save a copy or confirm that the file is saved in a location with version history. This is especially helpful in shared workbooks, reports with long formulas, and sheets with carefully arranged sections. After inserting, verify a few records above and below the change, plus totals, charts, filters, and formulas that depend on the affected range.

If you regularly add records, converting a consistent data range to an Excel Table can make the process simpler. Tables provide built-in filtering and can carry formatting and calculated-column formulas into new records. To make one, select the data and use Insert > Table, confirming whether the first row contains headers. A table is not suitable for every layout, particularly a worksheet designed as a form or report with separate blocks, but it is often a better structure for ongoing lists.

Frequently Asked Questions

How do I insert a row and move everything down in Excel?
Select the row number where the new row belongs, then choose Home > Insert > Insert Sheet Rows. Excel inserts above that row and moves the rows below it down.

How do I shift cells down without moving the whole row?
Select the cells that need to move, choose Home > Insert > Insert Cells, select Shift cells down, and confirm. Check adjacent columns afterward to make sure related data still lines up.

Does Excel insert a row above or below the selected row?
It inserts above. Selecting row 8 and inserting a sheet row places a blank row at position 8; the former row 8 moves to row 9.

Can I insert more than one row at a time?
Yes. Select as many row headers as the number of rows you need, then use Insert Sheet Rows. Selecting three row headers inserts three rows above the first selected row.

Why did my formulas change after I inserted a row?
Excel adjusts many cell references when rows are inserted so formulas can continue to point to the intended cells or ranges. Check the formula bar and the resulting calculation, particularly when the insertion is at the edge of a referenced range.

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.