Home>Article>Topics> How to remove the dotted box in excel

How to remove the dotted box in excel

王林
王林 Original
2021-04-25 14:37:37 46578browse

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].

How to remove the dotted box in excel

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].

How to remove the dotted box in excel

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

How to remove the dotted box in excel

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].

How to remove the dotted box in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn