How do I show the Header on all pages?

[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!

 

[YESHWANT]

click on file, page setup, header/footer, make the desired changes and u r at
home.

 

[YESHWANT]

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.

 

[Gord Dibben]

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

 

[Bons]

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!!

 

[Fred Smith]

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