How to Delete in Excel Using the Keyboard

How-to basics · Updated November 20, 2026

To delete data in Excel with the keyboard, select the cell or range and press Delete; this clears its contents but keeps its formatting. To remove cells, rows, or columns instead, select them and press Ctrl+- on Windows, then choose a shift option if Excel asks. Decide which kind of deletion you need before pressing a shortcut, because clearing a value and removing a cell are different actions.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows, with the cells you want to change visible or identifiable.
  • A keyboard. If you use Excel for Mac, see the Mac notes below; some key names and shortcuts differ.
  • For any important workbook, consider saving a copy first. Ctrl+Z can reverse most accidental deletions, but a backup is useful if you make more changes afterward or close the file.

Step-by-Step

  1. Choose what “delete” means for your task. If you want to remove a value or formula and leave the cell in place, clear its contents. If you want neighboring cells to move into the gap, delete cells and choose a shift direction. If you want to remove a complete record or field, delete a worksheet row or column. These choices affect different parts of the worksheet, so do not use a row-deletion shortcut when you only mean to clear a few entries.
  2. Select the cell or range. Click a cell with the mouse, or move the active-cell outline with the arrow keys. To select a range using only the keyboard, place the active cell at one corner, hold Shift, and use the arrow keys to extend the selection. You can also press Ctrl+G, type a range such as B3:D8 in the Go To box, and press Enter. Check the highlighted area before deleting; pressing Delete acts on every selected cell.
  3. Clear contents while keeping the cells. With the intended cell or range selected, press the Delete key on a Windows keyboard. Excel removes the selected cells’ contents, including entered values or formulas, but leaves the cells and their formatting in place. For example, clearing a formatted total cell removes the displayed total or formula without removing its fill color, borders, or position. On a Mac, the Delete key (often labeled Backspace) clears contents; some keyboards may require Fn+Delete for forward delete, but that is not generally needed to clear a selected cell.
  4. Delete selected cells and close the gap. Select one cell or a range, then press Ctrl+- (Ctrl and the minus key) on Windows. When Excel displays the Delete dialog, use the arrow keys to choose Shift cells up or Shift cells left, then press Enter. Choose Shift cells up when the cells below should move upward; choose Shift cells left when cells to the right should move left. Inspect adjacent data first: shifting cells can misalign related values in neighboring columns or rows. In Excel for Mac, Control+- opens the delete choice in many keyboard layouts; if that key combination is intercepted by your system or does not open the dialog, use the Excel menu or ribbon command for deleting cells.
  5. Delete a whole worksheet row. Move to any cell in the row and press Shift+Space to select the worksheet row. Confirm that the row number at the left is highlighted, then press Ctrl+- on Windows. A fully selected row is deleted as a row, moving the rows below upward; Excel may not show the shift-choice dialog because the selection already specifies a whole row. On a Mac, Shift+Space selects the row and Control+- is the corresponding delete shortcut where supported. You can also select a row by navigating to its row number with the keyboard, but verify that you have the intended row before deleting it.
  6. Delete a whole worksheet column. Move to a cell in the column and press Ctrl+Space on Windows to select the worksheet column. Check the column letter at the top, then press Ctrl+- to delete it; columns to its right move left. On a Mac, Control+Space is commonly used to select a column, though macOS may assign that shortcut to an input-source feature. If the shortcut is intercepted, select the column from Excel’s column heading or use the ribbon instead. Deleting a column removes every cell in that worksheet column, not just the visible entries in your current section.
  7. Review the result and undo immediately if needed. Check nearby labels, totals, and formulas to make sure the correct cells shifted or disappeared. If the deletion was wrong, press Ctrl+Z on Windows right away. On a Mac, press Command+Z. Undo usually restores the deleted content or row, but if you have performed several other actions, Excel may undo those actions first. Save only after confirming the result is correct, especially when editing shared or business-critical data.

Common Mistakes

Pressing Delete when you meant to remove a row. The Delete key clears the selected cells’ contents; it does not remove the worksheet row or pull the rows below upward. Select the full row with Shift+Space and use Ctrl+- when the row itself must go.

Using Ctrl+- without checking the selection. With a partial cell selection, Excel may offer choices about shifting cells. With a full row or column selected, it can delete the entire row or column directly. Make sure the highlighted selection matches the intended operation before confirming.

Choosing the wrong shift direction. Shift cells up and Shift cells left are not interchangeable. Moving only part of a record can put a name beside the wrong date or amount. If the data is arranged as a table, deleting an entire table row is usually safer than shifting a few individual cells in the middle of a record.

