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

In Excel for Mac, you can adjust where automatic page breaks occur, add your own page breaks manually, and remove manual 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. However, you …

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.

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 Preview, …

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 than one …

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

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

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.