Headers in Excel

L

Lynne

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
 
G

GA@EC

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

FSt1

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

regards
FSt1
 
G

Gord Dibben

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
 
L

Lynne

Hi GA,

Where do I get into Page layout?

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

Lynne

Hi FSt1 - that worked great. Thanks.

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

Lynne
 
F

FSt1

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

regards
FSt1
 
Top