In general, if we print or preview a worksheet in Excel, the worksheet will display a dotted line, indicating automatic paging.
Through the automatic pagination operator, we can also see the pagination of the worksheet in the common worksheet view, which is very convenient.
If you do not need to display an automatic paging character after a worksheet is printed and previewed, or you do not want to display an automatic paging character for a worksheet, you can select the worksheet first and then:
1. excel2010
A) on the "Files" tab of the functional area, click "options" in the lower-left corner ".
B) Select "advanced" on the left of the "Excel options" window ".
C) In the "display options for this worksheet" section on the right, select or deselect the "show pagination" check box.
D) Click "OK" to close the "Excel options" dialog box.
2. excel2007
A) Click "office" in the upper left corner, and then click "Excel options ".
B) Select "advanced" on the left of the "Excel options" window ".
C) In the "display options for this worksheet" section on the right, select or deselect the "show pagination" check box.
D) Click "OK" to close the "Excel options" dialog box.
3. excel2003
A) On the Tools menu, click options ".
B) on the "View" tab and "Window Options", select or uncheck "automatic pagination ".