software

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.

quot;Richard Squot; lt;Richard gt; wrote in message
...
gt;I would like to apply Page Setup settings (margins, header/footer, etc.) to
gt; all sheets of an existing Excel file without going into each sheet. I know
gt; I
gt; can copy a sheet and the settings will be copied with it, but this is an
gt; existing file.
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.

quot;Richard Squot; wrote:

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

Richard

Select one sheet then right-click and quot;Select all sheetsquot;

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 lt;Richard
gt; wrote:

gt;I would like to apply Page Setup settings (margins, header/footer, etc.) to
gt;all sheets of an existing Excel file without going into each sheet. I know I
gt;can copy a sheet and the settings will be copied with it, but this is an
gt;existing file.In article gt;, lt;Andygt; wrote:
gt;Hi
gt;
gt;Group the sheets you want to change. Change one of them and they all follow
gt;suite!!
gt;To group, click the first tab and then Shift-click the last tab.

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 gt;quot;Richard Squot; lt;Richard gt; wrote in message
...
gt;gt;I would like to apply Page Setup settings (margins, header/footer, etc.) to
gt;gt; all sheets of an existing Excel file without going into each sheet. I know
gt;gt; I
gt;gt; can copy a sheet and the settings will be copied with it, but this is an
gt;gt; existing file.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)