In Excel for Microsoft 365 on Windows, press Delete to clear the contents of the selected cell or range. This removes values and formulas but leaves the cells in place; to remove cells, rows, or columns themselves, use Ctrl+- (minus) or the commands on the Home tab.
What the Delete key does in Excel
The Delete key clears the contents of the current selection. If one cell is selected, its entry is cleared. If a range is selected, the contents of every cell in that range are cleared together. The worksheet does not move neighboring data to fill the empty cells.
Clearing contents removes a typed value, text, or formula. For example, if cell B2 contains 125, pressing Delete makes B2 blank. If B2 contains =SUM(B3:B8), the formula is removed instead. Any other cell that depended on that formula may then show an error or a changed result, so check formulas before clearing a range.
The cells themselves remain, along with their formatting and position. A cleared cell can still have a fill color, border, number format, or other formatting applied. This distinction matters when you want to reuse a cell but preserve the worksheet’s layout. If you need to remove formatting too, use a clearing command rather than assuming the Delete key resets everything.
Clear contents versus delete cells
In everyday speech, people often say they want to delete a cell when they mean they want its contents gone. Excel treats those as different operations. Clearing contents leaves an empty cell where it was; deleting cells removes the selected cells and shifts other cells to occupy the space.
- Clear contents: removes entries from the selected cells without shifting data. Press Delete, or choose Home > Clear > Clear Contents.
- Delete cells: removes the cells, then shifts nearby cells up or left, depending on your choice. Select the cells and press Ctrl+-.
- Delete a row or column: removes the entire selected worksheet row or column, shifting the remaining rows or columns to close the gap.
- Delete a worksheet: removes a whole sheet from the workbook. This is a separate command and is not what the keyboard Delete key does.
For instance, if A1:A5 contains a list and you clear A3, A3 becomes blank while A4 and A5 stay where they are. If you delete the worksheet row containing A3, the former A4 and A5 move upward. Use clearing when you need to keep the table’s structure; use deletion when you intentionally want to close a gap.
Useful Excel delete shortcuts
These are the main keyboard options for clearing or removing worksheet content in Excel for Windows:
- Delete: clear contents in the selected cell or range.
- Ctrl+-: open the Delete dialog for selected cells, where you can choose how surrounding cells shift. If entire rows or columns are selected, the shortcut deletes those rows or columns.
- Ctrl+Z: undo the last action, including an accidental clear or deletion, as long as the action remains in the undo history.
To use the Delete dialog, select the cells first, press Ctrl+-, choose Shift cells up, Shift cells left, Entire row, or Entire column, and confirm. The available choices depend on what you selected. If you only intend to clear entries, do not use the minus shortcut: it can rearrange the worksheet and cause adjacent data to move.
Excel does not use Delete to remove the selected worksheet row or column. That key clears the contents. The distinction is especially important when a range contains formulas, labels, or data that other cells reference.
Delete cells, rows, and columns with the ribbon
If you prefer to use the ribbon or want a command whose name makes the result explicit, select the target first and open the Home tab. In the Cells group, choose Delete and then select the appropriate command. The menu includes options such as Delete Cells, Delete Sheet Rows, and Delete Sheet Columns. The exact options shown can depend on the selection.
- To remove a small block and shift neighboring cells, select the block, then choose Home > Delete > Delete Cells. Choose whether cells should shift up or left.
- To remove a full row, click its row number, then choose Home > Delete > Delete Sheet Rows. You can select multiple row numbers before choosing the command.
- To remove a full column, click its column letter, then choose Home > Delete > Delete Sheet Columns.
- To empty a selection while keeping its layout, choose Home > Clear > Clear Contents instead.
Deleting an entire row or column affects the worksheet, not just the visible cells in a table. If you only want to remove one record from an Excel table, select that table row and use its row-deletion command rather than clearing a few cells and leaving a partly empty record. Check the selection outline and row or column headers before confirming.
Choosing the right action for common tasks
The safest choice depends on what should happen to the surrounding data. A few typical situations make the difference clear:
- Remove a mistaken number but keep the cell’s formatting: select the cell and press Delete.
- Remove several old entries but leave blank spaces in the same positions: select the range and press Delete.
- Remove an unwanted record from a list and pull later records up: delete the entire worksheet row or table row, as appropriate.
- Remove an unused column so the columns to its right move left: select its column heading and delete the sheet column.
- Remove both entries and their formatting: use Home > Clear > Clear All, after checking that the formatting is not needed.
Be cautious with a large selection. If you select whole columns and press Delete, Excel clears contents throughout those columns, not just the visible portion of your dataset. If you select and delete whole columns with the ribbon or a structural shortcut, Excel removes them and shifts other columns. Narrow the selection to the intended cells whenever possible.
Why Delete may seem not to work
A common surprise is that the cell still looks colored or outlined after pressing Delete. That is expected when formatting remains. The value or formula may be gone even though the fill, border, or number format makes the cell look unchanged. Click the cell and check the formula bar, or look for an empty result, before repeating the action.
Other causes of confusing results include:
- The wrong cell is active: click the intended cell or select the range again, then verify the highlighted selection before pressing the key.
- The sheet is protected: protection can prevent edits to locked cells. Review the Review tab for the sheet-protection controls, or ask the workbook owner about access.
- The cell contains a formula returning an empty string: it can appear blank while still containing a formula. Select it and inspect the formula bar; pressing Delete removes that formula.
- A filter hides some rows: a selection may not correspond to the visible records you intended. Check the selected range and filtered view before clearing or deleting.
- You used a structural delete command: nearby data may have shifted. Press Ctrl+Z promptly if that was unintended.
Also distinguish a blank-looking cell from an actually empty one. A formula such as =IF(A2=0,"",A2) can display nothing under some conditions, but the cell still contains a formula. Clearing it removes the formula, not merely its displayed result.
Excel on Mac and Excel for the web
In Excel for Mac, the keyboard may label the key used to clear cell contents as Delete or Backspace depending on the keyboard. Select the cells and use the key that deletes the selected contents. For structural changes, use the ribbon commands, such as Home > Delete, or the cell’s context menu if you are unsure which Mac shortcut applies to your keyboard layout. Menu commands are also a practical choice when an external keyboard uses different key labels.
Excel for the web also supports clearing selected cell contents with the Delete key. Its ribbon layout and available keyboard behavior can differ slightly from the Windows desktop app, and browser shortcuts may compete with app shortcuts. If a key does not produce the expected result, use the Home tab’s Clear or Delete commands and confirm the selection before proceeding.
Across versions, the important distinction remains the same: clearing contents leaves the worksheet cells in place, while deleting cells, rows, or columns changes the grid and may shift other data.
Undo and safer ways to avoid mistakes
If you clear or delete the wrong thing, press Ctrl+Z immediately in Excel for Windows. This reverses the most recent action while it is still available in the undo history. If you have made several edits since the mistake, you may need to undo more than once; review the result after each step. Undo is not a substitute for checking a large deletion before confirming it.
For workbooks where accidental changes would be costly, consider these habits:
- Save a copy before making broad changes to important data.
- Check the Name Box or highlighted range to confirm exactly what is selected.
- Use Clear Contents when you want blanks but do not want neighboring cells to move.
- Use the ribbon’s specifically named row, column, or cell command when you intend to change the grid.
- After a deletion, inspect formulas and nearby records for unexpected shifts or errors.
These checks are particularly useful in shared workbooks and worksheets with linked formulas. Deleting a row can affect references and the layout of related data, while clearing a formula can affect calculations even though the grid looks unchanged.
Frequently Asked Questions
What is the shortcut to delete a cell in Excel?
Press Delete to clear the selected cell’s contents. To remove the cell itself and shift surrounding cells, select it and press Ctrl+-, then choose the shift direction.
Does pressing Delete remove cell formatting?
No. The Delete key clears contents but normally leaves formatting in place. To remove formatting as well, use Home > Clear > Clear All, or choose Clear Formats if you want to keep the cell’s contents.
How do I delete a whole row in Excel?
Select the row by clicking its number, then choose Home > Delete > Delete Sheet Rows. In Excel for Windows, Ctrl+- also deletes selected entire rows.
Why does Delete leave an empty space instead of moving cells up?
That is what the Delete key is meant to do: it clears contents without changing cell positions. To close the gap, delete the cells or the entire row and choose the appropriate shift behavior.
Can I recover cells after deleting them?
Usually, press Ctrl+Z promptly to undo the action. If the change is no longer in the undo history, recovery may depend on whether you have a saved copy, workbook version history, or another backup.
Related
- Excel File With Table Filters: How to Add and Use Them
- Excel File Too Large? How to Make It Smaller in Excel
- Excel File Too Large to Email? Practical Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Align Excel Columns: Shortcuts for Text and Column WidthIn Excel for Microsoft 365 on Windows, select the cells and press Alt, H, A, then C to…
- How to Change PowerPoint Slide Size to Widescreen (16:9)To change a presentation to widescreen in PowerPoint for Microsoft 365 on Windows, open the deck, select Design…
- Excel Import CSV Data: Steps, Settings, and FixesTo import CSV data into Excel for Microsoft 365 on Windows, open a blank workbook, select Data >…
- Excel Freeze Panes Shortcut: Windows Keys and TipsIn Excel for Microsoft 365 on Windows, press Alt, then W, F, and F to open Freeze Panes.…
- Automatically Merge Duplicate Cells in Excel? What WorksExcel has no built-in command that automatically merges cells just because their values match. For repeated values in…
- Excel Day Hour Minute Second Format: Display DurationsTo display an elapsed time in Excel as hours, minutes, and seconds, apply the custom number format [h]:mm:ss.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.