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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Back
Top