SliderSteve

Because you don't normally enter data into a cell that also has a formula,
this will work to clean all the old data out leaving only the formulas for
new data. Before you do this PLEASE back up you worksheet!!!

Select your entire worksheet(or the area you want to
cleanup)Goto"Edit""Go To""Special""Constants"Select all that Apply"OK".

Now all is hilited just delete the contents (I prefer right click and select
Clear Contents) Your worksheet is now ready for the new data, with all
formulas still in place. Be sure and read and follow the other advise you've
recieved it is good stuff to do.

Mike Rogers

"SliderSteve" wrote:

I have been asked to look at a pronblem with a colleagues spreadsheet in
Excel. When you clear data within a cell, so new data can be added the
formula for teh cell has also been deleted.

Is there a way to set cells to maintain underlying formulas by default?