How to automatically subtotal each page when excel batch prints

Paginate the preview with the sum subtotal in the appropriate cells.

1 Documents. 2 Page Setup.

3 Header Footer.

4 Customize the footer.

Choose the second of 5.

Step 1: Insert a column at the front, enter 1 on lines 2 to 6, and enter 2 on lines 7 to 11Then take a2:a11 first, double-click the lower right corner to fill down, and the filling method is to copy cells.

Step 2: Select the entire data table, Data - Categorical Summary, and in the Categorical Summary window that opens, summarize the selected quantities and amounts. Also check the option to pagination per set of data. Once you're done, you've done it.

There are dedicated pagination subtotal tools available online, and the next one, just open it while using excel.

The summation function solves the problem. Each page is summed, and at the end, the end of each page is on the last page.

A simple way to quickly insert the pagination subtotal 1, document --- page setup ---worksheet" -- set the "top header line" as needed to 4, that is, the first 4 lines are repeated in each **--- set the margins, and then use the print preview to confirm the number of lines that can be printed on each page in addition to the title, which is assumed to be 16 here.

2. **Add a column (K column) title name at the end of the data, 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. Hint: In the formula, 3 is the number of header rows minus 1 (4 1 3), and two 16 are the number of rows of data that can be printed per page.

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 Travel Loss in the Selected Summary Item list.

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. 5. After printing, press the "CTRL+Z" key to undo the hidden and classified summary operations to restore the original salary table, or you can save it before the classification and summary, and remember not to save the effect after the classification and summary 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 the 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 front of the line book where the pagination subtotal is located is displayed, and then enter the pagination subtotal four characters in the first row, and then drag the fill handle to fill it downward, and it will be automatically displayed across rows when the column width is not enough to display (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. Alternatively, you can ignore this issue by following the method of paginating the subtotal.

If you don't want to repeat the classification and summary operation every time, you can hold down the CTRL key and drag the "Payroll" worksheet tab with the mouse to copy another copy of "Payroll (2)", and enter the formula = Payroll in B5 of "Payroll (2)"! b5, and then drag the fill handle to fill in the formula into other cells with data, so that all the data modifications in the payroll will be displayed in "Payroll (2)". Then we just need to paginate the "Pay Sheet (2)" according to the method described above.

If you modify the Payroll, you can print it directly from Payroll (2) to the payroll with paginated subtotals.