Wednesday, November 23, 2011

How to Delete Data in Excel Not Formulas


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.
2. Go to the 'Edit' menu at the top of the page and highlight the 'Clear' option.
3. Choose 'Contents' by clicking on it to delete only the data and not the formulas from the selected cells.

Blogger news