Deleting a file from Excel depends on what you mean by "file"

If you want to remove a spreadsheet entirely from your computer, you delete it the same way you delete any file — through your operating system's file manager, not through Excel itself. If you want to remove data from inside an open spreadsheet, you select the cells and press Delete. If you want to remove a sheet tab (the named pages at the bottom of your workbook), you right-click the tab and choose Delete Sheet. Each one is a different action with different consequences, so knowing which one you need matters before you start.

The confusion happens because "delete" means different things depending on where you are in the program. This guide walks through each scenario so you know exactly what will happen when you take each action.

Key Takeaways

  • Deleting an entire Excel file happens in File Explorer (Windows) or Finder (Mac), not in the Excel program itself.
  • Deleting data inside a spreadsheet — cells, rows, or columns — uses the Delete key or the right-click menu, and you can undo it when ready if you change your mind.
  • Deleting a sheet tab removes one of the named pages in your workbook but leaves the file itself intact.
  • Once you empty your computer's Recycle Bin (Windows) or Trash (Mac), the file is much harder to recover, so pause before you do that step.

Delete an entire Excel file from your computer

Open File Explorer on Windows or Finder on Mac. Navigate to the folder where your Excel file lives. Right-click the file name and select Delete (Windows) or Move to Trash (Mac). The file moves to your Recycle Bin or Trash folder — it is not gone yet.

If you change your mind, open Recycle Bin or Trash, find the file, right-click it, and select Restore (Windows) or Put Back (Mac). Once you empty the Recycle Bin or Trash, recovery becomes much harder and usually requires paid software or professional help. So if you are deleting something large or important, wait a few days before emptying the bin to make sure you do not need it.

Delete data inside an open spreadsheet

Click on the cell, row, or column you want to remove. To select multiple cells, click the first one, hold Shift, and click the last one. To select an entire row, click the row number on the left. To select an entire column, click the column letter at the top.

Press the Delete key. This clears the contents of the selected cells but leaves the cells themselves in place — the grid structure stays the same. If you want to remove the cells entirely and shift the remaining cells up or left, right-click the selection and choose Delete Cells, then pick whether to shift up or left. If you made a mistake, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo.

Delete a sheet tab from your workbook

At the bottom of your Excel window, you will see sheet tabs — usually labeled Sheet1, Sheet2, and so on, or with names you gave them. Right-click the tab you want to remove and select Delete Sheet. Excel will ask you to confirm because this action cannot be undone once you save the file.

If you delete a sheet by accident and have not saved yet, press Ctrl+Z or Command+Z to undo. If you have already saved, the sheet is gone. You can create a new sheet by right-clicking any tab and selecting Insert Sheet, but the data that was on the deleted sheet will not come back.

The difference between clearing cells and deleting cells

When you press Delete on selected cells, you clear the contents — the numbers, text, or formulas disappear, but the empty cells remain. When you right-click and choose Delete Cells, you remove the cells themselves and shift the remaining cells to fill the gap. Clearing is safer if you want to keep your grid structure intact. Deleting cells is useful if you want to remove a row or column entirely and close up the space.

For example, if you have data in columns A, B, and C, and you clear column B, you still have three columns — column B is just empty. If you delete column B, you now have two columns, and what was in column C moves to column B. Choose based on whether you want to keep the same number of columns and rows.

Recovering a deleted Excel file

If you deleted a file and emptied your Recycle Bin or Trash, recovery is possible but not may provide. On Windows, you can use the built-in File Recovery tool: open Settings, search for "recovery options," and look for a restore point from before you deleted the file. On Mac, Time Machine can restore files if you set it up before the deletion happened.

If neither of those works, third-party recovery software like Recuva (Windows) or Data Rescue (Mac) can sometimes find deleted files, but they cost money and do not always succeed. The best approach is to avoid needing recovery: keep important files in a second location, use cloud storage like OneDrive or Google Drive so deleted files stay in your cloud trash for 30 days, or wait a week after deleting before emptying your Recycle Bin.

Frequently Asked Questions

Can I delete a file from Excel without opening File Explorer?

Yes. In Excel, go to File, then Open. Find the file you want to delete, right-click it, and select Delete. This sends it to Recycle Bin or Trash the same way File Explorer does. You can also use File > Recent and right-click a recent file to delete it.

What happens if I delete a sheet that has formulas linking to other sheets?

The formulas in the other sheets will break and show #REF! errors. Before you delete a sheet, search your workbook for formulas that reference it. You can use Find & Replace (Ctrl+H or Command+H) to search for the sheet name in brackets, like [SheetName].

Can I recover data if I deleted cells but did not save the file?

Yes, press Ctrl+Z or Command+Z to undo the deletion. You can undo multiple steps by pressing it repeatedly. Once you save the file, undo is no longer available, so undo before you save if you change your mind.

Is there a way to delete a file permanently without using Recycle Bin?

On Windows, hold Shift while pressing Delete to skip Recycle Bin and delete permanently. On Mac, there is no built-in permanent delete, but you can empty Trash when ready after deleting. Permanent deletion makes recovery much harder but not impossible with specialized software.