How can I do "page set up" for a every page in a workbook at one .
 

I would like to set up headers and footers and other page setup options that
would propigate to all pages in a workbook without having to open and set up
each page.

Group the sheets first, everything you then do is duplicated on all grouped
sheets.

To group them, click on a sheet tab and then hold down the shift key and
click on another (They will both be selected and any in between and [Group]
will show in the title bar). If you wish to group non-contiguous sheets use
control instead of shift.

To un-group, click on any non-grouped sheet tab or right click on any
grouped one and select 'un-group'

Shortcut key to group/ungroup Ctrl+Shift+PgUp/Down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"elizapo" wrote in message
...
I would like to set up headers and footers and other page setup options
that
would propigate to all pages in a workbook without having to open and set
up
each page.