30 Advanced Excel Tips for 2026

Excel Champs / Excel Keyboard Shortcuts / Insert Cell (Excel Shortcut)
By Puneet Gogia (Microsoft MVP)

Insert Cell (Excel Shortcut)

Select the cell where you want the new blank cell, press Ctrl + Shift + +, choose Shift cells down or Shift cells right in the Insert dialog and press Enter. The selected cell and the cells below it (or to its right) move to make room.

Select several cells first to insert that many blank cells in one go. On a keyboard with a numeric keypad, Ctrl + + using the keypad plus does the same; on a laptop the plus sign sits on the = key, which is why you need Shift.

The dialog also offers Entire row and Entire column. If you select a whole row (Shift + Space) or column (Ctrl + Space) before pressing the shortcut, Excel inserts it straight away with no dialog. The ribbon route is Home → Insert → Insert Cells (Alt, H, I, I), and Ctrl + – opens the matching Delete dialog. These keys are for Excel on Windows; Mac shortcuts differ.

If you have copied cells and the dashed border is still showing, the shortcut inserts the copied cells instead of blank ones, so press Esc first. Inside an Excel Table you can’t shift single cells; the shortcut adds table rows or columns instead, so insert loose cells outside the table.

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

While working with data, users sometimes need to insert only a cell instead of adding a whole new row or column, and they can do this using the Insert option.

Like other Excel options and features, users can insert cells both manually with the mouse and with the keyboard shortcut.

Keyboard Shortcut to Insert Cell in Excel

The keyboard shortcut to insert a cell or a range of cells is as mentioned below:

Ctrl + Shift + +

Steps to Insert Cell Using Keyboard Shortcut

  1. First, go to the cell where you want the new blank cell. The cell you select (and the data after it) moves down or to the right to make space.
  2. After that, simply press the “Ctrl + Shift + + (plus)” keys together, and you will get the “Insert” dialog box opened.
  3. Now, choose the direction in which you want to move the data (Shift cells right or Shift cells down) to insert the new cell.
  4. Once selected, press Enter, and you will get the new cell inserted.
insert-dialog-box

Note: If your data is in an Excel table, you can’t insert just a cell inside it; Excel adds a table row or column there instead.

More Ways to Insert Cells

  • Several cells at once: select as many cells as you want to insert (for example, three cells) and use the same shortcut; Excel inserts the same number of blank cells.
  • Numeric keypad: Ctrl + + (the plus key on the numeric keypad) works without Shift.
  • Ribbon keys: press Alt → H → I → I for Home ➜ Insert ➜ Insert Cells.
  • Entire row or column: in the Insert dialog box, choose Entire row or Entire column, or select full rows or columns first so the shortcut inserts them directly without the dialog box.

To delete cells, use Ctrl + – (minus). It opens the Delete dialog box, where you choose to shift the remaining cells left or up.

Frequently Asked Questions

Why do my formulas change after inserting cells?

Formulas that refer to the moved cells update to their new addresses. Formulas that refer to a fixed range, like the sum of A1:A10, may not include the new cell if you insert it outside that range.

Why can’t I insert cells?

The sheet is protected, or the data reaches the last row or column of the worksheet, so Excel can’t push the cells further. Unprotect the sheet or clear the cells at the end of the sheet.

Does inserting cells break merged cells?

Inserting cells that would split a merged cell gives an error. Unmerge the cells first, or insert entire rows or columns instead.

Leave a Comment