How to Move Everything Down a Row in Excel Safely

To move everything on a worksheet down by one row in Excel for Microsoft 365 on Windows, select the row 1 header, then choose Home > Insert > Insert Sheet Rows. Excel adds a blank row at the top and shifts the existing cell contents down without replacing them. Save a copy first if the workbook is important, and check whether you mean the whole sheet or only a particular range.

What You’ll Need

An Excel workbook that you can edit. If it is read-only or protected, you may need permission to make changes or to unprotect the sheet first.
A clear idea of the area you want to shift: one entire worksheet, selected rows, or only cells in a particular column or range. The steps below cover the whole worksheet.
A saved backup or duplicate of the workbook if the sheet contains important formulas, tables, merged cells, or carefully arranged formatting.

Step-by-Step

Open the correct worksheet. If your workbook has several sheet tabs, click the tab you intend to change. Inserting a row this way affects the active worksheet, not every worksheet in the workbook. If you need the same change on multiple sheets, you will need to repeat it for each one, or carefully group the sheets before making the change.
Check what is currently in row 1. Look across the top row and note whether it contains headings, data, a table header, merged cells, or anything you need to preserve. Inserting a row does not erase the old row 1; it moves it down to row 2. If row 1 is already blank, the operation will create another blank row above it.
Select the entire first row. Click the row number 1 at the far left of the worksheet. The whole row should become highlighted. Selecting the row header is important: selecting just cell A1 would insert a cell or cells, depending on the command, rather than reliably inserting a full worksheet row.
Insert a sheet row above it. On the Windows ribbon, choose Home > Insert > Insert Sheet Rows. Excel inserts a new blank row above the selected row. The former row 1 moves to row 2, former row 2 moves to row 3, and the remaining worksheet cells below move down by one row.
Use the shortcut if you prefer. With the entire row selected, press Ctrl+Shift++ on Windows. On many keyboards, the plus sign is entered with the equals key, so the keystroke is Ctrl+Shift+=. If your keyboard layout makes that awkward, use the ribbon command or right-click the selected row number and choose Insert. On Mac, use the row-header context menu or the Home > Insert ribbon command; shortcuts can vary by keyboard layout and Excel version.
Confirm that the shift did what you wanted. Check the first few rows and a few columns farther to the right, not just column A. Confirm that the old row 1 now appears on row 2 and that the new row 1 is empty. If your worksheet has content far below the visible area, scroll down to spot-check it too.
Review formulas and references. Excel generally adjusts cell references when rows are inserted, but the result depends on how each formula refers to the affected cells. Look at formulas that use row numbers, ranges, named ranges, or data from the shifted area. If another worksheet or workbook refers to this sheet, check those dependent results as well.
Check layout features and save. Inspect tables, filters, conditional formatting, print areas, freeze panes, and charts or shapes that sit over the cells. If the result is correct, press Ctrl+S on Windows to save. If it is not, immediately use Ctrl+Z to undo the insertion, then try again with the correct selection.

The key point is to select the row number, rather than a single cell, before inserting. Excel then inserts a complete worksheet row and shifts the cells below it down. The new row is blank, but its appearance may inherit formatting from nearby rows, so an empty-looking row is not always completely unformatted.

In Excel for the web, select the row number and use the insert-row command on the Home tab or in the row’s context menu. The wording or arrangement can differ slightly from desktop Excel, but choosing an entire row before inserting is still the important part. On Mac, the same selection principle applies; the ribbon or row-header context menu avoids relying on a keyboard shortcut that may differ with the keyboard layout.

Common Mistakes

Selecting A1 instead of the row header. If you select a cell and choose an insert-cells command, Excel may ask whether to shift cells right or down. That affects only part of the grid and can misalign data. Click the number 1 at the left edge to select the full row before inserting.
Assuming the change applies to every sheet. A normal row insertion changes only the active sheet. If multiple worksheets need a blank first row, repeat the operation on each one. Grouping sheets can apply changes to several at once, but it is easy to leave sheets grouped and accidentally edit them together afterward.
Using Cut and Paste instead of Insert. Cutting row 1 and pasting it into row 2 does not create space in the same reliable way as inserting a worksheet row; it may replace existing cells or move only the selected contents. Use Insert Sheet Rows when the goal is to preserve the existing grid and shift it down.
Shifting only one column by accident. Inserting cells in column A and choosing “Shift cells down” moves that column’s entries but leaves neighboring columns in place. Names, dates, and amounts can then become mismatched. Use a full row insertion when those columns belong together.
Forgetting formulas and external links. Inserting a row can affect formulas, chart sources, named ranges, and references from other sheets. Excel adjusts many ordinary references automatically, but that does not guarantee every dependent calculation or external connection behaves as intended. Review the workbook after inserting.
Overlooking objects or special layouts. Pictures, shapes, merged cells, tables, and print settings may not behave like ordinary cells. An object can be set to move with cells, move but not resize, or remain fixed on the sheet. Inspect those elements rather than assuming every visual item moved exactly one row.

