View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tom Hall Tom Hall is offline
external usenet poster
 
Posts: 17
Default 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