Header, Footer, Column Width, Margins

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.

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
<Toysforfids.2cotif_1155823506.4207@excelforum-nospam.com> 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.