Excel Shortcut to Insert Cells Down: Keyboard Steps

In Excel for Microsoft 365 on Windows, select the cell or range where you want space, then press Ctrl+Shift+Plus to open the Insert dialog; choose Shift cells down and confirm. On most keyboards, the plus sign is typed with Ctrl+Shift+=, while a numeric keypad may have a separate Plus key.

What the shortcut does

The shortcut opens Excel’s Insert dialog; it does not automatically choose the downward shift. The dialog lets you decide how the new space is made: existing cells can move right, move down, or make room for an entire row or column. That choice matters because shifting only some cells can leave neighboring data where it was.

When you choose Shift cells down, Excel inserts cells in the selected area and moves the existing cells below it downward by the same number of rows. For one selected cell, the shift affects that cell’s column. For a selected block, Excel shifts the block’s columns down within the selected width. It does not necessarily move every value across the worksheet, as inserting a whole row would.

Think of the command as creating space in a particular part of the grid, rather than adding a new worksheet or simply moving the selected value. Excel’s worksheet dimensions remain fixed; the command rearranges the cells that are already there.

Steps to insert cells and shift them down

Click the cell where the new blank space should begin. To insert several cells at once, select a matching-size range. For example, select A4:A6 to make room for three cells in column A.
Press Ctrl+Shift+Plus. On a standard keyboard without a dedicated plus key, hold Ctrl and Shift and press the equals key (=), which produces the plus sign. On a numeric keypad, Ctrl+Plus may work without Shift.
In the Insert dialog, choose Shift cells down. Check the choice rather than assuming Excel selected the direction you intended.
Press Enter or click OK. The selected cells become blank, and cells below them in the affected columns move down.

You can also open the same dialog from the ribbon: Home > Insert > Insert Cells. The Insert drop-down is in the Cells group. Another route is to right-click the selected cell or range and choose Insert, then select Shift cells down in the dialog.

Choose the right selection and direction

The selection determines the size and location of the space Excel creates. Selecting one cell inserts one cell; selecting a vertical range inserts that many cells down in the selected columns. A rectangular selection can be useful when a small block of related values needs room, but it also makes it easier to disrupt the alignment of nearby columns.

Before confirming, ask whether adjacent information belongs together. If each row represents a person, order, or transaction, shifting cells in just one column can separate a value from the rest of its record. In that case, insert a whole row instead. If you are making room for a new field across all records, inserting a whole column may be more appropriate.

Choose Shift cells down when only the selected column or block needs extra vertical space.
Choose Shift cells right when the new space belongs within a row and the cells to its right should move.
Choose Entire row when all data across the worksheet needs to move down together.
Choose Entire column when all data to the right needs to move together.

For example, if a worksheet has dates in column A, names in B, and amounts in C, inserting a cell only in B can misalign the names with their dates and amounts. Inserting a complete row keeps each existing record intact while opening a row for a new record.

Insert a whole row or column instead

When you need to preserve row or column alignment, select the entire row or column before using the insert shortcut. On Windows, click a row number or press Shift+Space to select the current row, then press Ctrl+Shift+Plus. To select a column, click its letter or press Ctrl+Space, then use Ctrl+Shift+Plus. Excel inserts a full row above the selected row or a full column to the left of the selected column.

This is different from selecting one cell and choosing Shift cells down. The cell method affects only the selected width; a full-row insertion moves the worksheet’s content across the row together. A full-column insertion similarly moves content in the columns to the right. Selecting the whole row or column first is a practical way to avoid choosing the wrong radio option in the Insert dialog.

Concrete examples

Suppose a list of product codes occupies A2:A10 and you need two blank positions before the current entry in A5, without shifting columns B and C. Select A5:A6, press Ctrl+Shift+Plus, choose Shift cells down, and confirm. The former values in A5:A10 move down two positions; the cells A5:A6 are blank. Other columns remain in place, so use this approach only if those columns do not need to stay aligned with the moved codes.

