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

"The Boondock Saint" <robport@(no-spam)inspire.net.nz> wrote in message news:43caffb7@clear.net.nz...
> 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
>
>

[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" <dmcritchie_xlmvp@verizon.net> wrote in message
news:uLG7OakGGHA.1312@TK2MSFTNGP09.phx.gbl...
>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.
> ---
> 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
>
> "The Boondock Saint" <robport@(no-spam)inspire.net.nz> wrote in message
> news:43caffb7@clear.net.nz...
>> 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]

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

"The Boondock Saint" <robport@(no-spam)inspire.net.nz> wrote in message news:43cb11e8@clear.net.nz...
> 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" <dmcritchie_xlmvp@verizon.net> wrote in message
> news:uLG7OakGGHA.1312@TK2MSFTNGP09.phx.gbl...
> >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.
> > ---
> > 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
> >
> > "The Boondock Saint" <robport@(no-spam)inspire.net.nz> wrote in message
> > news:43caffb7@clear.net.nz...
> >> 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
> >>
> >>
> >
> >
>
>