Erase data, preserve formula's

U

urbanfox

I have a an excel file with 12 worksheets for the financial year and an
additional worksheet for yearly totals.

I need to get a blank copy of this and was wondering if anyone knew a
way to delete all the user inputted data while keeping the formatting
and formula's intact.

Any help is much appreciated.
 
G

Guest

Hi

Hit F5 and select Special and then Constants. You can then decide whether to
keep certain bits or not.
Make a backup before you start!!

Andy.
 
Top