Bạn đang xem: Top 15+ Cách Chỉnh Print Title Trong Excel
Thông tin và kiến thức về chủ đề cách chỉnh print title trong excel hay nhất do Truyền hình cáp sông thu chọn lọc và tổng hợp cùng với các chủ đề liên quan khác.Nếu khi In 1 file Excel Bạn Gặp lỗi như hình bên dưới thì chỉ cần làm theo cách sau sẽ giúp Bạn sửa được lỗi này
vào menu Page Layout > Print Titles > Sheet > trong mục Cell errors as: chọn rồi lưu lại, như hình bên dưới
giờ chỉ việc thử lại nữa là xong
Nhận xét
Có thể bạn quan tâm
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.
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.
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 . Click OK to close Page Setup window.
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.
Nếu khi In 1 file Excel Bạn Gặp lỗi như hình bên dưới thì chỉ cần làm theo cách sau sẽ giúp Bạn sửa được lỗi này
vào menu Page Layout > Print Titles > Sheet > trong mục Cell errors as: chọn rồi lưu lại, như hình bên dưới
giờ chỉ việc thử lại nữa là xong
Share this:
Like this:
Like Loading...
Related
A strange problem sometimes occurs while printing an Excel worksheet- a dialog box appears with an error message claiming the titles must be contiguous and complete rows or columns. This problem was mainly prevalent in Microsoft Excel 2010-16. But you can still face the problem in their latest versions as many have reported. In this article, we will focus on how to fix the “Print titles must be contiguous and complete rows or columns error” in Microsoft Excel.
Table of Contents hide
3 Possible Solutions for Print Titles Must Be Contiguous and Complete Rows or Columns Error
Solution 1: Change ‘Cell Errors As’ Option
Solution 2: Clear Print Titles
Solution 3: Clear Print Area
Things to Remember
Conclusion
Related Articles
3 Possible Solutions for Print Titles Must Be Contiguous and Complete Rows or Columns Error
The problem can be traced back to the print titles of the worksheet. For example, let’s take a spreadsheet with a dataset like this.
If we select both the second and the fourth row of the spreadsheet as the row to repeat on top in the print title, we will end up getting the error message titles print titles must be contiguous and complete rows or columns.
In addition, this is common while printing a large number of sheets too. But these are just two of many reasons that can cause this issue to occur. Nevertheless, we will focus on the solutions here in this article that can possibly eliminate the issue for you. All of the solutions involve tweaking print title options. Try each one out to find the one working for you.
Solution 1: Change ‘Cell Errors As’ Option
The first solution here would be to change the cell error print option. This will help bypass the error and let you print the spreadsheets as they are. To try this out, follow these steps.
Steps:
- First, go to the Page Layout tab on your ribbon.
- Then select Print Titles from the Page Setup group or the downward-right facing arrow at the down-right end of the group.
- At this instant, the Page Setup box will appear. Now select the Sheet tab in it.
- Then click on the Cell error as options under the Print
- After that, select from the drop-down menu.
- Once you are done, click on OK.
Although not needed in most cases, try to save the file and restart Microsoft Excel. Now you should be able to print the worksheet/worksheets without the “print titles must be contiguous and complete rows or columns” error.
Read More: Print Titles in Excel Is Disabled, How to Enable It?
Solution 2: Clear Print Titles
Another thing you can change from the same Page Setup box is clearing out the page titles. As shown in the demonstration, incorrect or discontinued row or column headers can cause the “print titles must be contiguous and complete rows or columns” error. This is only suitable for workbooks with only one spreadsheet. Follow these steps for a detailed guide.
Steps:
- First of all, go to the Page Layout tab on your ribbon.
- Then select Print Titles from the Page Setup group [or select the arrow sign on the bottom-right of the group.
- As a result, the Page Setup box will appear. Go to the Seet tab in it.
- Now clear the Rows to repeat at top and Columns to repeat at left fields under the Print titles
- After that, click on OK.
Now, try to print the spreadsheet. You should be able to preview and print the spreadsheet without the error appearing if the header issues were causing the problem.
Read More: How to Print Titles in Excel Except for Last Page [2 Easy Macros]
Solution 3: Clear Print Area
Another thing that can cause the annoying error message to appear on top while printing spreadsheets is some forms of problems in the print area. If that is indeed the cause, clearing out any selected print area from the printing options will eliminate the problem. This will let excel select a suitable print area on its own and will continue to print in most cases. Follow these steps to see how you can do that.
Steps:
- Firstly, go to the Page Layout tab on your Excel ribbon.
- Secondly, select Print Titles from the Page Setup group [or click on the arrow on the bottom-right of the group].
- Now select the Sheet tab on the Page Setup box that appears at this point.
- After that, clear out the Print Area and leave it blank.
- Finally, click on OK.
Now you should be able to preview and print the spreadsheet without the error message interrupting the process if any irregularities in the print area were causing the problem.
Things to Remember
- The second solution is suitable for Excel workbooks with one spreadsheet only.
- For worksheets with multiple spreadsheets, you have to repeat the process for each sheet.
- Although not necessary in most cases, try restarting Microsoft Excel after each process before printing or going to the print preview window.
Conclusion
These were the solutions for the “print titles must be contiguous and complete rows or columns” error message. Hopefully, you can bypass the error now and can comfortably print your Excel spreadsheets. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below.