Microsoft KB Archive/58094

Page Breaks Set Inside Print Area Ignored in Excel PSS ID Number: Q58094 Article last modified on 08-25-1993 PSS database name: W_eXceL

2.00 2.01 2.10 | 2.20 2.21

WINDOWS | OS/2

Summary:

If a manual page break is set in Microsoft Excel on the same line on which you have defined your print area, any other manual page breaks within the print area are ignored.

For example, if manual page breaks are set at rows 5 and 10, and the print area is set to A5:D20, the manual page break at line 10 is ignored. To set manual page breaks, choose Set Page Break from the Options menu.

Microsoft has confirmed this to be a problem in Microsoft Excel versions 2.0, 2.01, and 2.1. This problem was corrected in Microsoft Excel version 3.0 and does not affect later versions.

More Information:

To properly print the above example, you will have to delete the print area by choosing Define Name from the Formula menu, selecting Print_Area, and choosing Delete. Next, go to row 5 and choose Remove Page Break from the Options menu. Finally, redefine the print area to A5:D20, and the manual page break at row 10 will now be recognized.

Additional reference words: 2.00 2.01 2.10 2.20 2.21

Copyright Microsoft Corporation 1993.