Select the range ...then press function key F5...click on Special and select
constant.

Hit the delete key ..


"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?