Set up one of your sheets with all the settings that you wish.

Then, hold <Ctrl, and click on the tabs of the other sheets that you wish
to have the same settings.

What you've done is "Group" the sheets, and you will see this (Group) in the
title bar.
The tabs will be white, with the "master" sheet in bold.

Now, just
<File <PageSetUp <OK
And you're done.

Make sure that the already formatted (master) sheet is in bold (in focus),
since this procedure will overwrite the settings of the other sheets, and if
you accidentally chose a non-formatted sheet as the focus sheet, it would
overwrite (erase) the settings that you set-up on your main (master) sheet.

And finally, make sure you "Ungroup" when you're finished by either right
clicking in a tab and click on "ungroup", or click in one of the tabs of an
unselected sheet.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"bruce" wrote in message
...
How do you copy pint setting from one tab or spreadsheet to another
including
the header and footer settings?

Thanks, Bruce