Excel 2003. Re-use a spreadsheet?

  • Thread starter Thread starter MollyO
  • Start date Start date
M

MollyO

I want to delete all the data but keep the formulas. I made a copy of the
original workbook and cleared the data but now I have no formulas. What did I
do wrong?
 
hi
not sure how you cleared the data but you may have deleted the formulas too.
try this......
make a copy of the original workbook again. in the new copy, hit the f5 key
to bring up the goto dialog. click the special button at the bottom. on the
special go special dailog, click contraints the ok.
all non formula data should be high lighted. delete.
data should be gone. formulas remain.


Regards
FSt1
 
Great! Thanks for the replies. I will attempt this soon and see how it goes.

Molly
 
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

How to copy a whole Excel spreadsheet page in 2007 vs 2003? 2
Excel Help to copy information from one row at a time to another sheet 1
Excel 2003 worksheet doesn't auto calculate 4
save workbook, erase data but keep formula 4
Excel 2003 Break Links 3
Copy or Move a spreadsheet 1
Excel Protection 2
Formula's in linking spreadsheets 1

Back
Top