To delete a group of cells in Excel, select the range, press Ctrl+- on Windows, choose whether surrounding cells should shift left or up, and click OK. If you want to remove the cells and everything aligned with them, choose entire rows or columns instead. First decide whether you mean to remove cells or only erase their contents: the Delete key clears contents but does not close the gaps.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The cell range you intend to remove, identified by its column letters and row numbers.
- If the information matters, a saved copy of the workbook or a recent saved version to return to if the wrong cells are deleted.
You do not need a special tool or add-in. Excel’s built-in Delete Cells command handles the common cases. If the sheet is protected, the workbook is shared in a restricted way, or the cells are part of a structured table, you may need to address that before Excel will let you delete an arbitrary range.
Step-by-Step
- Save or check the workbook before editing. If the sheet contains important data, save the file with Ctrl+S before making the change. You can also use File > Save As to make a separate working copy. This gives you a fallback if you delete the wrong range or choose the wrong direction for shifting cells. Excel normally lets you undo a recent deletion with Ctrl+Z, but saving a copy is useful protection if you make other changes afterward.
- Select the cells you want to remove. Click the first cell, then drag to the last cell in the rectangular range. For a precise selection, click the Name Box to the left of the formula bar, type a range such as B3:D6, and press Enter. Check the highlighted area before continuing: B3:D6 includes three columns and four rows. If the cells you want are not adjacent, delete each range separately; commands that shift cells may not work on a selection made up of multiple separate areas.
- Choose whether to delete cells or just their contents. Look at what should happen to the data below or beside the selection. If you want to close a gap within the sheet, use Delete Cells and choose a shift direction. If the cells should remain in place but become blank, press the Delete key instead. Clearing is often the right choice for a template or layout where moving neighboring values would make the sheet harder to read.
- Open the Delete Cells command. On Windows, press Ctrl+- (the minus key). Excel opens the Delete dialog for a normal cell selection. You can also use the ribbon: select Home > Delete > Delete Cells. Be sure to click the Delete dropdown on the Home tab, not the keyboard Delete key. The ribbon menu also offers commands to delete entire sheet rows or columns, which have a different effect from removing only the selected cells.
- Pick the appropriate shift option. Choose Shift cells left when you want the cells to the right of the deleted range to move left into the gap. Choose Shift cells up when you want cells below the range to move upward. For example, deleting B2:B4 and choosing Shift cells up pulls the cells in B5:B7 into B2:B4, while values in other columns stay where they are. Do not choose a direction based only on the shape of the selection; consider how the surrounding rows and columns are organized.
- Use whole-row or whole-column deletion when the data is record-based. If the selected cells are part of complete records that should be removed, cancel the dialog and select the row numbers at the left edge of the sheet. Then choose Home > Delete > Delete Sheet Rows. To remove an entire field, select the column letters and choose Home > Delete > Delete Sheet Columns. This removes the complete row or column, including cells outside the original selection, so use it only when that is intended.
- Confirm the deletion and inspect the result. Click OK in the Delete dialog. Review the cells around the former selection, especially at the edges where values shifted. Confirm that each record still has its related values on the same row and that no headings or formulas were displaced. If the outcome is wrong, press Ctrl+Z immediately, then repeat the selection and choose the correct option.
- Save the corrected workbook. Press Ctrl+S after confirming the result. If the workbook is stored in OneDrive or SharePoint, check that it has finished saving before closing it. If the sheet is used for reporting, refresh or review any dependent charts, formulas, or summaries so you can confirm that the revised layout still makes sense.
On Excel for Mac, the menu path is also Home > Delete > Delete Cells. The keyboard shortcut for deleting cells can depend on the keyboard layout; try Control+- if available, or use the ribbon command to open the dialog. Excel for the web also provides delete options from the Home tab, though the exact ribbon layout can differ by window size. The principle is the same: select the range, choose the delete command, and specify how adjacent cells should move.
Common Mistakes
- Pressing Delete when you meant to remove cells. The Delete key clears the selected cells’ contents, but the cells remain and adjacent data does not shift. Use Home > Delete > Delete Cells when you want to close a gap.
- Deleting a whole row or column by accident. Selecting a cell and using a sheet-row or sheet-column delete command removes more than that cell. Check whether the command says Delete Cells, Delete Sheet Rows, or Delete Sheet Columns before confirming.
- Choosing the wrong shift direction. Shift cells up can separate entries that belong together if the data is organized in records across rows. Shift cells left can disrupt a table organized in columns. Think through which neighboring cells should fill the gap before selecting an option.
- Deleting only visible cells in a filtered list without checking the selection. A filtered sheet can hide records, and a selection may include cells you cannot currently see. Check the highlighted range and filter state before deleting. If you need to remove complete records, use the row-delete command on the intended records and verify the remaining list.
- Assuming Undo will always be available. Ctrl+Z usually reverses a recent cell deletion, but later actions, closing the workbook, or some external data operations can limit what you can undo. Save a copy first when the change is difficult to reconstruct.
Tips
- Use the Name Box for exact ranges. Typing a range such as C5:E8 is less error-prone than dragging across a large sheet. After pressing Enter, make sure Excel highlights the expected number of rows and columns before deleting.
- Use row deletion for complete records. In a simple list where each row is one item, deleting the entire row is generally safer than shifting a handful of cells upward in one column. It keeps the remaining fields for each record together.
- Prefer clearing contents when preserving the layout matters. For an input form, schedule, or formatted template, cells may need to stay in their original positions. Select the cells and press Delete to clear their contents while preserving their location and much of their formatting.
- Check formulas and references after a structural change. Excel often adjusts formulas that refer to cells you delete, but you should still inspect important totals and formulas. A formula may change or show an error if its referenced cells are removed or if a range no longer reflects the data you intend to summarize.
- Take extra care with tables and merged cells. Excel tables have their own row-delete commands and generally do not behave like an unrestricted worksheet range. For a table record, right-click its row and choose Delete > Table Rows, or use the table’s row-delete option. A selection containing merged cells may also prevent a partial-cell deletion; unmerge or select the full merged area only if that fits the layout.
- Keep a short audit trail for shared workbooks. If other people rely on the sheet, note which records or cells were removed and why. That makes it easier to explain changed totals and to recover information if a colleague needs to compare the updated sheet with the original.
Troubleshooting
The Delete dialog does not appear. Confirm that you selected worksheet cells and used Ctrl+- rather than the Delete key. If the shortcut is awkward on your keyboard, use Home > Delete > Delete Cells. If the ribbon command is unavailable, check whether the sheet is protected or whether the selection is inside a table.
Excel says it cannot change part of an array or spilled range. Some formula results occupy a range controlled by one formula. You may not be able to delete just one cell from that output. Find the formula that creates the array or spilled result and edit or remove it at its source, rather than deleting one of the displayed result cells. Make a copy first if you are unsure which formula controls the range.
The cells shift, but the data no longer lines up. Press Ctrl+Z right away to restore the previous arrangement. Then decide whether the information forms complete records. If it does, select and delete the whole row or rows instead of shifting cells in only one column. For data arranged vertically as complete records, consider deleting complete columns if that is the intended change.
The command is disabled or Excel refuses the deletion. Look for a protected sheet; on the Review tab, Excel may show Unprotect Sheet if protection is active. You will need permission or the password to change protected cells. Also check for merged cells, an Excel table, or a multi-area selection. Try selecting one contiguous range, use the table-specific delete command for table rows, or ask the workbook owner to enable editing.
Hidden or filtered data seems to have changed unexpectedly. Undo the operation, clear or review the filter, and inspect the row numbers and selected area. If the goal is to remove specific visible records, verify exactly which rows are selected before deleting them. Avoid choosing Delete Sheet Rows unless you intend to remove those entire worksheet rows, including cells in other columns.
Frequently Asked Questions
How do I delete multiple cells without deleting the whole row?
Select the cells, choose Home > Delete > Delete Cells, and select Shift cells left or Shift cells up. This removes only the selected cells and moves neighboring cells in the direction you choose.
What is the difference between deleting and clearing cells?
Deleting cells removes them from the grid and shifts other cells to fill the space, or removes complete rows or columns. Clearing with the Delete key removes cell contents but leaves the cells in place. Use clear when you want to keep the worksheet structure unchanged.
Can I delete cells and keep the formatting?
Pressing Delete clears cell contents while keeping the cells in place and usually retaining their formatting. The Delete Cells command removes the selected cells and shifts others, so the formatting that appears in the affected area may move with those cells. Check the result if formatting is important.
How can I delete a group of cells on a Mac?
Select the range and use Home > Delete > Delete Cells, then choose a shift direction. A Control+- shortcut may be available depending on your keyboard layout, but the ribbon path is the reliable option if the shortcut does not open the dialog.
Can I undo deleting a group of cells?
Usually, yes. Press Ctrl+Z on Windows immediately after the deletion, or use Edit > Undo on Mac. Undo may not be available after some later actions or after closing the workbook, so save a backup before a high-impact edit.
Why can’t I delete just part of a cell range?
The selection may overlap merged cells, a table restriction, or a formula-generated array or spill range. Select the full merged area, use the table’s row or column deletion option, or edit the formula that generates the array. If the sheet is protected, you will need to unprotect it or get editing access.
Related
- How to Copy a Table in Excel Without Losing Formatting
- How to Copy a Line in Excel: Rows, Cells, and Shortcuts
- Count Months Between Dates in Excel: Full and Partial Months
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Monthly Excel Budget Format: Build a Simple TemplateA useful monthly Excel budget format puts each income source and expense category on its own row, with…
- Google Sheets IFERROR: How It Works and When to Use ItIn Google Sheets, IFERROR returns a chosen fallback when a formula produces an error; otherwise, it returns the…
- Outlook Scheduling Poll: Add Meeting Times to EmailYes. In new Outlook for Windows, start a message, add the people you want to meet with, then…
- Excel Table Styles: How to Apply and Customize ThemAn Excel table style is a coordinated set of formatting applied to an Excel table, such as a…
- Excel Dropdown Lists With Colors: What Works?In Excel for Microsoft 365, you can create a dropdown list with Data Validation, but its built-in menu…
- Merge Cells in Google Sheets: Web and App StepsTo merge cells in Google Sheets, select a rectangular range, then choose Format > Merge cells and pick…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.