Creating a header using non-contiguous rows

  • Thread starter Thread starter Bernie Doepkens
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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

Header rows 4
Insert automatic page numbering into a cell, not a header or foote 1
Footer 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Showing Letters For Column Headers Rather Thann Numbers ? 1
Macro to repeat 2 contiguous rows to top of each page 2
macro to repeat non contiguous rows at top in Print 2
macros and non-contiguous copying 1

Back
Top