Applying a Header to Workbook

  • Thread starter Thread starter Kerri
  • Start date Start date
K

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
 
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
 
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
 
Back
Top