Some type of header

  • Thread starter Thread starter david
  • Start date Start date
D

david

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

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 said:
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 said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header Text 1
Quick way to expand all columns to show all data? 4
Column Header 1
Access Sorting and grouping using multiple tables 0
Row 1 HEADERS on EVERY printed page 2
Display index of column headers in column A 9
Autofilter header row 3
Header and Footer margins 1

Back
Top