Copy formatting (headers, margins, etc) to another sheet?

[MQS]

Is it possible to copy formatting (headers, margins, etc) from one sheet to
another?
I need to add sheets to a workbook that are set up just like an existing
sheet. I can copy my "model sheet" and get the fonts, formats, formulas,
etc, but then have been individually modifying the page setup for each new
sheet. Is there a way to save the page setup info and apply it to the new
sheet?

 

[Barb Reinhardt]

Are you right clicking on the worksheet tab and copying that way?

 

[MQS]

No, I didn't know that trick! Thanks, that's exactly what I was looking for!
I knew there had to be some way to do it, but couldn't find that tidbit in
the help file.

 

[rontiara]

Right clicking on the tab works great if you want to copy the worksheet as
well as the page setup, but I only want to copy the page setup. There are
errors on the page itself so I don't want to copy that.

Is there a way to copy just the page setup?

Thanks...........