What should I do if the content behind the dotted line in Excel is not displayed when printing?

It is a common problem that the content behind the dotted line in excel does not print and display. It may be caused by the incorrect area set by the dotted line. PHP editor Zimo will introduce you to the solution: select the dotted area, right-click-Format Shape-Border, adjust the setting to "All", and then reprint to solve the problem. Make sure the borders of the dotted area are set correctly and it will print perfectly.

1. First, we create and open an excel form and enter some simple content for demonstration.

2. At this time, we can see that there is a dotted line in the excel table. At this time, if we want to print, the content on the right side of the dotted line will not be displayed. It will be printed together with the previous content, resulting in page breaks and making it impossible to view the paper form content normally.

#3. Next, we click the "View" menu and select "Page Preview" in the drop-down list.

#4. A prompt will pop up saying "You can adjust the position of the page break by clicking and dragging the page break with the mouse." Select "OK". Then, we select the blue dotted line and drag it to the edge of the desired printing area.

5. In this way, we have adjusted the paging. Then, we select "View" and click "Normal" to return to the original view mode, and we can see After reaching the dotted line and outside the table area, the content we need to print can be printed normally!

If the content outside the excel dotted line is not printed completely, it is actually just divided into other pages, but it will cause the table not to be a whole, and it will be inconvenient to view. If you want to print and display the entire page, you need to adjust the paging according to our method.

The above is the detailed content of What should I do if the content behind the dotted line in Excel is not displayed when printing?. For more information, please follow other related articles on the PHP Chinese website!