Excel® 2013 On Demand

Inserting Page Breaks

If you want to print a worksheet that is larger than one page, Excel divides it into pages by inserting automatic page breaks. These page breaks are based on paper size, margin settings, and scaling options you set. You can change which rows or columns are printed on the page by inserting horizontal or vertical page breaks. In page break preview, you can view the page breaks and move them by dragging them to a different location on the worksheet.

Insert a Page Break

Select the location where you want to insert a page break:

• Horizontal. To insert a horizontal page break, click the row where you want to insert a page break. ...