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


G

Guest

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?
 
Ad

Advertisements

G

Guest

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

Advertisements

R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top