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