You are right. That is what I am trying to do keeping the same headers.

"Barb Reinhardt" wrote:

Naz,

I think the question is how do you print one page for row 2, another for Row
3, another for row 4, etc, for the entire class.

Barb
"Naz" wrote in message
...
Go to
File Page Setup Sheet

Then in the "Rows to repeat at top" highlight the label headings row(s).

HTH
--

_______________________
Naz,
London


"gooba937" wrote:

I am a teacher. I have created my gradebook in excel. (I don't have
access). I have 7 worksheets (one for each class that I teach). The
worksheets are not exactly the same.

I would like to be able to print out the top two rows (column labels)
with
each students data (row). This way the student can see row 1 (name of
assignment), row 2 (points), their row (their personal data for each
assignment).

Any help??