How do I show the Header on all pages?

  • Thread starter Thread starter Bons
  • Start date Start date
B

Bons

In 2003 how do I show the Header (the Custom Header -- NOT the column
headings) on all pages? I KNOW I've done this in the past, but cannot
remember how I did that. Thanks in advance---I KNOW one of you geniuses will
know the answer to this!
 
click on file, page setup, header/footer, make the desired changes and u r at
home.
 
if u want to format header and/or footer for all sheets in an given workbook,
open the file, on the sheet tab right click and click on "select all sheets"
and the n do as already explained i.e. click on file, page setup,
header/footer, carry out necessary changes and u r at home, i think.
 
Just note that most print settings for all sheets will take on the format of
the active sheet when sheets are grouped.

Not just the header/footer.


Gord Dibben MS Excel MVP
 
Thank you very much for responding!!!!.....but it isn't working....I know how
to set up the Header under file--page set up---but I'm not finding any
"select all sheets" anywhere....... I've tried right clicking all over the
place and cannot find the select all sheets....... what am i missing??? I
use Excel all the time and am pretty literate in it, but am totally stymied
by this. Thanks again for trying to help me!!
 
Right-click on the Tab of the sheet (the one at the bottom showing the name
of the sheet). It gives you the Select All Sheets option.

Regards,
Fred
 
Back
Top