Deleting cell data without deleting formula
On Sat, 28 Oct 2006 11:30:01 -0700, Gary''s Student
wrote:
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
Thanks!
The others who replied pointed out a flaw in my thinking, but you've
actually given me what I was looking for.
Thanks again!
Tom
--
remove .spoo to reply by email
|