Can I apply page settings to all sheets in Excel?

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.

"Richard S" <Richard [email protected]> wrote in message
news:[email protected]...
>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.

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 S" wrote:

> 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.

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
[email protected]> wrote:

>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.

In article <uF#[email protected]>, <Andy> wrote:
>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.

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


>"Richard S" <Richard [email protected]> wrote in message
>news:[email protected]...
>>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.


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)