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 …

Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.

You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file.

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

Excel Enter and format data Layout Split panes to lock rows or columns in separate worksheet areas

To add space between lines of text in a cell, double-click the cell, click where you want to break the line, and then press ALT+ENTER as many times as you need.

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 …

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.

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 …