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?