How to remove the dotted box in excel

The method to remove the dotted frame in excel is: first open excel, switch to the [Page Layout] column; then click [Print Area], [Cancel Print Area]; finally click [Office Button], [ Excel Options], [Advanced], and uncheck [Show Page Breaks].

The operating environment of this article: windows10 system, microsoft office excel 2010, thinkpad t480 computer.

The appearance of dashed lines is generally caused by setting the print area. For example, during paged preview, dotted lines may appear after selecting [Normal] view.

Solution:

Select the [Page Layout] tab, and then select [Print Area].

Select [Cancel Print Area] in the [Print Area] drop-down menu.

After removing the dotted lines in this area, the table may still have dotted boxes on the edges of the entire page. What should I do?

This dotted box is a "page break", marking the boundaries of printing. We click [Office Button] - [Excel Options] - [Advanced] and uncheck [Show Page Breaks].

Free learning video sharing:php tutorial

The above is the detailed content of How to remove the dotted box in excel. For more information, please follow other related articles on the PHP Chinese website!