Change Page Break In Excel Manual Page Breaks

Change Page Break In Excel Manual Page Breaks

Microsoft Excel inserts automatic page breaks based on the paper size, margin, settings, scale options, and the positions of any manual page breaks that you insert.

To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it.

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.

After you finish working with page breaks, you can return to Normal view.

In Page Break Preview, dashed lines are page breaks Excel automatically added.

Insert a page break Click the worksheet that you want to print.

On the View tab, in the Workbook View group, click Page Break Preview.

Do one of the following: To insert vertical page break, select the row below where you want to insert the page break.

To insert a horizontal page break, select the column to the right of where you want to insert the page break.

On the Page Layout tab, in the Page Setup group, click Breaks.

You can also right-click the row or column below or to the right of where you want to insert the page break, and then click Insert Page Break.

If manual page breaks that you insert do not take effect, it may be that the Fit To scaling option has been selected on the Page tab of the Page Setup dialog box ( Page Layout tab, Page Setup group, Dialog Box Launcher).

To use the manual page breaks, change the scaling to Adjust to instead.

Move a page break Note: To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled.

If this feature is not enabled, you may not be able to move any page breaks.

To verify that drag-and-drop is enabled, do the following: Click the File tab Options.

In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box then click OK.

On the View tab, in the Workbook Views group, click Page Break Preview.

Note: Moving an automatic page break changes it to a manual page break.

Delete a page break Select the worksheet that you want to modify.

Do one of the following: To delete a vertical page break, select the column to the right of the page break that you want to do delete.

Change Page Break In Excel For Mac