Add, adjust or remove page breaks in Excel using Page Break Preview. Also, learn how to reset and hide page breaks.

In normal view, they appear as dashed horizontal and vertical lines; in page layout view, they appear as empty spaces between the pages. You can adjust where automatic page breaks …

In normal view, they appear as dashed horizontal and vertical lines; in page layout view, they appear as empty spaces between the pages. You can adjust where automatic page breaks …

Page breaks divide worksheets into separate pages when you print. In Page Break Preview you can insert, move, or remove page breaks. Click View > Page Break Preview In Page Break …

Adjust where automatic page breaks occur in a worksheet by adding your own page breaks manually. You can remove manual page breaks, but you can't remove automatic page breaks. …

Word automatically adds a break at the end of each page. You can also insert a manual page break anytime you want to start a new page in your document.

You can insert page numbers on multiple worksheets in your workbook by using the Page Layout > Page Setup dialog. For example, if your workbook contains two worksheets that are both …

You can insert your own column breaks for more control over the document format. Place your cursor where you want the column to break. Click Layout > Breaks. A menu with options will …

Insert a page break Applies To Put your cursor where you want one page to end and the next to begin. Go to Insert > Page Break.

Use sections breaks to divide and format documents of all sizes. For example, you can break down sections into chapters, and add formatting such as columns, headers and footers, page …