Applying a Header to Workbook

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

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


-----Original Message-----
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
.

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...tm#beforeprint

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kerri" wrote in message ...
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

From the file menu select Page Setup

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

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


TGHCOGO


---
Message posted from http://www.ExcelForum.com/