I just recently started a new job and I'm using an existing Workbook.
This workbook has multiple pages and I need to add a header, footer,
change margins and reset columns. Can anyone tell me how to apply this
to the entire workbook so i don't spend hours changing each page? The
previous user was linking to Word and printing there but it can be done
from Excel if I can get these changes made. thanks for any help.


--
Toysforfids
------------------------------------------------------------------------
Toysforfids's Profile: http://www.excelforum.com/member.php...o&userid=37655
View this thread: http://www.excelforum.com/showthread...hreadid=572633

If by "pages" you mean worksheets, you can group the sheets and do them all at
once.

Select a sheet.

Right-click on the sheet tab and "select all sheets".

Do your page setup on the active sheet and will be done to all sheets.

DO NOT FORGET to ungroup the sheets when setup is complete.

Either right-click and "ungroup" or select any sheet but the active sheet.


Gord Dibben MS Excel MVP


On Thu, 17 Aug 2006 10:03:32 -0400, Toysforfids
wrote:


I just recently started a new job and I'm using an existing Workbook.
This workbook has multiple pages and I need to add a header, footer,
change margins and reset columns. Can anyone tell me how to apply this
to the entire workbook so i don't spend hours changing each page? The
previous user was linking to Word and printing there but it can be done
from Excel if I can get these changes made. thanks for any help.

Thank you for the help. This workbook is a monster.


--
Toysforfids
------------------------------------------------------------------------
Toysforfids's Profile: http://www.excelforum.com/member.php...o&userid=37655
View this thread: http://www.excelforum.com/showthread...hreadid=572633