Top three lines on every page.

C

Clayton L. Wilson

At the top of my excel file, I have three lines. How can I
get these three lines to be printed on each page?
 
A

Andy

Clayton

Got File>Page Setup>Sheet tab. Put the range in the Rows to Repeat at Top
box (ie $1:$3)

Andy
 
J

James Cements

On menu select:
File | Page Setup
On the Page Setup Select : The Tab "SHEET"
Click into the option: Rows to repeat at top:
.... then type $1:$3 ... this will select
the text in rows 1 thru 3 to appear on every printed
page.

Good luck, Jim
 

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

Top