I inherited a workbook with five worksheets. Each worksheet has title
information in row 2. In one of the sheets, I can select, say, data in row
5, goto Print, choose selection, and I can print the title row with row 5
directly under. On other worksheets laid out similarly, the same procedure
prints two pages -- the title on one page and the row 5 data on the second
page.

On all of the worksheets, the option to print titles (Print Preview, Setup,
Sheet) is grayed out.

Any suggestions on how to print data from row 1 and row 5 on the same page?

Thanks,
Craig.