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

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?

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

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

"MQS" wrote:

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?

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

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.

"Barb Reinhardt" wrote:

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

"MQS" wrote:

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?

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

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...........

"Barb Reinhardt" wrote:

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

"MQS" wrote:

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?