You may want to write a macro to do this. I'm new to VB so am
cross-posting this in microsoft.public.excel.programming.


"gooba937" <gooba937@discussions.microsoft.com> wrote in message
news:06EDDC21-7BF2-4891-B7B4-DCC85280C6A7@microsoft.com...
>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??