These are 2 separate settings. The first, which "locks" the rows on the
screen is called "Freeze Panes" and can be found in the WINDOW Menu. Select
either the Row below where you want to Freeze, or the column to the right of
where you want to freeze. Or Freeze both row and column by selecting just a
single cell.

To get the rows to print at the top of each page, goto the File Menu, then
Page Setup. Goto the Sheet Tab. You should see a section called "Rows to
repeat at top". Enter your rows here.

HTH,
Elkar


"MattieSy" wrote:


I'm not even sure what you call this. I have this spreadsheet that I use
in place of a checkbook register (don't remember where I got it).
Anyways, The first four rows are i guess you could call it "scroll
locked" and stay in place when you scroll, and when you print it prints
at the top of each page. Ive checked everything and I cant figure out
how to do it, and i want to use that for another spreadsheet I'm
working on.

Thanks in advance,

Matt


--
MattieSy
------------------------------------------------------------------------
MattieSy's Profile: http://www.excelforum.com/member.php...o&userid=35060
View this thread: http://www.excelforum.com/showthread...hreadid=548029