Delete Information in Excel Cells: Safe, Clear Steps

How-to basics · Updated November 20, 2026

To delete information in Excel cells while keeping the cells and their formatting, select the cell or range and press Delete on Windows, or use Home > Clear > Clear Contents. To remove only part of a cell’s text, edit the cell or use Find and Replace for repeated text. Choose the method that matches what you want gone: clearing content does not remove the cell itself, while deleting cells can shift other data.

The steps below are for Excel for Microsoft 365 on Windows. Before clearing a large range or making a change you cannot easily reconstruct, save a copy of the workbook or check that Undo is available.

What You’ll Need

  • An Excel workbook you can edit. If it is read-only or protected, you may need permission or to unprotect the relevant sheet before changing cells.
  • A clear idea of whether you want to remove cell contents, formatting, or the cells themselves. These are different actions in Excel.
  • For a large or important change, a saved copy of the workbook or a recent backup. This gives you a safer way to recover if you clear the wrong range.

Step-by-Step

  1. Save or make a copy if the data matters. Use File > Save As to create a separate copy, or save your current workbook before you begin. If you make a mistake immediately after a change, Ctrl+Z on Windows (Command+Z on Mac) usually undoes it. Saving a copy is especially useful before clearing an entire column, sheet, or large selection.
  2. Select the cell or cells. Click a single cell to clear just that entry. To select a continuous range, click the first cell, hold Shift, and click the last cell, or drag across the cells. You can also click the Name Box to the left of the formula bar, type a range such as B2:D15, and press Enter. For non-adjacent cells, hold Ctrl on Windows while clicking each cell; on Mac, hold Command. Check the highlighted selection before moving on.
  3. Clear contents but keep the cells and formatting. Press the Delete key on your Windows keyboard. This removes the selected cells’ contents, including typed values, text, and formulas, but leaves the cell locations, formatting, borders, and comments or notes in place. If your keyboard does not have a clearly labeled Delete key, use the ribbon route: Home > Clear > Clear Contents. On Mac, the Delete key (the Backspace key on many Mac keyboards) clears selected contents; the ribbon command is a reliable alternative. In Excel for the web, select the cells and use Home > Clear > Clear Contents if the command is available in your ribbon.
  4. Confirm that the intended cells are empty. Click one of the cells you cleared and look at the formula bar. If it is blank, the cell’s entry is gone. If a cell still shows a result, check whether you selected the correct range or whether the displayed result is produced by a formula in another cell. Clearing a result cell does not remove the source data or formula elsewhere in the workbook.
  5. Remove formatting as well, only if you want a full reset. Select the cells, then choose Home > Clear > Clear All. This removes contents and formatting and can also clear other cell features, such as comments or notes. It does not delete the cells or pull neighboring cells into the empty space. Use Clear All only when you really want to remove the styling too; otherwise, choose Clear Contents.
  6. Delete only part of the text in one cell. Double-click the cell, or select it and press F2 on Windows, then place the insertion point in the formula bar or in the cell text. Select just the characters you want to remove and press Delete or Backspace, then press Enter to commit the edit. On Mac, double-click the cell or edit its contents in the formula bar; keyboard behavior can differ depending on the keyboard, so the formula bar is a useful way to position the cursor precisely. This edits the entry itself, not just its appearance.
  7. Remove the same text fragment from several cells. First select only the relevant range, then press Ctrl+H on Windows to open Find and Replace. On Mac, use Edit > Find > Replace or the available Find and Replace command for your Excel version. Enter the exact fragment in Find what and leave Replace with empty, then use Replace to inspect matches one by one. Use Replace All only after checking that the selected range and search text are correct. If the dialog offers a Look in setting, be careful with formula cells: replacing text in formulas can change how they work. Avoid replacing across the whole workbook unless that is specifically intended.
  8. Delete cells only when you want surrounding data to move. Select the cell or range, right-click, and choose Delete. In the dialog, choose Shift cells up or Shift cells left as appropriate. To remove a whole row or column, select its row number or column letter and use Home > Delete > Delete Sheet Rows or Delete Sheet Columns. The Delete key alone only clears contents; it does not remove the selected cells or row. Inspect nearby data after a structural deletion because other entries may shift.
  9. Check formulas, totals, and linked sheets after the change. Removing a formula can make totals or charts change, and removing source data can affect formulas elsewhere. Look at nearby totals and any sheets that use the cleared cells. If the result is not what you wanted, use Ctrl+Z on Windows or Command+Z on Mac before making additional edits. If you have already made later changes, restore the saved copy rather than repeatedly undoing unrelated work.

Common Mistakes

Pressing Delete when you meant to remove a row. The Delete key clears entries but leaves the row in place. If you need the row gone and the rows below to move up, select the row header and choose Home > Delete > Delete Sheet Rows. Conversely, choosing Delete on a selected cell can shift nearby data, so do not use it as a substitute for clearing content.

