Looking to copy a worksheet with all formats and formulas without coping inputed data

[God's Kid]

I am looking to copy a spreadsheet from one year to the next with all
the same formats and formulas. I do not want to copy the inputed data
since the inputed data with be new with the new year. Thank you for
the input

 

[Anne Troy]

If it were me, I'd copy the whole sheet and delete the inputted data.
************
Anne Troy
www.OfficeArticles.com

 

[lgarcia]

Why do not you try "edit" - "special past" - "format

 

[paul]

me too!
--
paul
remove nospam for email addy!

If it were me, I'd copy the whole sheet and delete the inputted data.
************
Anne Troy
www.OfficeArticles.com