Cell Fomula
 

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

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

"Ninfa" wrote in message
...
How do I clear a spreadsheet (or columns) but retain the formulas to be
used
over and over for different projects?

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

"Paul B" wrote:

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

"Ninfa" wrote in message
...
How do I clear a spreadsheet (or columns) but retain the formulas to be
used
over and over for different projects?

Paul said editgoto, then click special etc You can also press shortcut F5,
then special and constants etc

Regards,

Peo Sjoblom


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

"Paul B" wrote:

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

"Ninfa" wrote in message
...
How do I clear a spreadsheet (or columns) but retain the formulas to
be
used
over and over for different projects?