Global Footers in Excel

[David]

Does anyone know how to take an Excel workbook that has
multiple worksheets and create a footer (say one that
lists the page number, the tab name, and the file name),
and make that footer a "global footer" such that I don't
have to set the footer for some 10 to 20 worksheets when
they're practically identical?

Thanks.

DTP

 

[Gord Dibben]

David

Right-click on one worksheet tab and "select all sheets".

Set up your footer on the active sheet and these settings will be replicated
on all sheets.

DO NOT FORGET to right-click and "ungroup sheets" when done. What you are
doing to active sheet is being done to all sheets when grouped.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
one way: select all your sheets (group them) before
applying the header/footer.

 

[David]

Thanks!

DTP

-----Original Message-----
David

Right-click on one worksheet tab and "select all sheets".

Set up your footer on the active sheet and these settings will be replicated
on all sheets.

DO NOT FORGET to right-click and "ungroup sheets" when done. What you are
doing to active sheet is being done to all sheets when grouped.

Gord Dibben Excel MVP



.

 

[David]

Thanks!

DTP

-----Original Message-----
Hi
one way: select all your sheets (group them) before
applying the header/footer.

.