To override the automatic page breaks that Excel inserts, you can insert your own manual page breaks, move existing manual page breaks, or delete any manually-inserted 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.

How to remove manual page breaks in Word, and adjust where automatic page breaks occur in your documents.

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

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.

Add manual page breaks or adjust page breaks automatically using options settings.

You can remove manual page breaks, but you can't remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.

You can keep all lines of a paragraph together on a page or in a column so that the paragraph is not split between two pages. Select the lines that you want to keep together.

To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview in the Workbook Views group. When you save your workbook, the print area is saved too.

The new combined section uses the formatting from the section that followed the section break. If you want the section to use the formatting, headers or footers from before the section break, use Link to …