How to Delete Certain Data in Excel Without Losing More

How-to basics · Updated November 20, 2026

To delete only selected data in Excel, select the cells and press Delete to clear their contents, or use Home > Delete to remove cells, rows, or columns and shift the remaining data. For records that match a condition, filter the table, check which rows are visible, then delete those rows. Save a copy first if the information may be difficult to restore.

The right method depends on what you mean by delete. You might want to erase a value but keep its cell, remove an entire record, or clear formatting as well as contents. These instructions are for Microsoft Excel for Microsoft 365 on Windows. Excel for Mac has similar ribbon commands, though some keyboard keys and menu labels differ; Excel for the web may offer fewer options depending on your selection.

What You’ll Need

  • The Excel workbook you want to edit, preferably saved before you begin.
  • A clear idea of whether to remove cell contents, formatting, individual cells, or entire rows or columns.
  • If you are deleting records by a rule, a column that identifies those records, such as Status, Region, or Date.
  • Permission to edit the workbook. If it is shared or protected, you may need the owner to grant access or unprotect the sheet.

Step-by-Step

  1. Save a recoverable copy. Use File > Save As to make a duplicate before a large deletion, or save your current workbook and check that AutoSave is on if you use OneDrive or SharePoint. Undo can reverse many recent edits with Ctrl+Z on Windows (Command+Z on Mac), but it is not a dependable substitute for a backup, especially after closing the file or making unrelated changes.
  2. Identify exactly what should go. Note the sheet, columns, and criteria. For example, decide whether a request to remove cancelled orders means clearing the word Cancelled from a status cell or deleting every order row whose status is Cancelled. Those actions have different results. If the worksheet contains a table, make sure you know which columns form one complete record.
  3. Clear the contents of selected cells while keeping the cells in place. Click a cell, or drag across a range, and press Delete. This removes entries or formulas from the selected cells but does not move neighboring cells. To choose a particular type of content, go to Home > Clear and select Clear Contents, Clear Formats, or Clear All. Clear Contents leaves formatting intact; Clear Formats leaves the values and formulas but removes cell formatting; Clear All removes both and other cell contents such as notes and hyperlinks. Review the selection before using Clear All.
  4. Select scattered cells without deleting the spaces around them. Hold Ctrl on Windows while clicking separate cells or ranges, then press Delete to clear their contents. On Mac, hold Command while selecting nonadjacent cells. Check the highlighted cells before pressing the key: a large drag or a misplaced click can include information you meant to keep. If you have selected a whole worksheet by mistake, click one cell to cancel the selection.
  5. Remove a cell and shift nearby cells only when that is what you want. Select the cell or range, then choose Home > Delete > Delete Cells. In the dialog, choose Shift cells up or Shift cells left. This changes the alignment of nearby data, so use it only for a range where shifting will not pair values with the wrong headings or records. If you mean to remove a full record or field, delete the entire row or column instead.
  6. Delete a complete row or column. Click the row number or column letter to select it, then use Home > Delete > Delete Sheet Rows or Delete Sheet Columns. You can also right-click the selected row number or column letter and choose Delete. Deleting a row removes everything in that worksheet row, not just the visible value; deleting a column removes all its entries. Avoid selecting a row or column if you only intend to clear a few cells within it.
  7. Find a particular value before removing it. Press Ctrl+F on Windows (Command+F on Mac), enter the text or number, and use Find Next to inspect each match. Open Options if you need to limit the search to the current sheet, match the whole cell, or choose whether Excel searches formulas or displayed values. Select a match and close the Find window before clearing it. If there are many matches, Find All can list them; inspect the results carefully before selecting cells and pressing Delete, since a broad search can find text inside formulas or in unintended parts of the workbook.
  8. Delete records that meet a condition. If your data has headings, select a cell in the dataset and choose Data > Filter. Open the filter arrow in the relevant heading and select the value or condition to keep visible for deletion, such as Cancelled. Check the visible records, including their row numbers, and verify that the filter is applied to the full dataset rather than just part of it. Select the visible row headers for the records you intend to remove, then choose Home > Delete > Delete Sheet Rows. Clear the filter afterward and inspect the remaining records. When row selection is uncertain, use a helper column or sort the data so the target records are together, verify the group, and delete those full rows.
  9. Check the result and save. Confirm that required values, formulas, headings, and records remain. If you filtered the data, clear the filter and scan the full list; filtered-out rows can otherwise hide an accidental deletion or an incomplete selection. Save the workbook when you are satisfied. If the result is wrong, use Ctrl+Z (Command+Z on Mac) immediately, then repeat the operation with a narrower selection.

Common Mistakes

Pressing Delete when you meant to remove cells. The Delete key clears contents but does not close the gap or remove the cell itself. To shift surrounding cells, use Home > Delete > Delete Cells and choose the intended direction. For a complete record, select its row number and delete the sheet row.

