Tip Printed from ExcelTip.com

---

Printing Each Subtotal Group on a Separate Page in Excel 2007


To print each subtotal group on a separate page:

In the Subtotal dialog box, select the Page break between groups checkbox.

Each group will be printed on a separate page.