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

Try this:
€¢Select Cell A3
€¢From the main menu: Select InsertPage 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: FilePage 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 FilePrint 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??