Assuming:
Headings are in Rows 1 and 2
Student names are in Col A

Try this:
•Select Cell A3
•From the main menu: Select Insert>Page Break
•Select Cell A4
•Press the [F4] key (that will repeat the last action-->setting Page Break)
•Continue selecting subsequent cells and pressing [F4] until no more student
names

•From the main menu: File>Page Setup
•Click the Sheet tab
-Set Rows to Repeat at top to: $1:$2
-Set Print area to the rows with students
-When done click [OK]

•Click the Print Preview button or select File>Print Preview

You should see Page 1 of (some number of page) and each page should only
contain the headers and one student's record.

Does that help?

••••••••••
Regards,
Ron


"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??