Applying a Header to Workbook

[Kerri]

How do I apply a header to an entire workbook? What I
really want is for the header to print on every page. I
would also like the page numbers to appear as the footer.
Thanks for your help,
Kerri

 

[JudithJubilee]

You need to right click over any Sheet tab and choose
Select all sheets. The tabs will all appear white. This
means that they are linked and whatever you do to one
sheet will be done to them all.

Go ahead and insert the Header and Footer as normal.

Hope this helps

Judith

 

[David McRitchie]

Hi Kerri,
You would need to use a workbook event macro in ThisWorkBook.
Using Workbook_BeforePrint to automate printing of heading/footing (#beforeprint)
http://www.mvps.org/dmcritchie/excel/pathname.htm#beforeprint

 

[tghcogo]

From the file menu select Page Setup

Choose the Header Footer Tab and then select Custom Header for you
title, you can play around with fonts and sizes.

For page numbering choose Custom Footer and select the icon with +'s o
it, or alternatively type in &[Pages]


TGHCOG