Excel Shortcut to Insert a Row and Shift Cells Down

In Excel for Microsoft 365 on Windows, select the cell where the new space should begin and press Ctrl+Shift+= (the plus shortcut); in the Insert dialog, choose Shift cells down and select OK. To insert a whole worksheet row instead, select its row number first and use the same shortcut; Excel inserts a row above it.

What the shortcut does

The shortcut opens Excel’s Insert dialog when you have selected a cell or cell range. The dialog lets you decide whether to move nearby cells down, move them right, or insert an entire row or column. Choosing Shift cells down inserts cells only in the selected columns, moving existing cells beneath the selection downward to make room. It does not necessarily insert a complete worksheet row.

That distinction matters when your worksheet contains records arranged in rows. If a record has a name in column A, a date in B, and an amount in C, inserting cells only in column B can misalign the records: dates move down while names and amounts remain in place. In that situation, insert a whole row instead. Use Shift cells down when you specifically want to make room in only one column or a selected group of columns.

Insert cells and shift them down step by step

Click the cell where the new cell should appear. Excel will insert above that cell and move existing cells below it down.
Press Ctrl+Shift+=. On many keyboards, this means holding Ctrl and Shift and pressing the equals key, which also types a plus sign.
In the Insert dialog, select Shift cells down.
Select OK or press Enter to complete the insertion.

For example, if you select B5 and choose Shift cells down, Excel inserts a cell at B5 and moves the existing cells in column B from B5 downward by one position. Cells in column A and column C do not move. If you select B5:D5 first, the inserted area spans those three columns, and the corresponding existing cells shift down.

You can also open the dialog without a keyboard shortcut: select the cell or range, go to Home > Insert > Insert Cells, choose Shift cells down, and confirm. This is useful when the plus-key shortcut behaves differently because of your keyboard layout or another application intercepting it.

Insert an entire worksheet row instead

To preserve the alignment of records spread across several columns, insert a full worksheet row. Click the row number at the left edge of the grid to select the row, then press Ctrl+Shift+=. Excel places a new row above the selected row. The existing row and the rows below it move down together, so values across the worksheet remain on their original records.

Another option is to right-click a row number and choose Insert. You can also select a row and use Home > Insert > Insert Sheet Rows. If you select several row numbers before inserting, Excel inserts the same number of rows above the selection. For instance, selecting rows 8 and 9 and inserting adds two rows above row 8.

Excel does not normally make room below the last worksheet row: a worksheet has a fixed row limit. If inserting would push nonempty cells beyond that limit, Excel displays an error. Review the data near the bottom of the sheet and remove or move unnecessary content before trying again.

How to choose between shifting cells and inserting a row

Choose the option that keeps the worksheet’s data structure intact. A worksheet row is usually the right choice when each row represents one complete item, transaction, person, or date. Shifting cells down is appropriate when the affected columns are intended to move independently, such as adding a missing entry to a single-column list.

Choose Shift cells down to add space in a selected cell or set of columns without moving neighboring columns.
Choose an entire worksheet row when the new record needs space across the sheet and values in each row belong together.
Choose a table row when the data is inside an Excel table, so the new record remains part of the table’s structured range.

Before inserting into a worksheet with formulas, totals, merged cells, or data in nearby columns, check what will move. Excel adjusts many formula references when cells are inserted, but a formula that depends on the worksheet’s layout may still need review. Inserting cells into just one column can also leave neighboring values out of step even when the formulas themselves update correctly.

Using the shortcut on different keyboards and platforms

On Windows, the standard shortcut for inserting cells is Ctrl+Shift+=, often described as Ctrl plus the plus key. On a keyboard with a separate numeric keypad plus key, the plus key may be easier to use. Keyboard layouts differ, so if the shortcut does not open the dialog, use Home > Insert > Insert Cells instead.

In Excel for Mac, the corresponding insert-cells shortcut is generally Control+Shift+=. The exact key combination can depend on the keyboard layout and macOS or application shortcuts, so the ribbon command is a reliable alternative: choose Home > Insert > Insert Cells, then select the desired direction. Excel for the web also provides insertion commands on the Home tab and through the cell or row context menu; browser shortcuts can affect keyboard behavior, so use the on-screen command if needed.

