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

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

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



"Linda" wrote in message
...
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??

Linda

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

Select all cells the EditGo ToSpecialConstants. Checkmark the constants you
want to select and OK.

With these selected, EditClear Contents.

The dates you can replace using EditReplace.

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

On Mon, 12 Sep 2005 19:56:01 -0700, "Linda"
wrote:

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