How do I have row 1 appear on each page?

D

DF

Using Excel 97. I have made a record collection list, Artist , Title,
Label, Catalog Number etc as the Heading For row 1 and colums a,b,c,d etc.
When I print the excel program I want those to appear on the top of each
page. I could not find an answer in the HELP
section. Thanks for your help....Doug
 
J

JulieD

Hi DF

choose file / page setup and go to the sheet tab
click in the box next to rows to repeat at top
then click on row #1 on your worksheet
click Preview and you should have what you're after.

Cheers
JulieD
 
P

Paul B

DF, file, page setup, sheet, rows to repeat at top $1:$1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
 

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

White space above heading inconsistently applied 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Text to Rows 0
Row Numbering 1
Having Blank Cells, etc. ? 1
Help with cell referencing. 0
How can I count deviations between two rows? 4

Top