Excel's Page Break Preview feature lets you use the mouse to move, delete, and insert page breaks.
To access this feature from a Normal view, go to View | Page Break Preview, or click the Page Break Preview button from Print Preview. This displays an image of the worksheet's print area. Solid lines indicate manual page breaks set by the user; dashed lines indicate where Excel will break the page automatically.

You can move page breaks, either automatic or manual, by clicking and dragging the break to a new location (left, right, up, or down). For example, clicking and dragging the right vertical page break on the first page to the right of the first column of the second page will move the column to the first page. Microsoft Excel automatically scales the worksheet to fit the new column to the page.
Click a page break and drag it outside the print area to delete it. To insert a new page break, right-click a row below or column to the right of the break, and select Insert Page Break.