Help with print format

[Leigh Digons]

FYI: All of the titles and numbers are linked to pivot tables in other tabs but I have hard-coded everything for the purposes of this question. But need to know that to answer it.

How do I lay out this tab better so that I can print and continue the titles on the left? i.e. if the Class of 2010 rows spill over to another page while printing I want the Class of 2010 name to appear at the top again. Is there a better way to lay this out?

 

[Chihiro]

Personally, I'd just repeat item labels.

 

[Leigh Digons]

Where is that located in Excel? Those options?

 

[Leigh Digons]

This isn't a pivot table just linked.

 

[Chihiro]

In that case...

First unmerge cells in Column A.
Then select A7:A212.
Find&Select->Go to Special
Select "Blank" and hit ok.

Without changing selection, type =A7 and hit Cntrl + Enter.

You can copy and paste over as values or just keep the formula as is.