Deleting a value instead of its entire record. Clearing a status or name may leave an incomplete row that still affects summaries, filters, or later analysis. Before editing a table, decide whether the record should remain with a blank field or be removed as a whole.

Deleting filtered rows without checking the selection. A filter hides records; it does not delete them. Selecting the wrong row headers, using a partial dataset, or misunderstanding which rows are visible can remove data you did not intend to remove. Check the visible row numbers and use a backup for bulk changes. Afterward, clear the filter and review the list.

Using Remove Duplicates as a general delete command. Data > Remove Duplicates removes repeated records according to the columns you choose and keeps one occurrence. It is not a safe way to delete a specific value or every row meeting a condition. Make a copy first, and verify which columns determine a duplicate before using it.

Forgetting formulas, formatting, or linked data. A cell may look blank but contain a formula, or a formula elsewhere may refer to the cell you remove. Deleting a column can also affect charts, named ranges, and formulas. Check important totals and references after structural changes; do not assume a blank-looking cell is empty.

Tips

  • Use a table for datasets with headings. Click inside the data and press Ctrl+T on Windows (Command+T on Mac) to create a table, if appropriate. Tables make it easier to filter by a heading and keep the header row separate from records. Confirm that My table has headers is selected when your first row contains headings.
  • Filter to a clear criterion. Use the heading filter rather than manually hunting through a long list. Before deleting, make the criterion specific enough to distinguish the intended records—for example, Cancelled in the Status column rather than searching for the word anywhere in the workbook.
  • Keep the first deletion small. Try the operation on one known cell or a copy of the sheet, then inspect the outcome before applying it to many rows. This is especially useful when the workbook has hidden rows, merged cells, or complex formulas.
  • Use Clear Contents when layout matters. If other cells depend on a fixed layout, clearing contents avoids shifting neighboring entries. Use Clear Formats separately if you need to remove color, borders, or number formats without erasing the underlying data.
  • Make a before-and-after check. For a filtered deletion, note the number of records shown before deleting and compare the remaining total afterward. For a single range, check nearby headings and totals. A quick review can catch a selection that extended one row or column too far.
  • Remember that workbook protection is different from file access. If Excel will not let you edit cells, look for Review > Unprotect Sheet, if you have the password. If a file is read-only, use Save As to create an editable copy if you are authorized to do so; do not try to bypass access restrictions.

Troubleshooting

Delete does nothing or the wrong cells change: Click inside the worksheet and check the selected range. If you are editing text inside a cell, press Esc to leave edit mode, select the cell itself, and try again. Use Home > Clear > Clear Contents if you want an explicit command.

The rows you want are not all visible: Check each filter arrow and remove other filters that may be limiting the results. Verify the heading row and dataset boundaries. If the data is sorted or filtered, avoid selecting the entire sheet; select only the verified target row headers.

Excel warns that cells contain data or asks how to shift cells: Stop and read the prompt. You may have selected individual cells and chosen Delete Cells, which requires Excel to move adjacent cells. Choose Cancel if the surrounding data should stay aligned, then clear the contents or select full rows instead.

A formula or total changes after deletion: Undo immediately if the change is unexpected. Check whether the removed cell was referenced by a formula, chart, or summary, and restore it from the saved copy if needed. If a formula now displays an error, inspect its references before making another deletion.

You cannot edit the sheet: Check whether the workbook opened in Protected View, whether the sheet is protected, or whether you have read-only access. Use the workbook’s Enable Editing control only when you trust the file, or ask its owner for the required permission.

You deleted the wrong information: Press Ctrl+Z on Windows or Command+Z on Mac right away. If Undo is unavailable or you have already closed the workbook, restore the earlier copy or version history from its storage location, if available. Avoid saving over the only backup until you have recovered the needed data.

Frequently Asked Questions

Does pressing Delete remove the cell in Excel?
No. It clears the contents of the selected cell or cells while leaving their positions and formatting in place. To remove cells and shift neighboring data, use Home > Delete > Delete Cells.

How do I delete only the values and keep formatting?
Select the cells and press Delete, or choose Home > Clear > Clear Contents. This removes cell contents while retaining formatting such as fill color, borders, and number formats.

How can I delete every row containing a certain word?
Filter the relevant column to show the word, check the displayed records, and delete the corresponding sheet rows. Clear the filter and review the remaining data. If the word may appear in several columns, decide which column should control the deletion before filtering.

Can I recover data after deleting it?
Use Ctrl+Z on Windows or Command+Z on Mac immediately if the deletion is still in the Undo history. If not, try a saved copy or the workbook’s version history. Recovery is not guaranteed, which is why saving a separate copy before a large deletion is wise.

What is the difference between Clear All and Delete?
Home > Clear > Clear All removes contents and formatting from the selected cells but leaves the cells in the worksheet. Home > Delete removes cells, rows, or columns and can shift or close the space they occupied.

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.