Excel contiguous print error

Contiguous print error
Contiguous print error

Contiguous print error

A common problem in excel is the contiguous print error. This error makes it seem impossible to print the excel worksheet you are working on. The error message displayed is as follows:

"Print titles must be contiguous and complete rows or columns "

The fix

The fix for the contiguous print problem is straight forward although not immediately obvious.

Firstly click on the Page layout tab and click on the Print Tiles button.


Click on the print layout tab as above then find the print tiles button and click on it.
Click on the print layout tab as above then find the print tiles button and click on it.

Step 2: Fix contiguous print error

To fix the contiguous print error bring up the print tiles menu screen as shown below and find the drop-down menu which says cell errors.

Click on the Cell Errors drop down box and move this from displayed to <Blank>.

Click on the error display drop box and change this from "displayed" to
Click on the error display drop box and change this from "displayed" to

Problem solved

After this you should be able to print the page, or preview the page without the error "Print titles must be contiguous and complete rows or columns "

You will need to repeat this fix for every worksheet that is affected by the contiguous print error.

More by this Author


Comments

No comments yet.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working