Microsoft Excel offers a very interesting way to clear contents without deleting formulas. We can cater to this problem statement by using the “clear contents” option. We can perform the below mentioned way to clear contents without deleting formulas in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with a column filled with formulas
– Open the desired Excel workbook containing a column with formulas applied
Step 2 – Clear contents option
– Now right click on one of the cells in the column where the formula is applied, and then select the “Clear Contents” option.
Step 3 – Contents cleared
– We can see that the contents of the cell have been cleared though the formula is still applied.