How to Delete Data in Excel & Not Formulas

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Save time when working with spreadsheets in Excel by retaining your formulas after deleting data. Clearing the contents of a box (cell) in Excel does not mean that should have to reinsert the formula when you next need to add information. This trick speeds the rate at which you can repopulate a spreadsheet with new information while using the same formulas from the old data. Those keeping spreadsheets know that wasted time equates a waste of production and money. Save both with this Microsoft Excel tip.


Step 1

Click on the cell containing the data you wish to delete. Select more than one cell by holding down the "Ctrl" key while clicking on the other cells.

Video of the Day

Step 2

Go to the "Edit" menu at the top of the page and highlight the "Clear" option.

Step 3

Choose "Contents" by clicking on it to delete only the data and not the formulas from the selected cells.





Report an Issue

screenshot of the current page

Screenshot loading...