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

You can adjust where automatic page breaks occur and add your own page breaks manually. You can also remove manual page breaks, but you cannot 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 Preview, …

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 …

On the Layout tab, under Page Setup, select Header & Footer. Select Customize Header, and then select the section of the sheet header in which the watermark appears.

If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages …

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.

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

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 …

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 the location …