Right-Click on any tab name, choose 'Select all sheets' and do the page setup
you want. They will be applied to all the sheets...

"jmsdvdp" wrote:

I am making a workbook that will have many worksheets, and each worksheet
will be the same except for information entered into them each week. Is
there a way to do this without having to go into page setup from the print
preview screen for each workbook? This is very time consuming. One I've
done from the past is a household inventory book; each room has it's own
worksheet, but all the worksheets have the same layout, margins, headers,
footers, etc.
Thanks...