The fastest way to delete multiple cells at once

To delete multiple cells in Excel, select all the cells you want to remove, right-click, and choose Delete. Excel then asks how you want to shift the remaining data — you can move cells up, move them left, delete the entire row, or delete the entire column. This takes three clicks and works the same way whether you are deleting 2 cells or 200.

The key difference from clearing cells is that deleting actually removes them and shifts everything else to fill the gap. If you only want to erase the contents without moving anything, use Delete key or right-click and choose Clear Contents instead. Deleting is permanent unless you undo when ready with Ctrl+Z.

Key Takeaways

  • Select the cells you want to remove by clicking the first one, holding Shift, and clicking the last one in your range.
  • Right-click and choose Delete to remove cells and shift the remaining data up or left to close the gap.
  • Excel asks you which direction to shift data — choose based on whether your data is arranged in rows or columns.
  • Use Clear Contents instead if you want to erase what is in the cells but keep the empty cells in place.
  • Undo with Ctrl+Z when ready if you delete the wrong cells, because the action cannot be reversed once you close the file.

How to select multiple cells before deleting

The selection method depends on whether your cells are next to each other or scattered across the sheet. For cells in one continuous block, click the first cell, hold Shift, and click the last cell. Excel highlights everything in between. For cells that are not touching, click the first cell, then hold Ctrl and click each additional cell you want to include.

You can also select by clicking and dragging from the first cell to the last. If you need to select an entire row or column, click the row number on the left side or the column letter at the top — the whole row or column turns blue. To select multiple rows or columns at once, click the first one, hold Shift, and click the last one.

What happens when you delete cells versus clearing them

Deleting removes the cells entirely and shifts everything else to fill the space. If you delete cells B2 through B4 in a column, the data that was in B5 moves up to B2, B6 moves to B3, and so on. This is useful when you have a mistake or unwanted entry that you want completely gone, along with the empty space it occupied.

Clearing only erases what is inside the cells but leaves the cells themselves in place. The row or column structure stays the same. Use clearing when you want to remove data but keep your layout intact — for example, if you have a template with specific cells meant to hold information that changes.

Choosing which direction to shift data after deletion

When you right-click and choose Delete, Excel opens a dialog with four options. Shift cells up moves everything below your deleted cells upward to close the gap — use this when you are deleting cells in a column and want the data below to move up. Shift cells left moves everything to the right of your deleted cells leftward — use this for cells in a row.

Delete entire row removes the whole row and shifts all rows below it up by one. Delete entire column removes the whole column and shifts all columns to the right leftward. Choose the option that matches your data layout. If you are unsure, Shift cells up is the most common choice for column-based data.

Deleting cells in a table or named range

If your cells are part of an Excel table, deleting works the same way, but Excel may warn you that you are about to delete table data. Proceed with the deletion if that is what you intend. The table structure adjusts automatically — if you delete a row, the table shrinks by one row.

For named ranges (cells you have given a custom name), deleting the cells does not automatically remove the name itself. The name may then refer to a different location or become invalid. If you use named ranges, check them after a large deletion by going to Formulas tab and clicking Name Manager to see what each name points to now.

Undoing a deletion and recovering data

If you delete cells by mistake, press Ctrl+Z when ready to undo. Excel reverses the deletion and puts the cells back where they were. You can undo multiple times to go back several steps. However, once you close the file without saving, the undo history is lost — there is no way to recover deleted cells after that.

If you realize the mistake after closing the file, check whether your version of Excel has a recovery feature. Some versions keep temporary copies of unsaved work, but this is not may provide. The safest approach is to keep a backup copy of important spreadsheets before making large deletions.

Deleting cells with formulas or linked data

When you delete cells that contain formulas, any other cells that reference those formulas will show a #REF! error. For example, if cell C1 contains the formula =A1+B1 and you delete A1, C1 will display #REF! because the formula no longer has a valid reference. Before deleting, check whether other parts of your spreadsheet depend on the cells you are about to remove.

If you need to delete data but keep formulas working, consider clearing the contents instead of deleting the cells. This leaves the cell structure in place so formulas do not break. Alternatively, update the formulas first to reference different cells, then delete the original ones.

Frequently Asked Questions

Can I delete multiple non-adjacent cells at once?

Yes. Hold Ctrl and click each cell you want to delete, then right-click and choose Delete. Excel will delete all selected cells and shift the remaining data. However, the shift direction may not work as expected with scattered cells, so test this on a copy first if your data layout is complex.

What is the difference between Delete and Delete Sheet?

Delete removes individual cells and shifts data to fill the gap. Delete Sheet removes an entire worksheet tab from the workbook. Right-click a sheet tab at the bottom to access Delete Sheet. Deleting a sheet removes all data on that sheet permanently.

How do I delete cells without shifting other data?

Use Clear Contents instead of Delete. Right-click the cells and choose Clear Contents, or select the cells and press the Delete key. This erases what is inside but leaves the cells in place so nothing shifts.

Will deleting cells affect my formulas in other sheets?

Yes. If another sheet contains a formula that references a cell you delete, that formula will show #REF! error. Check all formulas that might reference the cells before deleting them. You can search for references using Find & Replace (Ctrl+H) to see where cells are used.

Can I delete cells in a protected sheet?

No, not unless the sheet protection allows it. If a sheet is protected, right-clicking and choosing Delete will be grayed out. The sheet owner must unprotect the sheet first. Go to Review tab and click Unprotect Sheet if you have the password.