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

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

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

"God's Kid" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> God's Kid
> ------------------------------------------------------------------------
> God's Kid's Profile:
> http://www.excelforum.com/member.php...o&userid=28426
> View this thread: http://www.excelforum.com/showthread...hreadid=480194
>

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

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



"Anne Troy" wrote:

> If it were me, I'd copy the whole sheet and delete the inputted data.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "God's Kid" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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
> >
> >
> > --
> > God's Kid
> > ------------------------------------------------------------------------
> > God's Kid's Profile:
> > http://www.excelforum.com/member.php...o&userid=28426
> > View this thread: http://www.excelforum.com/showthread...hreadid=480194
> >
>
>
>