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 also quickly remove all the manually-inserted page breaks.

Remove a manual page break. Go to Home and select Show/Hide. This displays page breaks while you’re working on your document. Click or tap just after the paragraph mark in the page break, and then press Delete. Adjust automatic 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. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.

Page break before. Delete a page break. Select Home > Show/Hide . This will display non-printing characters—paragraph markers, section breaks, page breaks, etc.—that you may want to see while you’re working on your document. Double-click the page break so that it's selected, and then press Delete. Want more? Insert a page break. Remove a ...

In the Source list, click the link that you want to break. To select multiple linked objects, hold down the CTRL key, and click each linked object. To select all links, press Ctrl+A. Click Break Link. TBD Delete the name of a defined link. If the link used a defined name, …

Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

On the Page Layout tab, under Page Setup, select Header/Footer. Select Customize Header , and then select the section of the sheet header where the watermark appears. Select the watermark, and then press Delete.

When you remove subtotals, Microsoft Office Excel also removes the outline and any page breaks that you inserted into the list along with the subtotals. Select a cell in the range that contains subtotals.

Remove one or more hyperlinks from a page, or turn off automatic hyperlink creation as you type.

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, dashed lines are page breaks Excel automatically added. Solid lines are breaks that were added manually.