Worksheet to template

M

Michael

I have a worksheet with data and formulas from 2003. I
want to use the same setup for 2004, including formulas,
but starting from January 2004 with data I input from
December, 2003. How do I clear the 2003 worksheet of
values without clearing the formulas, to then save it as a
template for each year thereafter?
 
P

Paul B

Michael, try edit, goto, special, constants, delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
D

DNF Karran

Select the data range then hit ctrl+G to bring up the "Go to" form an
click special. If you select constants it will select any cells that d
not contain formulae. You can then hit delete and using "save as" sav
the file as type "excel template" (*.xlt).

Dunca
 
Top