Excel 2003. Re-use a spreadsheet?

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?
 
F

FSt1

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
 
Top