Displaying Page Header On Screen

[The Boondock Saint]

Hi all
I have a worksheet and the worksheet has a header. What I want is when you
open excel and the worsheet comes up, I want to he able to see the header
on the page. Cant seem to find a way to do this though.

Any thoughts?

Cheers
The Saint

 

[David McRitchie]

I guess you are thinking of MS Word, but Excel does not work
that way. You can use the Print Preview button to see the page
as it would be printed.

 

[The Boondock Saint]

Thanks David...
Is there a easy way you can say format cells to look like a header... and
then copy it to multiple sheets.

 

[David McRitchie]

You could use the File, Page Setup, Sheets
for example -- Rows to repeat at top: 1:4
As a variation you could repeat rows 2:3 at the
top of subsequent pages.

On the other sheets you could assign their values
to the master sheet. i.e.
A1: ='master sheet'!A1

If you forget how this is done you would place
an equal sign in cell to the master sheet and
click on cell A1 then return to the sheet with the
equal sign and hit Enter.