Expecting Delete to remove formatting. Clearing contents generally leaves formatting behind, so a blank cell may still have a border, number format, or fill. If you need to remove formatting too, use Home > Clear > Clear Formats. Avoid Clear All unless you intend to remove both contents and formatting.

Tips

  • Use the Name Box to target a known range quickly. Press Ctrl+G, enter a reference such as C5:C20, and press Enter; then press Delete to clear it or Ctrl+- to open the cell-deletion options.
  • For nonadjacent cells, hold Ctrl on Windows while selecting additional cells, then use Delete to clear all selected contents. For multiple nonadjacent ranges, be especially careful: Ctrl+- may offer a shift choice that affects the surrounding worksheet in ways you do not expect.
  • When working with formulas, clearing a cell that contains a formula removes the formula as well as its displayed result. If you need the result to remain but no longer want a formula, copy the cell and use Paste Special > Values instead of deleting it.
  • Keyboard layouts vary. The minus key may be beside the number 0 or on a numeric keypad. On a laptop, you may need an Fn key to access a numeric keypad symbol. If Ctrl+- is awkward, use Excel’s Home > Delete menu to choose the relevant command.
  • In a formatted Excel table, deleting worksheet cells can disturb the table layout. To remove a table record, select a cell in that record, use Shift+Space to select the table row if it selects the table row, and use the table’s Delete command or the context menu to remove the table row. Check the result because selection behavior can depend on where the active cell is.

Troubleshooting

The Delete key seems to do nothing. Confirm that a worksheet cell, rather than a ribbon control, chart, or text box, is active. Click a cell once and look for the active-cell outline, then try again. If the sheet is protected, editing or deleting cells may be blocked; check Review > Unprotect Sheet if you have permission and the password, if one is required.

Excel removed the wrong content. Press Ctrl+Z immediately on Windows or Command+Z on Mac. If the workbook has already been closed, or the undo history no longer contains the deletion, check whether the file is stored in OneDrive or SharePoint and whether version history is available. For a local file, look for a separate backup or AutoRecover copy; recovery is not guaranteed.

Ctrl+- opens a dialog you did not expect. Excel is responding to the selected cells. If you meant to remove a whole row or column, cancel the dialog with Esc, select the complete row with Shift+Space or column with Ctrl+Space, and retry. If you meant only to erase the entries, cancel and press Delete instead.

The Mac shortcut types a symbol or triggers another feature. Keyboard layouts and macOS settings can change how minus and Control+Space behave. Try the corresponding Control+- shortcut for cell deletion, or use the Excel ribbon: Home > Delete, then select the appropriate delete option. For clearing contents, select the cells and use the Delete key. These menu commands are a practical fallback when a hardware keyboard differs from the standard layout.

Blank cells remain colored or bordered after clearing. That is expected when only contents were cleared. Select the cells and use Home > Clear > Clear Formats if you want to remove formatting while keeping the cells. If you want to remove both the content and formatting, choose Clear All deliberately, then verify the affected range.

Frequently Asked Questions

Does pressing Delete remove a cell in Excel?
Usually, no. It clears the contents of the selected cell or cells but leaves the worksheet cells in place. Use Ctrl+- on Windows to delete cells and choose whether surrounding cells should shift.

How do I delete a row without a mouse?
Move to a cell in the row, press Shift+Space to select the row, then press Ctrl+- on Windows. On Mac, use Shift+Space and Control+- where supported. Check the row number highlight before confirming.

How can I delete a column using only the keyboard?
On Windows, select a cell in the column, press Ctrl+Space, verify the column heading is selected, and press Ctrl+-. On Mac, Control+Space may select the column, but a macOS shortcut conflict may require using Excel’s menu instead.

Can I delete only the contents and keep the formatting?
Yes. Select the cells and press Delete. This clears values and formulas while keeping the cell positions and their formatting. If the formatting also needs to go, use Home > Clear > Clear Formats.

What is the shortcut to undo a deletion?
Press Ctrl+Z in Excel for Windows or Command+Z in Excel for Mac as soon as you notice the mistake. Undo reverses the most recent action first, so if you have made later changes, it may take more than one undo to reach the deletion.

Can I delete a cell without shifting anything?
Excel cells occupy a grid, so deleting an individual cell requires choosing a shift direction or deleting its whole row or column. If you want the cell to stay in place and appear empty, clear its contents with Delete instead.

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.