Some type of header

I've got a spreadsheet with some type of header which isn't a normal header,
please could someone tell me what it is. The first page has normal text on
the first row then the second row is a series of headers at the top of each
column. The second
row appears as the first row in subsequent pages. When I look under view ->
header and footer, there is nothing there, so it's not done in the normal
way. There's nothing under custom-header either.


FIRST PAGE....

text text text text text text

headcol1 headercol2 headercol3

data data data




SECOND PAGE....

headcol1 headercol2 headercol3

data data data

I suspect that this is being controled from the File | Page Setup menu. Open
that up and look at the [Sheet] tab and see if there is an entry in the "Rows
to Repeat at top" option. I think you're going to find the answer there, it
will probably refer to the rows that are repeating on all sheets.

"david" wrote:

> I've got a spreadsheet with some type of header which isn't a normal header,
> please could someone tell me what it is. The first page has normal text on
> the first row then the second row is a series of headers at the top of each
> column. The second
> row appears as the first row in subsequent pages. When I look under view ->
> header and footer, there is nothing there, so it's not done in the normal
> way. There's nothing under custom-header either.
>
>
> FIRST PAGE....
>
> text text text text text text
>
> headcol1 headercol2 headercol3
>
> data data data
>
>
>
>
> SECOND PAGE....
>
> headcol1 headercol2 headercol3
>
> data data data
>
>
>
>
>
>

Look under:

<File> <Page SetUp> <Sheet> tab,

And see what's entered in:
"Rows To Repeat At Top".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"david" <nopam@nospam.com> wrote in message
news:TMSdncV3LaaNDTvZRVnyvA@bt.com...
I've got a spreadsheet with some type of header which isn't a normal header,
please could someone tell me what it is. The first page has normal text on
the first row then the second row is a series of headers at the top of each
column. The second
row appears as the first row in subsequent pages. When I look under view ->
header and footer, there is nothing there, so it's not done in the normal
way. There's nothing under custom-header either.


FIRST PAGE....

text text text text text text

headcol1 headercol2 headercol3

data data data




SECOND PAGE....

headcol1 headercol2 headercol3

data data data

JLatham and RagDyeR, many thanks for your quick and helpful replies. Have
found it now, it's there where you said :-))
David

"JLatham" <JLatham@discussions.microsoft.com> wrote in message
news:A766B921-65EA-4A28-885B-14405732B60D@microsoft.com...
> I suspect that this is being controled from the File | Page Setup menu.
Open
> that up and look at the [Sheet] tab and see if there is an entry in the
"Rows
> to Repeat at top" option. I think you're going to find the answer there,
it
> will probably refer to the rows that are repeating on all sheets.
>
> "david" wrote:
>
> > I've got a spreadsheet with some type of header which isn't a normal
header,
> > please could someone tell me what it is. The first page has normal text
on
> > the first row then the second row is a series of headers at the top of
each
> > column. The second
> > row appears as the first row in subsequent pages. When I look under
view ->
> > header and footer, there is nothing there, so it's not done in the
normal
> > way. There's nothing under custom-header either.
> >
> >
> > FIRST PAGE....
> >
> > text text text text text text
> >
> > headcol1 headercol2 headercol3
> >
> > data data data
> >
> >
> >
> >
> > SECOND PAGE....
> >
> > headcol1 headercol2 headercol3
> >
> > data data data
> >
> >
> >
> >
> >
> >