How to Force a Page Break in Excel [Solved]

How to Force a Page Break in Excel

Excel LogoAs your worksheet gets larger, there may be times when you want to force Excel to starting printing on a new page. For instance, you might want only the first fifteen rows of information on the first page, then the balance of the worksheet on the second printout page. To make this happen, follow these steps:

  1. Make sure cell A16 is selected.
  2. Choose Page Break from the Insert menu. A dashed line appears between rows 15 and 16.
  3. Print your worksheet as normal.

If you want to later remove the page break, follow these steps:

  1. Make sure cell A16 is selected.
  2. Choose Remove Page Break from the Insert menu. The dashed line disappears.

Credit: http://excel.tips.net/T001930_Forcing_a_Page_Break.html

Leave a Reply

Your email address will not be published. Required fields are marked *