Erase data, preserve formula's

  • Thread starter Thread starter urbanfox
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save workbook, erase data but keep formula 4
Excel Excel Formula OFFSET maybe? 1
Clear data but leave formulas 2
Extracting data from Multiple columns to a Single row 1
Problem printing underlines 1
How to preserve Excell 2007 conditional formatting for non Excel u 3
Formula to fill cells based on Date of Arrival and Date of Departure 1
Firing Blanks 5

Back
Top