How to Insert and Print Subtotals on Each Page in Excel Office 365?
Tags: insertandprintsubtot, kutoolsexceltutorial, kutools
Published: 2020-11-02 12:07:21

---
title: How to Insert and Print Subtotals on Each Page in Excel Office 365?
published: true
date: 2020-11-02 12:03:17 UTC
tags: InsertandPrintSubtot,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-insert-and-print-subtotals-on-each-page-in-excel-office-365/
---

In this article, we are going to see how to **Insert and Print Subtotals on Each Page in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link:**[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Inserting Subtotals of Each Column at the Bottom of Each Printed Page:

- If you have a long list of data in the Excel spreadsheet, and you want to [print](https://geekexcel.com/how-to-print-a-worksheet-or-workbook-in-excel-office-365/) them with subtotals. Do as below steps.
- You need to **open the worksheet** where you want to insert subtotals of each column at the bottom of each printed page.

![Example data list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1.png)<figcaption id="caption-attachment-16686">Example data list</figcaption>

- On the **Kutools Plus Tab, select** the **Printing** option, then **choose** the **Paging Subtotals** option from the menu.

![Select Paging Subtotals option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Paging-Subtotals-option.png)<figcaption id="caption-attachment-16687">Select Paging Subtotals option</figcaption>

- It will open the **Paging Subtotals Dialog Box**.
- **Headings –** You need to **select the columns** that you want to insert subtotal for it.
- **1st row content –** This section list out all the contents of the first row in the current worksheet.
- **Function –** Here, you can change the subtotal functions such as Sum, Count, average, max, min, product, and count numbers.

![Paging Subtotals Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Paging-Subtotals-Dialog-box.png)<figcaption id="caption-attachment-16688">Paging Subtotals Dialog box</figcaption>

- Finally, **click** the **OK** button to insert the subtotals.
- Now, you can see the result, as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result.png)<figcaption id="caption-attachment-16689">Result</figcaption>

### Note:

- [Sum](https://geekexcel.com/sum-function/) – It will find a total of numeric values in the cells.
- [Average](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/) – It can calculate the average value.
- [Max](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/) – This function shows the Max value.
- [Min](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/) – It displays the minimum value.
- [Product](https://geekexcel.com/how-to-use-excel-product-function-in-office-365/) – Multiplying numbers.
- [Count](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/) – This function counts the number of cells that contain values.
- [Count Numbers](https://geekexcel.com/formulas-to-count-cells-that-contain-numbers-in-excel-office-365/) – It will count the number of cells that contain numeric values.

## Verdict:

In the above article, you can easily understand the steps to **Insert and Print Subtotals on Each Page in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Hide or Unhide Workbooks and Sheets in Excel Office 365?](https://geekexcel.com/how-to-hide-or-unhide-workbooks-and-sheets-in-excel-office-365/)
- [Copy Page Setup from One Worksheet to Others in Excel Office 365!!](https://geekexcel.com/copy-page-setup-from-one-worksheet-to-others-in-excel-office-365/)