What happens when you delete a cell in Excel

When you delete a cell in Excel, the program removes the cell and shifts the remaining cells to fill the gap. You have three choices about which direction they shift: cells below move up, cells to the right move left, or you can delete an entire row or column at once. The choice you make depends on what your spreadsheet looks like and what you're trying to accomplish.

Excel won't let you undo a deletion if you've saved the file and closed it, so take a moment to make sure you're deleting the right thing before you confirm. If you make a mistake right away, press Ctrl+Z (or Cmd+Z on Mac) to undo.

Key Takeaways

  • Right-click a cell and choose "Delete" to remove it; Excel will ask which direction to shift the remaining cells.
  • To delete an entire row or column, right-click the row number or column letter on the left or top edge and select "Delete".
  • Selecting multiple cells, rows, or columns before deleting removes them all at once in the same direction.
  • Pressing Delete clears the contents of a cell but leaves the cell itself in place; right-click and choose "Delete" to remove the cell structure.

Delete a single cell and shift cells up

Click the cell you want to remove. Right-click it and select "Delete" from the menu that appears. A dialog box will open with four options: "Shift cells left", "Shift cells up", "Shift entire row", and "Shift entire column". Choose "Shift cells up" if the cells below should move into the space you're clearing.

This is the most common choice when you've made a mistake in one cell and want to remove it without changing the structure of your columns. The cells directly below the deleted cell will move up one row, and all the data in those cells comes with them.

Delete a single cell and shift cells left

Click the cell you want to remove. Right-click it and select "Delete". When the dialog box opens, choose "Shift cells left". The cells to the right of the deleted cell will move left to fill the gap.

Use this option when you're working with data arranged horizontally (side by side) rather than vertically (stacked). For example, if you have months listed across the top row and you want to remove one month, shifting left keeps the remaining months in the correct order.

Delete an entire row or column

To delete a complete row, click the row number on the far left side of the spreadsheet (the numbers 1, 2, 3, and so on). The entire row will highlight in blue. Right-click the row number and select "Delete". The rows below will shift up automatically.

To delete a complete column, click the column letter at the top (A, B, C, and so on). The entire column will highlight in blue. Right-click the column letter and select "Delete". The columns to the right will shift left automatically.

Deleting a full row or column is faster than deleting individual cells one at a time, and Excel handles the shifting for you without asking which direction.

Delete multiple cells, rows, or columns at once

Click the first cell, row, or column you want to remove. Hold Ctrl (or Cmd on Mac) and click each additional cell, row, or column. They will all highlight. Right-click any of the highlighted items and select "Delete".

If you're deleting multiple cells in a block (not scattered around), you can click the first one, hold Shift, and click the last one to select the entire range at once. This is faster than holding Ctrl and clicking each one individually.

When you delete multiple cells, Excel will ask the same question as before: which direction should the remaining cells shift? Your answer applies to all the cells you selected.

The difference between Delete and Clear Contents

Pressing the Delete key on your keyboard clears what's inside a cell but leaves the cell itself in place. The cell stays empty, but the row and column structure doesn't change. This is useful when you want to erase data without reorganizing your spreadsheet.

Right-clicking and choosing "Delete" removes the cell structure itself and shifts the remaining cells to fill the gap. Use this when you want to actually remove a cell from the spreadsheet, not just empty it. If you only want to erase the contents, press Delete instead of right-clicking.

Undo a deletion if you made a mistake

If you delete something by accident, press Ctrl+Z (or Cmd+Z on Mac) immediately. This will undo the deletion and put the cell, row, or column back where it was. You can undo multiple actions in a row by pressing Ctrl+Z several times.

Undo only works while the file is open. Once you close the spreadsheet without saving, or save it after the deletion, you cannot undo. If you're not sure whether you need something, save a copy of the file before you start deleting, so you have a backup to go back to.

Frequently Asked Questions

What's the difference between deleting a cell and deleting a row?

Deleting a cell removes just that one cell and shifts the surrounding cells to fill the gap. Deleting a row removes the entire row across all columns and shifts all rows below it upward. Use "Delete row" when you want to remove a complete line of data.

Can I delete cells without shifting other cells?

Not with the Delete function. If you want to remove the contents of a cell without changing the structure, press the Delete key instead of right-clicking and choosing "Delete". This clears what's inside but leaves the cell in place.

What happens to formulas when I delete a cell?

If other cells contain formulas that reference the deleted cell, those formulas will show an error (usually #REF!). Before deleting a cell, check whether any formulas depend on it. You can search for references by clicking the cell and looking at the formula bar to see if other cells use it.

Can I delete cells in a protected spreadsheet?

Not unless the spreadsheet owner has allowed it. Protected spreadsheets restrict what you can change. If you try to delete and nothing happens, the sheet is likely protected. Ask the owner to unprotect it or grant you permission to make changes.

How do I delete blank cells and move everything up?

Click each blank cell, right-click, and select "Delete" with "Shift cells up" chosen. If you have many blank cells scattered throughout, select them all at once by holding Ctrl and clicking each one, then right-click and delete them together.