Insert and Delete Cells in Excel: A How-To

This guide shows you how to insert and delete cells in Microsoft Excel, shifting existing data to make room or close gaps without disturbing the rest of your worksheet. You’ll learn the exact menu steps, keyboard shortcuts, and what to watch out for when you change the layout of your data.

What You’ll Need

• A computer with Microsoft Excel installed (2016, 2019, 2021, or Microsoft 365).
• An existing worksheet with data in it, so you can practice inserting and deleting cells.
• Basic familiarity with selecting cells and ranges in Excel.

Step-by-Step

Inserting Cells

1. Select the cell or range where you want the new cells to appear. For example, if you want to insert a single cell at B2, click on B2. To insert multiple cells, select the same number of cells as you want to add (e.g., select 3 cells to insert 3 new cells).
2. Right-click the selected cell(s) to open the context menu.
3. Choose “Insert…” from the menu. (If you selected an entire row or column, you’ll see “Insert” without the ellipsis; that’s fine too.)
4. In the Insert dialog box, pick one of these options:
   • Shift cells right – moves the selected cells and everything to their right one column to the right.
   • Shift cells down – moves the selected cells and everything below them one row down.
   • Entire row – inserts a full row above the selected cell(s).
   • Entire column – inserts a full column to the left of the selected cell(s).
5. Click OK to apply the insertion. Your new cells are now in place, and the existing data has shifted as you chose.

Keyboard shortcut: Select the cell(s), press Ctrl + Shift + + (plus sign). The same Insert dialog appears.

Deleting Cells

1. Select the cell or range you want to remove. For example, click on C3 to delete that single cell, or drag to select a range like C3:D5.
2. Right-click the selected cell(s) and choose “Delete…” from the context menu.
3. In the Delete dialog box, choose one of these options:
   • Shift cells left – moves the cells to the right of the deleted ones one column to the left.
   • Shift cells up – moves the cells below the deleted ones one row up.
   • Entire row – deletes the entire row(s) containing the selected cells.
   • Entire column – deletes the entire column(s) containing the selected cells.
4. Click OK to delete the cells. The surrounding data fills the gap as you specified.

Keyboard shortcut: Select the cell(s), press Ctrl + - (minus sign) to open the Delete dialog.

Inserting or Deleting Entire Rows or Columns (Quick Method)

1. Right-click on the row number (e.g., 4) or column letter (e.g., C) in the header.
2. Choose Insert to add a row above or a column to the left, or Delete to remove that row or column entirely.

Common Mistakes

• Choosing the wrong shift direction – If you shift cells right when you meant to shift down, your data will be rearranged incorrectly. Always double-check the option before clicking OK.
• Deleting entire rows/columns by accident – When you right-click a cell and choose Delete, the dialog defaults to “Shift cells up” or “Shift cells left,” but if you accidentally press the wrong key or click the wrong option, you might delete entire rows or columns. Always read the dialog carefully.
• Not selecting enough cells – To insert multiple cells, you must select the exact number you want to add. If you select one cell and try to insert three, Excel only adds one.
• Forgetting about merged cells – Inserting or deleting cells near merged cells can cause errors or unexpected behavior. Unmerge any affected ranges first.

Tips

• Use the keyboard shortcuts – Ctrl + Shift + + for insert and Ctrl + - for delete. They save a lot of time.
• Insert multiple cells at once – Select a range of, say, 3 cells, then use the Insert command. Excel will add 3 new cells in that spot, shifting the existing ones as you choose.
• Use the Ribbon if you prefer menus – On the Home tab, in the Cells group, click the arrow next to “Insert” or “Delete” to see the same options.
• Undo is your friend – If you make a mistake, press Ctrl + Z immediately to revert the action.
• Check formulas after shifting – When you insert or delete cells, Excel automatically adjusts most formulas, but it’s wise to spot-check any that reference the affected area.

Troubleshooting

• “Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet.” – This error appears when you try to insert cells and there is data in the very last row or column. To fix it, delete or clear the data in the last row/column, or move it to a new sheet.
• The Insert/Delete option is grayed out. – This usually means the worksheet is protected. Go to the Review tab and click “Unprotect Sheet” (you may need a password).
• Formulas return errors after inserting/deleting. – Check if any named ranges or formulas reference the cells that shifted. Update the references manually if needed.
• Data disappears after deleting cells. – If you chose “Entire row” or “Entire column” by accident, press Ctrl + Z to undo. If you wanted to delete only the contents, select the cells and press Delete (clear contents) instead of using the Delete command.

Frequently Asked Questions

What is the difference between deleting cells and clearing their contents?

Deleting cells removes the cells themselves and shifts surrounding data to fill the gap. Clearing contents (press Delete or Backspace) only removes the values or text, leaving the empty cells in place.

Can I insert a cell without shifting other cells?

No, inserting a cell always shifts existing cells either right or down. If you want to add data without shifting, you can simply type in an empty cell or use copy/paste.

How do I insert multiple non-adjacent cells at once?

You can select multiple non-adjacent ranges by holding Ctrl while clicking, then use the Insert command. Excel will insert cells for each selected range, but the shift direction applies to all of them.

Why does Excel sometimes insert entire rows instead of just cells?

If you select an entire row or column before using Insert, Excel assumes you want to insert entire rows or columns. To insert only cells, select just the cell range, not the whole row/column.

Will inserting or deleting cells break my formulas?

Excel automatically updates most formulas to reference the new cell locations. However, if a formula references a specific cell that gets deleted, it will return a #REF! error. Always check formulas after making structural changes.

Can I undo an insert or delete after saving?

No, once you save the file, the undo history is cleared. Always double-check your changes before saving, or keep a backup copy of the file.

Related

• Fix Google Pixel 2 Slow WiFi: Step-by-Step Guide
• Chat Heads for WhatsApp, Facebook & Skype: How-To
• Ubuntu Dependency Fix: Install & Repair Guide