For a new transaction in a table-like list with dates, customer names, and totals in columns A through C, select the row number for the first existing transaction and insert an entire row. That moves the existing records down together. If the data is formatted as an Excel Table, adding a row within the table is usually preferable to inserting a cell into just one table column, because the table’s columns are designed to keep each record together.

After an insertion, review formulas that refer to the affected area. Excel commonly adjusts cell references when cells are inserted, but formulas built from text references, such as those using INDIRECT, may not respond in the same way. Check important totals and lookups rather than assuming every dependent calculation has the intended meaning.

Common problems and how to fix them

The dialog does not appear. Confirm that Excel has focus and that you used the plus key combination, not just Ctrl+Shift without the key. Keyboard layouts differ, so the physical key that produces a plus sign may vary. Try Ctrl+Shift+= on a typical US keyboard, or use Home > Insert > Insert Cells.

The wrong cells moved. Undo immediately with Ctrl+Z, then inspect the selection before trying again. A single-cell selection shifts only one column when you choose Shift cells down. If the entire record must move, select a row instead of one cell.

Excel will not insert the cells. A worksheet cannot shift existing content beyond its bottom or right edge. If cells are occupied at the edge of the sheet, Excel may refuse the operation because that content would have nowhere to go. Review the far end of the affected columns or rows and remove or relocate content only if it is genuinely unnecessary.

The new cells have unexpected formatting. Excel may carry formatting from nearby cells into inserted cells. After insertion, look for the Insert Options button near the new cells; where available, it lets you choose how formatting is applied. You can also use the Format Painter or cell-format controls to make the new area match its intended use.

Undo seems unavailable after another action. Ctrl+Z reverses the most recent undoable worksheet action, so use it promptly if an insertion was accidental. If you have already made other changes, review the results carefully before undoing, because Ctrl+Z may reverse those later actions first.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. In Excel for Mac, the cell-insertion shortcut is generally Control+Shift+Plus; the exact key can depend on the keyboard layout. If the shortcut behaves differently on your Mac, use the menu or ribbon command to open Insert Cells, then select Shift cells down. The Control key is important here; do not assume that substituting Command will produce the same shortcut.

Excel for the web may handle keyboard combinations differently depending on the browser and its own shortcuts. If Ctrl+Shift+Plus is intercepted or does not open the Insert dialog, select the target cells and use Home > Insert > Insert Cells, or use the right-click Insert command. The dialog’s shift-direction choice is the same concept: choose Shift cells down when only the selected area should create vertical space.

Alternatives to inserting cells

If the goal is to place a new record in a structured list, add a table row or insert a worksheet row rather than shifting a single cell. This keeps associated fields together and is less likely to create mismatched data. If the goal is simply to move an existing value, cut and paste may be more suitable than inserting blank space, but check formulas and references after moving important data.

For a small manual change, the Insert dialog is direct and reversible. For a large reorganization, sort or restructure the data deliberately instead of repeatedly inserting individual cells. Whatever method you choose, save a copy before making broad changes to an important workbook, and verify a few representative rows afterward.

Frequently Asked Questions

What is the shortcut to insert a cell down in Excel?
On Windows, select the cell or range and press Ctrl+Shift+Plus to open the Insert dialog. Choose Shift cells down and confirm. On many keyboards, the plus combination is Ctrl+Shift+=.

Does Ctrl+Shift+Plus automatically shift cells down?
No. It opens the Insert dialog, where you choose among shifting cells down, shifting them right, or inserting a whole row or column. Check the selected option before confirming.

How do I insert a whole row with the keyboard?
Select a cell in the row, press Shift+Space to select the row, then press Ctrl+Shift+Plus on Windows. Excel inserts a row above the selected row.

What is the Mac shortcut to insert cells?
Excel for Mac generally uses Control+Shift+Plus to open the insertion command. Keyboard layouts can affect the key combination, so use the Insert Cells command from the menu or ribbon if needed.

How do I undo an inserted cell?
Press Ctrl+Z on Windows, or use Undo from Excel’s toolbar. Undo promptly, especially if you have made other changes since the insertion, because Excel reverses actions in sequence.

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.