Headers in Excel
 

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne

Headers in Excel
 

Lynne,
If I'm understanding you correctly, you should go to Page Layout, Page
Setup, click on the Sheet tab, put cursor in "repeat rows at top" then select
the top rows you would like repeated. click ok.
--
GA


"Lynne" wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne

Headers in Excel
 

hi
filesetupsheet tab
file in the "rows to repeat at top:" with the row number ie $1:$1

regards
FSt1

"Lynne" wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne

Headers in Excel
 

One worksheet...........rows to repeat at top.

Cannot be done across multiple worksheets if that's what you're trying to
do.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 12:29:17 -0700, Lynne
wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page

Headers in Excel
 

Hi GA,

Where do I get into Page layout?

I have been going in under "File, page setup, sheet".
--
Lynne


"GA@EC" wrote:

Lynne,
If I'm understanding you correctly, you should go to Page Layout, Page
Setup, click on the Sheet tab, put cursor in "repeat rows at top" then select
the top rows you would like repeated. click ok.
--
GA


"Lynne" wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne

Headers in Excel
 

Hi FSt1 - that worked great. Thanks.

How well do you know word (older versions and newer versions)?

Lynne
--
Lynne


"FSt1" wrote:

hi
filesetupsheet tab
file in the "rows to repeat at top:" with the row number ie $1:$1

regards
FSt1

"Lynne" wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne

Headers in Excel
 

hi
i can type words and letters in it. sometimes complete sentences. but beyond
that, i am a novice to word.

regards
FSt1

"Lynne" wrote:

Hi FSt1 - that worked great. Thanks.

How well do you know word (older versions and newer versions)?

Lynne
--
Lynne


"FSt1" wrote:

hi
filesetupsheet tab
file in the "rows to repeat at top:" with the row number ie $1:$1

regards
FSt1

"Lynne" wrote:

I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column
for printing and then print and I only get the headings of the columns on the
first page printed.

How do I get the column headings to show on each page
--
Lynne