Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Excel Refuses to Put Page Breaks between Subtotal Groups.
by Allen Wyatt
(last updated August 2, 2014)
Sandy noted that when she inserts subtotals into her worksheet, she usually clicks the insert page break between groups button. It doesn't seem, however, that the page breaks are inserted. Hen Sandy looks at the worksheet in both Print Preview and Page Break Preview, Excel does not show the page breaks as being present.
The only time that this behavior should occur is if you direct Excel (in the Page Setup options) to fit the printout to a specific number of pages. You can check to see if this is the case in this manner:
Figure 1. The Page tab of the Page Setup dialog box.
The reason that you need to make this change is that if you have your page setup configured to fit your printout to a specific number of pages, Excel basically ignores any page breaks in your worksheet.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8700) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Excel Refuses to Put Page Breaks between Subtotal Groups.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
If you have added subtotals to your worksheet data, you might want to copy those subtotals somewhere else. This is easy ...Discover More
When you add subtotals to a worksheet, Excel typically places them in the same column that you are subtotaling. If you ...Discover More
There are a variety of ways you can count information in different groupings. One convenient way is to use the ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.