How to Delete Data in Excel: Quick Guide

This guide covers every way to remove data from an Excel worksheet, from clearing a single cell to deleting entire rows, columns, and sheets. You’ll learn the exact keystrokes and menu paths, how to avoid accidentally deleting formulas or formatting, and what to do when Excel won’t let you delete something.

What You’ll Need

• A computer with Microsoft Excel installed (any recent version, including Microsoft 365, Excel 2021, 2019, or 2016).
• An Excel workbook with the data you want to remove.
• Basic familiarity with selecting cells with the mouse or keyboard.

Step-by-Step

Method 1: Delete the Contents of a Single Cell

1. Click the cell you want to clear. It will be highlighted with a border.
2. Press the Delete key on your keyboard. This removes the value or text but leaves any formatting (like bold or fill color) in place.
3. Alternatively, press Backspace to delete only the last character, or double-click the cell and manually select and delete part of the text.

Method 2: Clear a Range of Cells

1. Click and drag to select multiple adjacent cells, or hold Ctrl and click to select non-adjacent cells.
2. Press the Delete key. All selected contents are removed at once.
3. For more control, go to the Home tab, find the Editing group, click the Clear dropdown arrow, and choose Clear Contents. This does the same thing as pressing Delete.

Method 3: Delete an Entire Row or Column

1. Click the row number (e.g., “5”) on the left side of the sheet to select the whole row, or click the column letter (e.g., “C”) at the top to select the whole column.
2. Right-click the selected row number or column letter.
3. Choose Delete from the context menu.
4. Excel shifts the remaining rows up (if you deleted a row) or columns left (if you deleted a column). This is different from clearing contents — the row or column itself is gone, not just its data.
5. Alternatively, select the row or column, then press Ctrl + – (minus sign) on your keyboard.

Method 4: Delete Multiple Rows or Columns at Once

1. Click and drag across several row numbers or column letters to select them.
2. Right-click any selected number or letter and choose Delete.
3. All selected rows or columns are removed in one action.

Method 5: Delete an Entire Worksheet

1. Right-click the sheet tab at the bottom of the window (e.g., “Sheet1”).
2. Select Delete from the menu.
3. If the sheet contains data, Excel will ask you to confirm. Click Delete again.
4. The sheet is permanently removed. This cannot be undone with the Delete key; you must use Ctrl + Z immediately if you change your mind.

Method 6: Clear Formatting Only

1. Select the cells whose formatting you want to remove.
2. Go to the Home tab.
3. In the Editing group, click the Clear dropdown.
4. Choose Clear Formats. This removes colors, borders, number formats, and font styles, but leaves the text and numbers intact.

Method 7: Delete Data but Keep Formulas

1. Select the cells containing the formulas you want to keep.
2. Press Ctrl + G (or F5) to open the Go To dialog.
3. Click Special at the bottom left.
4. Choose Constants and click OK. This selects only cells with typed values, not formulas.
5. Press Delete. The constants are removed, but the formulas remain.

Method 8: Undo a Mistake

1. Immediately after deleting, press Ctrl + Z to undo the last action.
2. Repeat Ctrl + Z to undo multiple steps.
3. Use the Undo arrow at the top-left of the Excel window for the same effect.

Common Mistakes

• Pressing Delete on a row that has formulas elsewhere: Deleting a row removes all data in it, including formulas. If you only wanted to clear the numbers, select the cells and press Delete instead of deleting the row.
• Confusing “Clear Contents” with “Delete”: Clear Contents removes values but leaves the cells in place. Delete removes the cells entirely and shifts others. Using the wrong one can break your layout.
• Forgetting that Delete doesn’t remove formatting: If you press Delete and the cell still looks filled or bold, the formatting is still there. Use Clear > Clear All to remove everything.
• Deleting a sheet without realizing it contains data: Excel warns you, but people often click through without reading. Double-check the sheet name before confirming.
• Using Backspace thinking it clears the cell: Backspace only removes the last character. It does not clear the entire cell.

Tips

• To clear a large area quickly, select the first cell, hold Shift, and click the last cell in the range. Then press Delete.
• Use Ctrl + Shift + Down Arrow to select all data in a column from the current cell downward, then press Delete.
• If you delete data by mistake, Ctrl + Z is your best friend. It works for almost all deletion actions, including sheet deletion if done immediately.
• Before deleting rows or columns that affect formulas elsewhere, check for #REF! errors after deletion. If they appear, use Undo and instead clear the contents only.
• To delete only hidden rows or columns, first unhide them, then select and delete. Otherwise, hidden data may remain.
• Use Clear All from the Clear dropdown to remove contents, formatting, and comments in one go.

Troubleshooting

• Delete key does nothing: The cell might be protected. Go to the Review tab, click Unprotect Sheet (enter the password if prompted), then try again. If the workbook is shared, ask the owner to unprotect it.
• Rows won’t delete because they’re part of a table: If your data is in an Excel Table (with filter arrows), right-click a row in the table, choose Delete, then Table Rows. Deleting via the row number may not work as expected.
• “This action won’t work on multiple selections” error: You’ve selected non-adjacent cells and tried to delete entire rows. Select only one contiguous range, or delete rows one at a time.
• Data reappears after deletion: Check if the cells contain formulas that pull data from elsewhere. Delete the formula itself, or clear the source data.
• Can’t delete a sheet: The last visible sheet in a workbook cannot be deleted. Insert a new sheet first, then delete the one you want.
• Undo doesn’t work after deleting a sheet: If you’ve performed other actions since the deletion, Undo may not reach that far. Always confirm sheet deletion carefully.

Frequently Asked Questions

What is the difference between Delete and Clear Contents?

Delete removes the cells themselves, shifting other cells up or left to fill the gap. Clear Contents (or pressing Delete) removes only the text or numbers inside the cells, leaving the cells and their formatting in place.

How do I delete all data in a worksheet without deleting the sheet?

Click the square at the top-left corner of the sheet (where the row numbers and column letters meet) to select the entire sheet. Then press Delete. This clears all contents but keeps the sheet and its formatting.

Can I recover data deleted from Excel?

If you haven’t closed the workbook, press Ctrl + Z immediately. If you’ve saved and closed the file, check the File tab, then Info, then Manage Workbook for previous versions. Otherwise, recovery is unlikely.

Why does pressing Delete leave the cell looking the same?

Because Delete only removes the value, not the formatting. The cell may still have a fill color, border, or number format. Use Clear > Clear All to remove everything.

How do I delete only numbers but keep text in a column?

There’s no one-click way. You can filter the column by number (using the filter arrow, then Number Filters), select the visible numeric cells, and press Delete. Then clear the filter to see the remaining text.

Does deleting a row in Excel also delete it from other sheets?

No. Deleting a row only affects the current worksheet. If other sheets reference that row with formulas, they may show errors, but the data on those sheets is untouched.

Related

• How to Create a Windows Recovery USB Drive
• How to Block Ads in Firefox, Chrome, IE & Opera on Windows
• Turn Live Photos Into Video on iPhone & iPad