Choosing Clear All for a simple cleanup. Clear All removes formatting as well as contents. If you want an empty cell that keeps its number format, fill color, border, or data validation, use Clear Contents. Otherwise, you may need to rebuild the cell’s appearance or settings afterward.

Clearing a formula because its result looks like a value. A cell can display a number or text while actually containing a formula. Click it and check the formula bar before clearing. If the cell contains a formula, Delete removes the formula as well as its displayed result. If you only want to hide a displayed value, consider whether changing the formula or formatting is more appropriate.

Selecting too much before using Replace All. Find and Replace can affect many cells, and an unrestricted search may reach other parts of the workbook. Select the intended range first, read the Find what text carefully, and use Replace for a test match before choosing Replace All. Do not use it on formula cells unless you understand how changing the formula text could affect calculations.

Assuming a blank-looking cell is truly empty. A cell may contain spaces, an apostrophe, or a formula that returns an empty-looking result. Click the cell and check the formula bar. If it contains a formula, clearing the cell removes the formula. If it contains spaces or other invisible characters, edit the entry or clear its contents rather than judging only by how it looks.

Tips

  • Use the Clear Contents command when your goal is to empty cells but preserve the layout. It is the clearest option when you are unsure whether the keyboard Delete key will behave as expected on your device.
  • For a large range, use the Name Box to enter the exact address, then verify the selection shading. A range typed incorrectly can clear neighboring information that was meant to stay.
  • When testing a repeated deletion, use Replace first and inspect the result. Replace All is faster, but a single overly broad search term can change many entries at once.
  • If you want to clear several non-adjacent cells, select them with Ctrl-click on Windows or Command-click on Mac, then clear contents once. Do not click a different cell between selections if that would remove the multi-cell selection.
  • For records that may be needed later, consider moving them to an archive sheet instead of permanently clearing them. You can copy the rows to a clearly named sheet, verify the copied data, and then remove the original rows if appropriate.
  • Use Undo immediately after an unintended clear. Ctrl+Z on Windows and Command+Z on Mac typically reverse recent edits, but they are not a substitute for a backup when a workbook has been saved, closed, or edited further.

Troubleshooting

The cells will not clear. Check whether the worksheet is protected. In Excel for Microsoft 365 on Windows, open Review and look for Unprotect Sheet. If the sheet is protected, you may need the password or help from the workbook owner. Also check whether the file is read-only or opened in a view-only state; save an editable copy or request edit access before making changes.

The text disappears but the color or borders remain. That is expected when using Delete or Clear Contents. Those actions remove the entry but preserve formatting. To remove formatting as well, select the cells and choose Home > Clear > Clear All, then reapply any formatting you still need.

The cells appear empty, but formulas still return an unexpected result. Clearing a cell does not necessarily clear formulas that refer to it. Click the cells showing the unexpected result and inspect the formula bar. If another formula depends on the cleared cells, decide whether that formula should remain, be updated, or be cleared separately.

Nearby data moved or became misaligned. You likely chose Delete rather than Clear Contents, or removed a row or column. Use Undo promptly if possible. If undo is no longer available, restore the saved copy or compare with a backup; manually moving cells back can create additional mismatches.

Find and Replace changes more than expected. Undo the operation immediately, narrow the selection to the intended cells, and check the search options before retrying. Use Replace on one match first. If the affected cells contain formulas, inspect them individually and restore the correct formulas rather than treating their displayed results as ordinary text.

The Delete key does not act as expected on a Mac or laptop. Keyboard layouts vary, and some keyboards use Delete to mean Backspace. Select the cells and use Home > Clear > Clear Contents instead. If you intend to delete cells and shift others, use the right-click Delete command and choose the shift direction deliberately.

Frequently Asked Questions

Does pressing Delete remove cell formatting?
No. In Excel for Microsoft 365 on Windows, Delete clears selected cell contents but normally preserves formatting and the cells themselves. Use Home > Clear > Clear All if you also want to remove formatting.

How do I clear a cell without deleting its row?
Select the cell and press Delete, or choose Home > Clear > Clear Contents. The row remains in place, and cells around it do not move.

Can I delete just one word from a cell?
Yes. Edit the cell by double-clicking it or pressing F2 on Windows, select the word or characters, remove them, and press Enter. For the same phrase repeated in a range, use Find and Replace with the range selected and check a single replacement first.

How do I clear an entire column but keep the column?
Click the column letter to select the column, then press Delete or choose Home > Clear > Clear Contents. The column and its formatting remain. If you choose Clear All, its formatting is removed too.

Can I get information back after clearing it?
Use Ctrl+Z on Windows or Command+Z on Mac soon after the change. If Undo is no longer available, recover a saved copy, version history entry, or backup if one exists. A cleared entry may not be recoverable from the workbook itself.

What is the difference between Clear Contents and Delete?
Clear Contents empties the selected cells while keeping their positions. Delete opens options to shift other cells, or removes selected rows or columns when you choose those commands. Use Clear Contents for ordinary cleanup and Delete only when you intend to change the sheet’s structure.

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.