Header, Footer, Column Width, Margins

[Toysforfids]

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.

 

[Gord Dibben]

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

 

[Toysforfids]

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