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 …

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. …

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 …

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 for a worksheet in Page Layout view, where you can see them, or you can use the Page Layout > Page Setup dialog if you want to insert page numbers for more …

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.

To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, you can do the following: Double-click the cell in which you want to insert a line break. Select …

You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time. For other sheet types, such as chart sheets, or charts, you can insert …