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

Discussion in 'Microsoft Excel Crashes' started by wimaint, Mar 7, 2009.

  1. wimaint

    wimaint Guest

    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.
     
    wimaint, Mar 7, 2009
    #1
    1. Advertisements

  2. 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.

    --
    If this helps, please click the Yes button.

    Cheers,
    Shane Devenshire


    "wimaint" wrote:

    > 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.
     
    Shane Devenshire, Mar 7, 2009
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page