Excel: Automatic Page Breaks Not Displaying with Print AreaLast reviewed: November 2, 1994Article ID: Q64357 |
SUMMARYAutomatic page breaks do not appear in a print area that is set based on a discontinuous range of cells. For example, "$A$1:$Z$100" is a continuous range of cells. "$A$1:$G$100,$M$1:$Z$100" is a discontinuous range of cells. Manual page breaks, however, will be displayed in either a continuous or discontinuous print area. To display page breaks in a discontinuous print area, do the following to replace all automatic page breaks with manual page breaks:
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |