How to Delete Data in Excel & Not Formulas

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.

Video of the Day


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.


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


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

Show Comments