Creating a header using non-contiguous rows

B

Bernie Doepkens

Using Excel 2000
I am using the FILE/Page Setup/Sheet tab/Rows to repeat at
top
technique to create a header. I currently have $1:$4 in
the Rows to repeat at top. I also want to include rows 15
and 16. I have not found a way to do this. Any suggestions?
 
G

Gord Dibben

Bernie

No way to do this.

"Print titles must contiguous and complete rows or columns" is the error
message you get when you try to select non-contiguous rows.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to repeat 2 contiguous rows to top of each page 2
Footer 1
Header rows 4
Insert automatic page numbering into a cell, not a header or foote 1
macro to repeat non contiguous rows at top in Print 2
Rows to Keep at Top... 2
Repeat Rows at Top - Except Final Page 2
Printing non-contiguous rows at the top 1

Top