If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then:

Edit Go To Special... and click Constants and then OK
this selects the data, but not the formulae
Edit Clear All
clears out the data
--
Gary's Student


"Tom Hall" wrote:

In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

--
remove .spoo to reply by email