WPS Office 2003 pagination issue 200

1.Click "File Page Setup", switch to the "Worksheet" tab, and set the "Top Header Row" to 4 according to the format of **, that is, the first 4 rows are repeated in each **. Set the margins, and then use the print preview to confirm the number of lines that can be printed per page in addition to the title, which is assumed to be 16 in this case.

2.**Add a column (K column) to the end of the data, the title is page number, enter the formula =ceiling(row(f5)-3,16) 16 (as shown in Figure 1), drag the size handle to copy the formula to the following cells.

Figure 1 Add Page Number cell.

3.Select the payroll data area (B4:K200), click Data Classification Summary, set the Classification Field item to Page Number (by K columns) and the Summary Method item to Sum in the pop-up Classification Summary page, and select all the columns to be summarized in the Selected Summary Items list.

4.Right-click on the K column with the page number and select Hide, so that you can't see the page number column we added when you print. Then you can print it directly, and then press the "CTRL+Z" key to undo the hidden and sub-summary operations after printing to restore the original salary table, or you can save it before the sub-summary, and remember not to save it after the sub-summary, the effect is the same.

The pagination subtotal obtained by the above operation only has the merged data, and there is no pagination subtotal. If you need to display this text, you can select the payroll data area (B4:K200) and click "Data Filter Auto Filter", click the drop-down arrow of the filter in the column without subtotal, and select "Blank", then only the row where the pagination subtotal is located will be displayed, and then enter the pagination subtotal in the first row, and then drag the fill handle to fill it downward, and when the column width is not enough to display, it will be automatically displayed across the rows (as shown in Figure 2).

When you're done, click the same filter drop-down arrow and select (All). You can't undo it after using a filter, so you must save it before the breakdown and be careful not to save it after printing. Or you can use the pagination subtotal as described below.

Let's switch to the WPS Office integration environment.

Is the interval wrong?,You can adjust it to see if it's okay.。

Can you say the specific point, how do you divide it, it may be that you are not doing it correctly, if you are familiar with Mirosoft Office 2003 you may refer to its use method, similar steps.

Try clearing the formatting first.

Paragraph settings in the Tools menu.

Try WPS2005 so that documents in previous WPS format can be opened and solve the problem at the same time.

Jianyi: If you use Kingsoft Antivirus, your software may have been attacked by a virus.

There's a condensation in the paragraph.

Pagination is possible quickly.

Undo returns. 3.Detect drugs.

WPS Office 2003 has not been used! Why not use Mirosoft Office 2003 that? It's more flexible to use!

If it doesn't work, switch back to Mirosoft Office 2003.

I agree with the opinion of the second floor.

There are several possible scenarios:

1.The page settings are not reasonable, and the margins are set too large.

Solution: Lower the margins.

2.The paper size is set incorrectly.

Solution: Click "Paper Size" in "Page Layout" and "Page Settings" to check whether the settings are correct.

3.Mistaken operation, page breaks were inserted incorrectly. This is possible if there are unreasonable page breaks displayed in the Normal View.

Solution: Click the "Page Breaks" button in "Page Layout" and "Page Settings", and select the item "Reset All Page Breaks", and the incorrectly inserted page breaks will be canceled. Otherwise, try other possibilities.

4.The row height and column height are set slightly larger. In this case, the last row or column is usually printed on a separate page.

Solution: Select **, click the "Grid" command button in "Cell" in the toolbar "Start", select "Column Width" and "Row Height", and set the column width and row height.

5.Mistyped. Number of Rows Reserved in Excel:

65536 Number of columns: 256 Number of cells: 65536*256=16777216.

It may be possible to inadvertently touch a key outside the usage area to enter a space, which may result in the output of an extra blank page.

Solution: Drag as many rows as possible starting from the row below **, right-click the mouse, and select "Delete Tolerance"; In the same way, drag as many columns as possible to the right of ** and delete them.