How to Delete Multiple Cells at Once in Excel

How-to basics · Updated November 20, 2026

To delete multiple cells at once in Excel, select the cells and press Delete to clear their contents, or use Home > Delete > Delete Cells to remove the cells and shift other data. Those actions are different: decide whether you want to keep the cell positions, move surrounding data, or remove entire rows or columns before you proceed.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The ribbon steps are similar in Excel for Mac and Excel for the web, although some controls may appear in a different place.
  • A clear idea of whether you want to erase values and formulas, remove cells and shift neighboring cells, or delete whole rows or columns.
  • If the data matters, a saved copy of the workbook or a plan to use Undo immediately if the result is not what you expected.

Step-by-Step

  1. Check what is in and around the cells. Look at the selected area and the adjacent columns and rows. If you delete cells and shift others, those neighboring values will move into the emptied space. If you only want a blank area without moving anything, clear the contents instead. Check formulas and labels nearby too, since removing cells can change where data sits and may affect formulas that refer to it.
  2. Select the cells you want to affect. For a rectangular block, click the first cell and drag to the last, or click the first cell, hold Shift, and click the last cell. You can also enter a range such as B3:D8 in the Name Box to the left of the formula bar and press Enter. For separate cells or ranges, hold Ctrl on Windows while clicking or dragging each additional selection. On Mac, use Command-click for separate selections. Keep the selection limited to the cells you intend to change.
  3. Choose whether to clear or delete. To remove only values and formulas while preserving the grid layout, press the Delete key on your keyboard. Alternatively, choose Home > Clear > Clear Contents. To remove cells and have surrounding cells move into the space, continue to the next step. The Delete key is not the same as the Delete command on the ribbon: the key clears cell contents; the ribbon command opens options for deleting cells, rows, or columns.
  4. Open the Delete Cells command for a structural deletion. With a contiguous rectangular range selected, choose Home > Delete > Delete Cells. You can also right-click the selected range and choose Delete. If you prefer a keyboard shortcut on Windows, press Ctrl+- (the minus key) to open the deletion choices. If a noncontiguous selection is active, Excel may not allow this command; use it on one contiguous block at a time.
  5. Choose how the remaining cells should move. In the Delete dialog, choose Shift cells up to move the cells below the selection upward, or Shift cells left to move cells to its right to the left. The right choice depends on your table’s layout. For example, deleting B4:B6 and shifting cells up pulls the values from B7 and below upward in column B. It does not automatically remove the corresponding cells in other columns, so use this option only when that movement is intended.
  6. Delete complete rows or columns when the whole record should go. To remove entire rows, select the row numbers at the left edge of the sheet, then choose Home > Delete > Delete Sheet Rows. To remove whole columns, select their lettered headers and choose Home > Delete > Delete Sheet Columns. Selecting a block of row or column headers removes those complete rows or columns, including cells outside the part of the sheet that currently contains visible data. Confirm that you have selected headers, not just cells within the rows or columns.
  7. Review the result and undo promptly if needed. Check the edited area and nearby rows or columns for unexpected movement, gaps, or changed formulas. If the wrong cells were cleared or shifted, press Ctrl+Z on Windows or Command+Z on Mac to undo the last action. Undo works best immediately; after other edits, closing the workbook, or certain operations, the action may no longer be available in the undo history.

Common Mistakes

Pressing Delete when you meant to remove cells. The keyboard Delete key clears cell contents but does not shift cells or remove their rows. Use Home > Delete > Delete Cells for a cell-level deletion that shifts data, or choose Delete Sheet Rows or Delete Sheet Columns when removing complete records or fields.

Choosing the wrong direction for shifting. Shift cells up affects the cells below the selected range in the same columns; Shift cells left affects cells to its right in the same rows. If your table represents complete records, shifting a few cells in one column can misalign names, dates, and amounts. Delete a full row when the entire record should be removed.

Assuming a selected rectangle is the same as selecting full rows. Selecting cells such as A5:D5 only affects that range. It does not delete the rest of row 5. Select the row number and use Delete Sheet Rows if the whole row must go.

Using Delete Cells on a scattered selection. Excel may refuse to shift cells from multiple separate ranges because there is no single consistent direction to fill the gaps. Delete or clear each block separately, or select a single contiguous range that matches the intended edit.

Forgetting that contents and formatting are separate. Clear Contents removes values or formulas, but it generally leaves formatting such as fills, borders, and number formats. If the cells should also lose formatting, use Home > Clear > Clear All instead, and check the selection carefully because that removes more than contents.

