Delete excel sheet data only without deleting formula

 

In Microsoft excel we can delete excel sheet data only without deleting formula quite easily.

Steps to delete excel sheet data only without deleting formula:

To delete data or values  press CLTR+G to view  the “Go To”  command box.

 

Then press “Special box” to select “constants” option and click “OK”.

 

You will see that all the cells with data  remain selected except those cells, which contains a formula.

 

Now you can simply press the delete button to erase the data.

 

The “delete excel sheet data only without deleting formula” tricks, is an efficient way to make a template for data inputs of next period reporting.

Contact Us

Learn Excel Tricks
Email: info@learnexceltricks.com