Home  >  Article  >  Topics  >  How to remove dotted lines in excel and print on one page

How to remove dotted lines in excel and print on one page

藏色散人
藏色散人Original
2020-03-31 10:18:577274browse

How to remove dotted lines in excel and print on one page

How to remove the dotted line in excel and print it on one page? Remove the dotted lines in excel printing

Remove the dotted lines in the preview: Click the icon in the upper left corner - Print - Print Preview, uncheck the display margins, then the dotted lines will disappear.

Recommendation: "Excel Tutorial"

How to remove dotted lines in excel and print on one page

Remove the printed dotted line that inserts the page break, click Page Layout - Separator - Remove page breaks or reset all page breaks. This is the dotted line of the page break that has been removed. In EXCEL2003, just click Insert-Delete page break.

How to remove dotted lines in excel and print on one page

Remove page breaks from the worksheet: Click the icon in the upper left corner of EXCEL - Select "excel options" - Advanced - Display options for this worksheet - Select " sheet1" (note this is the worksheet you want to remove page breaks from) - uncheck "Show page breaks".

How to remove dotted lines in excel and print on one page

WPS EXCEL to remove the printing dotted line: click the icon in the upper left corner - click Options, (or click Tools - Options) - View - and then change "Auto paging" Just remove the checkmark for ".

How to remove dotted lines in excel and print on one page

So whether it is OFFICE or WPS, you need to remove the printing dotted line, find the relevant options for page breaks, and remove the previous check to remove the printing dotted line.

How to remove dotted lines in excel and print on one page

The above is the detailed content of How to remove dotted lines in excel and print on one page. 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