excel how to quickly get the subtotal of this page. Printable is required.

A simple way to quickly insert pagination subtotal1, file --- 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 rows 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. 3. Select the payroll data area (B4:K200), click "Data Classification Summary", in the pop-up "Classification Summary" interface, set the "Classification Field" item to "Page Number (by K column)", set the "Summary Method" item to "Sum", and select all the columns that need to be summarized in the "Selected Summary Item" list.

4. Right-click on the K column where the page number is located, and select Hide, so that you can't see the page number column we added when printing. 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 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. 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.

Just use the formula of the total!

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.

This standard function cannot be realized, and it has to be done through **.

This needs to be written** to get it done, I can do it!

Send me the papers.

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.