Tips

Make a reversible copy. For a high-value workbook, use File > Save As to create a separate working copy before changing the layout. Undo is helpful, but a saved copy is a better safeguard if you make other edits afterward or close the file.
Use a full-row selection for a sheet-wide shift. Click row 1’s header, or drag across multiple row headers if you want to add more than one blank row. Selecting two row headers and inserting adds two rows above the first selected row.
Keep related data together. If the worksheet contains a dataset with headers, formulas, and records, insert a complete worksheet row rather than shifting only some columns. This maintains the alignment between fields.
Consider tables separately. If the range is an Excel table, check where the table begins and whether the new row should be part of the table. Inserting a worksheet row above a table can leave the added row outside the table, so its filters, structured references, and table formatting may not include the new row automatically.
Check the bottom of the sheet if it is full. Excel worksheets have a fixed row limit. If data already reaches the last available row, Excel cannot shift all of it down by another row. You may need to remove or move data near the bottom before inserting.
Inspect the changed area, not just the blank row. Compare the old first few records with their new positions. This quickly reveals whether formulas, formatting, and adjacent columns remained aligned.

Troubleshooting

The Insert command is unavailable. The worksheet may be protected, the workbook may be read-only, or Excel may be in a state that prevents editing. Check the title bar and permissions, and, if appropriate, use Review > Unprotect Sheet. A password-protected sheet requires the password or help from the workbook owner; do not try to bypass protection.

Excel asks how to shift cells. You likely selected a cell or range rather than the row header. Cancel the prompt, click the row number at the left, and use Insert Sheet Rows. If you intentionally want to move only part of the sheet, choose the cell-shift direction only after confirming that the neighboring columns should remain in place.

Only one column moved, or columns no longer line up. Undo right away with Ctrl+Z on Windows, then select the complete row and insert again. If you have made additional changes since the insertion, undo may also reverse those changes, so check the workbook before saving.

The worksheet seems unchanged. Make sure the intended sheet tab is active and that the new row is at the top. The inserted blank row may have formatting that makes it look like the former row, and a frozen top row can affect what appears while scrolling. Click a cell in row 1 and check the formula bar or temporarily inspect its formatting to distinguish the blank row from the shifted content.

A formula result or reference changed unexpectedly. Inspect the formula and its referenced cells, then compare the result with the expected calculation. Undo if necessary and consider whether the formula used a fixed reference, a named range, an external link, or a range that should have included the new row. Avoid manually changing references until you understand which cells the formula is intended to use.

Excel will not insert a row because of the sheet limit. Find whether the worksheet contains content or formatting at the bottom row. If it does, remove or relocate material you no longer need, save a backup, and retry. Clearing visible text may not always remove all used formatting, so check the last rows and columns as well.

Frequently Asked Questions

Does inserting a row at the top move all my data down?
It moves the worksheet cells below the insertion point down one row, including blank cells and ordinary cell contents. It does not mean that every chart, picture, print setting, or other object will necessarily reposition in the same way, so inspect those separately.

How do I move everything down two or more rows?
Select the same number of row headers starting at row 1, then choose Home > Insert > Insert Sheet Rows. For example, select rows 1 and 2 to create two blank rows at the top and shift the existing contents down by two rows.

Can I move everything down in only one column?
Yes, but that is a different operation. Select the cells in that column and use the insert-cells option to shift cells down. Do this only when the adjacent columns should stay put; otherwise, the records may no longer match across columns.

Will my formulas update after I insert the row?
Excel adjusts many standard cell references when rows are inserted, but formulas involving fixed references, names, external workbooks, or specialized layouts need checking. Review key formula results and any charts or summaries that use the shifted data.

Can I do this on every worksheet at once?
You can repeat the insertion on each sheet. Excel also lets you group selected sheet tabs and make some edits across grouped sheets, but use that carefully: confirm that the sheets have matching layouts, then ungroup them when finished so later changes do not affect all grouped sheets.

How do I undo moving everything down?
Immediately press Ctrl+Z on Windows, or use the Undo button on the Quick Access Toolbar. On Mac, use Command+Z. Undo restores the prior layout if the insertion is still in the undo history; if you have saved, closed, or made many later edits, restore from a backup if needed.

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.