ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Some type of header (https://www.excelbanter.com/excel-discussion-misc-queries/97161-some-type-header.html)

david

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






JLatham

Some type of header
 
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







RagDyeR

Some type of header
 
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" wrote in message
...
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







david

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

"JLatham" wrote in message
...
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















All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com