If you can't print your workbook in Microsoft Excel 2016/2013 due to "Print titles must be contiguous and complete rows or columns" warning, fix it here.

Today in this article we’re addressing a strange problem that occurs while you print an Microsoft Excel sheet. This is related to print titles for your worksheets and became massive issue while you’re printing a large number of sheets.

In this scenario, whenever you try to print or want to see print preview for any Excel sheet, you get this warning message:

Print titles must be contiguous and complete rows or columns.

FIX - Print Titles Must Be Contiguous And Complete Rows Or Columns Microsoft Excel 2013

The reason behind this warning may be incomplete rows or columns in your document. If you’re getting this message with single worksheet, you can bypass it by clearing out Print Titles (navigate to PAGE SETUP > Print Titles). But if you have lots of worksheets, it is not feasible to clear out print titles for each sheets manually. Hence, for such cases, you can try this easiest solution and resolve the problem for yourself.

FIX : Print Titles Must Be Contiguous And Complete Rows Or Columns Warning In Microsoft Excel

1. Open your worksheet in Microsoft Excel.

2. Now click on PAGE LAYOUT tab. Then click Print Titles icon there.

FIX - Print Titles Must Be Contiguous And Complete Rows Or Columns Microsoft Excel 2013

3. Next, in the Page Setup window shown below, switch to Sheet tab first. Then under Print heading, click the drop down against Cell error as and select <blank>. Click OK to close Page Setup window.

FIX - Print Titles Must Be Contiguous And Complete Rows Or Columns Microsoft Excel 2013

Finally, restart Microsoft Excel and open the worksheet with which you were having the issue. You’ll find that now you can print or see print preview without getting any warning.

That’s it!

Also see: How to repair Office offline?

20 Comments

  • Very very helpful Thank You.!!!

  • Kapil Arya

    ^^ Thanks for your feedback 😊

  • Thanks for your information

  • Kapil Arya

    ^^ 👍

  • Thanks For You.

  • Kapil Arya

    ^^ Welcome Aman!

  • It still did not work :(

  • Thanks for giving idea for solve problem

  • Kapil Arya

    ^^ Cool 😎

  • thanks sir…..

  • Kapil Arya

    ^^ You’re most welcome, loganthan!

  • Thanks Sir…. it’s working

  • Kapil Arya

    ^^ Awesome 😎

  • Thank you very much dear sir………….

  • Kapil Arya

    ^^ Glad it helped 😎

  • supr…

  • Thank you. It’s very very helpful

  • Kapil Arya

    ^^ Happy to help!

  • Thank you. Would you explain how I got the error? In order to avoid it. Please Thank you

  • Kapil Arya

    ^^ As mentioned in article also, you can avoid incomplete rows or columns to safeguard from this issue.

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Recent Comments

    • Kapil Arya : ^^ See if you can still try above solution. Else, you can use System R...

      7 hours ago

    • Kapil Arya : ^^ You can't do that, as long as you're connected to corporate account...

      7 hours ago

    • Prabhat Jain : Indeed, "Prohibit use of Internet Sharing on your DNS domain network" ...

      7 hours ago

    • Cynthia : Thank you so much! You're honestly a hero without a cape...

      10 hours ago

    • Vernia Clements : I realize this is an old post but can you help with new problem becaus...

      23 hours ago