Tips

  • Use the Name Box for a precise block. Click it, type a range such as D10:F14, and press Enter. This avoids dragging across a large sheet and makes it easier to check the exact selection before deleting.
  • Inspect formulas before shifting cells. A formula may refer to cells in or near the area you are deleting. Excel often adjusts references when rows or cells are deleted, but the resulting formula may not represent the calculation you intended. Check important totals and dependent sheets after the edit.
  • Use row deletion for complete records. In a typical table where each row is one record, selecting the row header and deleting the sheet row keeps the remaining fields aligned. If the table is an official Excel Table, deleting its table row is usually the clearest way to remove a record.
  • Try the action on a copy when the layout is delicate. This is useful for reports with merged cells, formulas, or carefully aligned sections. A copy lets you compare the result before making the same edit in the original workbook.
  • Remember the Mac selection difference. On Windows, use Ctrl-click to add separate areas to a selection; on Mac, use Command-click. The Home tab’s Delete options are available in desktop Excel on both platforms, though ribbon layout and keyboard shortcuts can differ.

Troubleshooting

The cells went blank, but the surrounding data did not move. You probably pressed the keyboard Delete key, which clears contents. If you meant to shift neighboring cells, select the range again and choose Home > Delete > Delete Cells, then choose Shift cells up or Shift cells left. If the desired outcome is to remove a whole record, select its row header and delete the sheet row instead.

Excel says it cannot use the command on a multiple selection. This can happen when separate areas are selected and the requested operation needs to shift cells. Undo if any part changed, then handle each contiguous block separately. For scattered cells where the positions must remain fixed, select them with Ctrl-click or Command-click and clear their contents with Delete. Do not expect a scattered selection to shift neatly as one unit.

The wrong data moved or the table no longer lines up. Press Ctrl+Z on Windows or Command+Z on Mac as soon as you notice. Re-select the affected range and decide whether the edit should have removed full rows, full columns, or only cells. When each row represents one complete record, deleting selected cells and shifting only one column can put values under the wrong headings; remove the full row instead.

The Delete option is unavailable or the sheet will not change. Check whether the worksheet is protected. If you have permission to edit it, go to Review > Unprotect Sheet and enter a password if prompted. Also check for merged cells: a selection that cuts through a merged area can block or complicate deletion. Select the entire merged area or unmerge it first if appropriate, then retry. If the workbook is read-only, save an editable copy if you are authorized to make changes.

Formatting remains after clearing. That is expected when you clear contents. To remove the formatting too, select the cells and choose Home > Clear > Clear All. Use Clear All only if you also want to remove other cell content and formatting, rather than just emptying the cells.

The result differs in Excel for the web. Select the cells and use the Home tab’s Delete options or the right-click menu if available. Some controls may be arranged differently from desktop Excel. If you cannot find the needed shift option, open the workbook in the desktop app and use Home > Delete > Delete Cells.

Frequently Asked Questions

How do I delete multiple cells without shifting other cells?

Select the cells, then press Delete on Windows or use the equivalent Delete key on your Mac keyboard. This clears values and formulas while keeping the selected cells in place. You can also choose Home > Clear > Clear Contents. Formatting is generally retained.

How do I delete several non-adjacent cells at once?

Hold Ctrl on Windows, or Command on Mac, and click each cell or range. Press Delete to clear their contents. If you need to remove the cells and shift neighboring data, Excel may not accept the separate areas as one deletion; process contiguous ranges individually.

What is the difference between Delete and Clear Contents in Excel?

Pressing the keyboard Delete key clears the selected cells’ contents. Home > Clear > Clear Contents does the same kind of content clearing. Home > Delete > Delete Cells removes cells from the grid and asks whether other cells should shift up or left. Deleting sheet rows or columns removes those complete rows or columns.

Can I delete multiple rows or columns at the same time?

Yes. Select the row-number headers or column-letter headers for the rows or columns you want to remove, then choose Home > Delete > Delete Sheet Rows or Delete Sheet Columns. For rows or columns that are not next to each other, the most reliable approach is to delete each group separately and check the result between edits.

Will deleting cells change my formulas?

It can. Excel may adjust references when cells, rows, or columns are deleted, and formulas can produce a different result or an error if a referenced cell is removed. Review important formulas, totals, and dependent worksheets after deleting, especially when choosing to shift cells up or left.

Can I recover cells after deleting them?

Use Ctrl+Z on Windows or Command+Z on Mac immediately after the deletion to undo it. If the workbook has been closed or the action is no longer in the undo history, recovery depends on available backups or version history. Saving a copy before a large deletion is a safer option.

Related

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.