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.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. If the ...
Discover MoreIf you have added subtotals to your worksheet data, you might want to copy those subtotals somewhere else. This is easy ...
Discover MoreYou can insert subtotals and totals in your worksheets by using either a formula or specialized tools. This tip explains ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments