How do I clear data values wthout losing the formulas?

G

Guest

I am attempting to save a workbook as a template. I am to "Clear all the
data values from the section worksheets and then save the workbook as an
Excel template" When I try to clear the data values the formulas disappear
also, which I need to keep for the template. Any help would be appreciated.
 

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

why do print range erase in Excel when import data from access 1
How can I transfer formulas between 2 Excel workbooks? 4
transfering cell values progressively through worksheets 8
Compatibility Mode error w/ Defined Names 1
Update Source data in a formula 2
Quick way for monthly linking of Excel sheets 0
clear data from workbook 1
VBA - retrieve data on last create named range from previous inserted named range 0

Top