Can I copy Everything in a worksheet to a new sheet EXCEPT the te

Can I copy Everything in a worksheet to a new sheet EXCEPT the te

Post by YnVkZHlvcm » Thu, 23 Mar 2006 18:03:26


I use the same worksheet month after month, however when I create a new month
sheet and copy and paste last months to it, I either have to paste All or
just formats, formulas or ... I have to manually delete All the text (and
sometimes there is Lots)
I cant just clear it because I loose all my formulas.

I have been doing this for all most two years, and I know there is a lot
easier way, but I haven't found it.

Thanks,
 
 
 

Can I copy Everything in a worksheet to a new sheet EXCEPT the te

Post by Mikeopol » Thu, 23 Mar 2006 18:13:22


If you set up your spreadsheet exactly as you want it, then save it a
normal (just as a backup), then delete all the values and cells tha
change each month, then save it as change the file type to template
Then close it.

To re-use the template, select File New and browse to your template.
copy will be presented, and you can save that as a normal file, you
template won't be changed.

Regards
Mik