These instructions concern Excel, not every spreadsheet application. Google Sheets and other programs may assign different keys or display different insertion options. If you are using a different application, check its own shortcut list rather than assuming Excel’s combination applies.

What changes after cells are inserted

When cells shift down, Excel moves existing cell contents rather than replacing them. Formatting and many formulas move with their cells, and formulas that refer to affected cells are generally adjusted to reflect the insertion. However, the result depends on the range selected and the references used. A formula outside the shifted area may update differently from a formula that is moved along with the cells.

For example, suppose column B contains a list of due dates and column C contains corresponding task names. Inserting a cell and shifting down only column B adds a space in the date list, but it does not move the task names. If each date belongs to the task beside it, insert a complete row or add a table row instead. This is a common source of apparent data errors: the shortcut works as requested, but the chosen insertion scope does not match the layout.

Excel may also show an insertion-options button near the edited area. Depending on the operation, it can offer choices about how the inserted cells are formatted. Check the result if the surrounding cells use special borders, number formats, or conditional formatting.

Inserting a row in an Excel table

An Excel table is a structured range with its own headers and behaviors. When adding a record inside a table, use the table’s row-insertion command rather than shifting individual cells in the middle of the table. Right-click a cell in the table row that should move down and choose Insert > Table Rows Above, when that option is available. This adds a row across the table, keeping its columns together and extending the table range.

You can also type into the row immediately below a table to extend it in many common situations, or use the table’s last cell and press Tab to create a new row at the bottom. These methods are convenient for adding records, but they are not the same as inserting a cell and choosing Shift cells down. If a table is filtered, confirm which row is selected and where the new row appears; filters can make the visible sequence differ from the underlying worksheet row numbers.

Common shortcut problems and fixes

The Insert dialog does not appear: Confirm that Excel is active and that the selected area is a worksheet cell or row. Try the ribbon command, which avoids key-layout differences.
Excel inserts a full row instead of shifting only cells: You may have selected the row number, not a cell. Select a cell or range to access the direction choices in the Insert dialog.
Values no longer line up: Undo immediately with Ctrl+Z if appropriate, then reinsert using a full row or a table row. Check that related fields move together.
Excel reports that it cannot insert cells: The operation may push existing content beyond the worksheet’s row or column limit. Locate and clear or relocate unnecessary data at the far edge of the sheet.
The command is unavailable or behaves unexpectedly in a table: Use the table-specific row insertion command, or check whether the sheet is protected and whether you have permission to edit it.

After any insertion, scan the nearby rows and columns, especially if they contain formulas, totals, merged cells, or filtered data. If the change was accidental, press Ctrl+Z on Windows or Command+Z on Mac promptly. Undo is most dependable immediately after the insertion; performing more edits first can make it harder to return to the intended state.

Frequently Asked Questions

What is the Excel shortcut to insert cells and shift them down?

On Windows, select the cell or range and press Ctrl+Shift+=. In the Insert dialog, choose Shift cells down and confirm. This shifts cells only in the selected columns, rather than adding a complete worksheet row.

How do I insert a whole row with the keyboard?

Select the row number at the left of the worksheet and press Ctrl+Shift+= on Windows. Excel inserts a new worksheet row above the selected row. You can also right-click the row number and select Insert.

How do I insert a row without overwriting data?

Use the insert command rather than typing into a cell that already contains data. Select a whole row if the record spans multiple columns, or use Shift cells down for a limited range. Existing cells in the affected area move to make room.

Why does Excel ask whether to shift cells down or right?

Excel needs to know how to make room for the new cells. Choose Shift cells down to move cells below the selected area, Shift cells right to move cells to its right, or select an entire row or column when you want a worksheet-wide insertion.

Does Ctrl+Shift+= work in Excel for Mac?

Excel for Mac generally uses Control+Shift+= for inserting cells, but keyboard layouts and system shortcuts can affect the combination. If it does not open the dialog, use Home > Insert > Insert Cells and choose the insertion direction.

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.