Print error=Print titles must be contiguous and complete rows/colu

W

wimaint

I tried printing a usual .xlsx documents and got the error message:
Print Titles Must Be Contiguous and Complete Rows or Columns.

I dont know what this means.
How do I correct this problem?

I ended up copying the contents of the worksheet AS IS and pasted onto a new
blank worksheet and it print just fine.

I dont understand.
Thanks.
 
S

Shane Devenshire

Hi,

Hi Michael,

Most likely you are trying to specify both rows and columns as print titles
in a single area. You must set rows for the print titles at the top of each
page and you must specify columns for the print titles you want to see at
the left. In other words you should have something like this in the Rows to
repeat at top box $1:$3 and something like $A:$B in the Columns to repeat at
left. A reference like $A:$B,$1:$2 in either box will generate the above
error.
 

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

Print titles must be contiguous and complete rows or columns 18
Error with print titles not being contiguous 1
Print titles must be contiguous and complete rows or columns 3
Print titles must be contiguous and complete rows or columns 3
Print Error Message: Print titles must be contiguous and complete 1
Print titles must be contiguous and complete rows or columns 1
"Print titles must be contiguos and complete rows or columns?" 1
Printing Excel Entire Workbook 5

Top