Cell Fomula

N

Ninfa

How do I clear a spreadsheet (or columns) but retain the formulas to be used
over and over for different projects?
 
P

Paul B

Ninfa, one way, edit, goto, special, check constants, OK, then delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
N

Ninfa

Thanks Paul, but what I do if I'm using Excel 2000? It doesn't have special
under edit.
Ninfa
 
P

Peo Sjoblom

Paul said edit>goto, then click special etc You can also press shortcut F5,
then special and constants etc

Regards,

Peo Sjoblom
 
Top