How can I update a spreadsheet for a new season of records?

[Guest]

I use a spreadsheet to track fees paid by members of two different bowling
leagues. Is there an easy way to delete the information that was entered for
last year and then change the dates for this season??

 

[R.VENKATARAMAN]

why not create a spradsheet only with column or row headings and save it as
a template

 

[Gord Dibben]

Linda

If you have formulas on the worksheet(s) you want to preserve.......

Select all cells the Edit>Go To>Special>Constants. Checkmark the constants you
want to select and OK.

With these selected, Edit>Clear Contents.

The dates you can replace using Edit>Replace.

I would then save the file as a Template so's you don't have to do this again
next year.


Gord Dibben Excel MVP