Create and configure one sheet exactly as you wish, then ... copy it!

hold down <Ctrl
click on the sheet tab and drag it to the right.
release the mouse first, then <Ctrl.

You now have an exact duplicate of the sheet you created.

Just rename it as necessary.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jmsdvdp" wrote in message
...
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...