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?