Rows to repeat at top: that are NOT contiguous and complete

[Laurinda]

Hi,
I'm trying to select rows 1 through 5 & row 15 to repeat at the top, but when I try to select those rows in page setup it says, "Print titles must be contiguous and complete rows or columns."

Is there any way around this?

Thanks,
Laurinda

 

[VoG]

sorry, no. It has to be a contiguous range.

 

[shg]

You could hide rows 6:14.