You need to do each sheet individually, or copy the sheet that you have set
up and use it as your sheet template.

HTH,
Bernie
MS Excel MVP

"mreed46112" wrote in message
...
I am having trouble getting all sheets in the workbook to print the same.
I
have tried selecting all sheets and setting up my header and footer,
margins,
etc. But, when I then go to print preview, only the first sheet in the
workbook has held the settings.