View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Can I delete the data and keep formulas for a whole worksheet?

hi
press the F5 key. this will bring up the goto dialog
click the special button at bottom left. this will bring up the got special
dialog
check the constrants options.
click ok.
this should highlight all of your data but not your fomulas.
press the delete key.
data gone. formulas still there.

Regards
FSt1
"Annette" wrote:

I keep records of individuals donations for our church . I want to close out
the worksheet for the past year and delete the information but keep all the
formulas for compulation of this years data. Can I do this easily?