Microsoft KB Archive/64357

{| = Excel: Automatic Page Breaks Not Displaying with Print Area =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q64357

SUMMARY
Automatic page breaks do not appear in a print area that is set based on a discontinuous range of cells. For example, &quot;$A$1:$Z$100&quot; is a continuous range of cells. &quot;$A$1:$G$100,$M$1:$Z$100&quot; 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:

  Delete the print area using the following procedure: a. From the Formula menu, choose Define Name. b. Select &quot;Print_Area&quot;. c. Click the Delete button. d. Click the OK button.   Replace all of the automatic page breaks with manual page breaks, as follows: a. Select a cell to the right of a vertical page break or below a      horizontal page break. b. From the Options menu, choose Set Page Break. c. Repeat for all automatic page breaks.  Reset the discontinuous print area.
 * }