Excel Delete Shortcut: Clear Cells, Rows, and Columns

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Delete to clear the contents of selected cells, or press Ctrl+- (Ctrl plus the minus key) to delete cells, rows, or columns. The first action leaves the cells in place; the second removes them and may shift nearby data. Select the right cells or headers before using either shortcut, and save your workbook first if the change could be hard to reconstruct.

What You’ll Need

  • A workbook open in the Excel desktop app, with the worksheet you want to edit active.
  • A clear idea of whether you want to remove cell contents or remove the cells, rows, or columns themselves.
  • For important workbooks, a saved copy or a recent save point. Ctrl+Z can undo most recent edits, but it is safer not to rely on undo for a major change.

The instructions below are for Excel for Microsoft 365 on Windows. The Delete key is distinct from the Ctrl+- shortcut, and choosing the wrong one can change the layout of your worksheet.

Step-by-Step

  1. Open the correct worksheet. Click the worksheet tab at the bottom of the Excel window and find the data you intend to change. If the workbook has several similar sheets, check the tab name and nearby headings before selecting anything. If you are working with a shared or business-critical workbook, save it before editing.
  2. Select the target. To clear one cell, click it. To clear a range, click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. To select a whole row or column, click its numbered row heading or lettered column heading. You can select multiple non-adjacent ranges by holding Ctrl while selecting them.
  3. Choose whether to clear or delete. If you want to leave the worksheet layout unchanged and remove only values or formulas, press Delete. If you want to remove the selected cells and have surrounding cells move into the gap, use Ctrl+-. This distinction matters: deleting cells can move data and affect formulas that refer to those cells.
  4. Clear cell contents with the Delete key. With the intended cell or range selected, press the Delete key once. Excel clears the selected cells’ values, text, and formulas, while keeping the cells in their existing positions. Their formatting generally remains, so the cells may still show borders, fills, number formats, or other styling. This is useful for removing entries while preserving a prepared template.
  5. Delete selected cells with Ctrl+-. Select the cells you want removed, then press Ctrl+-. If you selected ordinary cells rather than an entire row or column, Excel opens the Delete dialog. Choose Shift cells left or Shift cells up, depending on how you want the gap closed, then click OK. Check the neighboring values first: shifting cells can change the alignment of a table.
  6. Delete a whole row or column. Click the row number or column letter to select its entire header, then press Ctrl+-. Excel removes the selected row or column, and the surrounding worksheet closes the gap automatically. You can select a continuous group by dragging across its row numbers or column letters, or select separate headers with Ctrl held down. Confirm the highlighted headers before pressing the shortcut.
  7. Check the result immediately. Look at the affected area and the cells above, below, or beside it. If you removed something by mistake, press Ctrl+Z right away to undo the action. If the result is correct, save the workbook. If you need to remove only formatting rather than data, use Home > Clear > Clear Formats instead of either deletion shortcut.

You can also use the ribbon if you prefer to confirm the command visually. For clearing, select the cells and choose Home > Clear > Clear Contents. For structural deletion, select cells or headers, open Home > Delete, and choose the appropriate delete command. The dialog after Ctrl+- is especially useful when you need to choose which direction cells should shift.

Common Mistakes

  • Using Ctrl+- when you only meant to empty cells. This removes cells from the grid and shifts other data. Use Delete or Home > Clear > Clear Contents when the layout should stay put.
  • Using Delete when you meant to remove a row. The Delete key clears the selected row’s contents but does not remove the row itself. Select the row heading and use Ctrl+- to remove the row.
  • Selecting only some cells in a table row. Deleting a partial range and shifting cells can misalign records. When a record should disappear as a unit, select the whole worksheet row or use the table’s row controls rather than deleting just a few cells.
  • Assuming a cleared cell is completely reset. Pressing Delete does not normally remove formatting. A cell can look blank but retain a fill color, border, or number format. Use Home > Clear > Clear All only when you also intend to remove the cell’s formatting and other contents.
  • Deleting cells that formulas depend on. Removing or shifting cells can change formula references or cause errors. Review totals and dependent calculations after deleting structural elements, especially in a complex workbook.

Tips

  • Use the row and column headers for precise structural edits. Clicking a row number or column letter makes the scope clear before you delete. It is safer than trying to select every cell across a wide row or tall column.
  • Use the Name Box for a large range. The Name Box is to the left of the formula bar. Enter a range such as B4:F20 and press Enter to select it, then use Delete to clear its contents. Before using Ctrl+-, decide whether shifting cells is appropriate.
  • Use Find to locate entries before clearing them. Press Ctrl+F, search for a value, and inspect the match before editing. A search can locate the right cell, but confirm the surrounding row or column so you do not remove a different record with a similar value.
  • Keep a template’s structure. If you are preparing a sheet for new entries, select only the input cells and press Delete. This preserves their positions and usually keeps the formatting and validation that make the template usable.
  • Remember that undo is action-specific. Ctrl+Z reverses the latest action, not necessarily every change made since you started editing. If you have performed other operations after deleting, review the undo sequence before applying it repeatedly.

On a Mac, the Delete key on many keyboards behaves like Backspace and clears selected cell contents. Some compact keyboards may label the key differently. Excel for Mac also supports keyboard shortcuts for deleting cells, but the exact key combination can depend on the keyboard layout; if Ctrl+- does not open the deletion command on your setup, use the menu command or right-click the selection and choose Delete. In Excel for the web, browser and keyboard settings can affect shortcuts, so the right-click or ribbon command is a practical alternative.

Troubleshooting

  • Nothing happens when you press Delete. Click inside the worksheet first and check that the intended cells are visibly selected. If a cell is being edited, press Esc to leave edit mode, select the cell again, and press Delete. Also check whether a dialog or another window has focus.
  • Ctrl+- types a character or does something unexpected. Confirm that the worksheet has focus and that you are pressing Ctrl and the minus key together. On some keyboard layouts, the minus key may be in a different position. Try the minus key on the main keyboard rather than the numeric keypad, or use Home > Delete or right-click the selected cells and choose Delete.
  • The wrong cells shifted. Press Ctrl+Z immediately. Select the range again, press Ctrl+-, and choose the correct option in the Delete dialog. Use Shift cells up when entries below should move upward, or Shift cells left when entries to the right should move left. If the data forms complete records, undo and delete the whole row instead.
  • You cannot change the cells. The worksheet may be protected, or the workbook may be in a restricted shared state. Check Review > Unprotect Sheet; if the sheet is protected, you may need the password or the workbook owner’s permission. Some protected sheets allow editing only in designated unlocked cells.
  • The cells look empty but still appear styled. That is expected after clearing contents. Select the cells and choose Home > Clear > Clear Formats to remove formatting, or Home > Clear > Clear All to remove contents and formatting. Use Clear All carefully because it can also remove other cell settings.
  • A formula result changes after deletion. Check the formula bar and review formulas that use the affected range. Deleting cells can update references or leave formulas with errors. Undo if the change was unintended; otherwise, restore the needed inputs or adjust the affected formulas and verify the results.

Frequently Asked Questions

What is the shortcut to delete cell contents in Excel?

Select the cells and press Delete. This clears values, text, and formulas without removing the cells from the worksheet grid. Formatting is generally left in place.

What is the Excel shortcut to delete a row?

Click the row number to select the entire row, then press Ctrl+- on Windows. Excel removes the row. If you select only cells within that row, Ctrl+- may instead open a dialog about shifting cells.

How do I delete a column using the keyboard?

Click the column letter to select the whole column and press Ctrl+-. Check the highlighted column before confirming, particularly if you selected more than one column.

Does pressing Delete remove formatting?

No. Delete clears the selected cells’ contents but usually leaves their formatting. Choose Home > Clear > Clear Formats to remove formatting, or Clear All if you intend to remove both contents and formatting.

How do I delete cells without shifting other data?

Press Delete to clear their contents while leaving the cells in place. If you use Ctrl+-, choose the appropriate shift option in the Delete dialog; Excel cannot remove cells structurally without closing the gap in some direction.

Can I undo a deletion?

Usually, yes: press Ctrl+Z immediately after the deletion. If you have made several edits since then, inspect the undo sequence carefully, or restore a saved copy if undo is no longer available.

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.