Can I apply page settings to all sheets in Excel?

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

Guest

I would like to apply Page Setup settings (margins, header/footer, etc.) to
all sheets of an existing Excel file without going into each sheet. I know I
can copy a sheet and the settings will be copied with it, but this is an
existing file.
 
Hi

Group the sheets you want to change. Change one of them and they all follow
suite!!
To group, click the first tab and then Shift-click the last tab.

Andy.
 
I don't know about pasting the settings, but you can highlight multiple
worksheet tabs and then go to Page Setup, and the options you select will
affect all of the highlighted sheets.
 
Richard

Select one sheet then right-click and "Select all sheets"

Do your page setrup on the active sheet and will done to all.

Note: you cannot set a print range or rows/columns to repeat using this method.


Gord Dibben MS Excel MVP

On Mon, 23 Jan 2006 09:11:02 -0800, Richard S <Richard
 
Hi

Group the sheets you want to change. Change one of them and they all follow
suite!!
To group, click the first tab and then Shift-click the last tab.
Click to expand...

As an extra piece of advice, once you have finished, be sure to ungroup your
sheets again. You can do a lot of damage in a short time if you don't :)



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Back
Top