how to insert page breaks in excel to print

#How to insert page breaks in excel to print how to#

If we now select the A4 page size, our page breaks occur at the start of columns E and J across the worksheet, and the start of row 56 down. The dropdown list offers a number of predefined paper sizes.įor the current worksheet, page breaks occur across the worksheet at the start of columns E and K, and down the page at the start of row 52 (there are of course more page breaks further down the worksheet). This is available from the Page Layout tab’s Size option. The above snapshot shows that the page size selected for the current worksheet is Letter. It should be understood that these limits (or page breaks) cannot be manually altered, and are automatically set by Excel, based on the page size and orientation selected.

This is the order in which the pages will be printed. When printed, these dashed lines indicate the limits of each page and is where page breaks will occur.Īlso, a watermark at the center of each page shows the page numbering. The view should now look something like the above snapshot, where blue dashed lines define the outline of each page. One way to do this, is to put Excel in Page Break Preview mode.įrom the Excel menu, select the View tab, and from the Workbook Views group, select Page Break Preview. So, the first order of business is to display any page breaks.

Page breaks are also of no importance unless you intend printing your worksheet, so Excel hides them by default. There are always page breaks inserted by Excel, they are just not displayed so that they are not a distraction while working with the worksheet. We will be using the above contact list worksheet, which comprises 12 columns and over 500 rows, a perfect candidate for page breaks.Īt the moment, it seems that there are no page breaks, but that is not the case. Page breaks can also be inserted by the user to indicate the end of one section and the start of another, such as when printing out a yearly report, where each month is started on a new page. In Microsoft Excel, page breaks separate the worksheet into individual pages, ready for printing, and are automatically inserted by Excel, based on the selected paper size, margin settings, and scale options.

#How to insert page breaks in excel to print how to#

When printing a document, a page break controls where one page ends and a new one begins – Today we’ll go over How to Remove Page Breaks in Excel.