View Single Post
  #2   Report Post  
Naz
 
Posts: n/a
Default print column labels with one row of data at a time.

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