How do I insert a page break between rows 39 and 40?

Locate and select the Page Break view command.
Select the row below where you want the page break to appear.
Click the Page Layout tab on the Ribbon, select the Breaks command, then click Insert Page Break.

How do you reset page breaks in Excel 2010?

Clear All Page Breaks in Excel 2010 Step 1: Open the spreadsheet in Excel 2010. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click the Breaks button in the Page Setup section of the navigational ribbon, then click the Reset All Page Breaks option.

How do you automate page breaks in Excel?

You can add a manual page break to any row. You position the cell pointer in column A on the first row for a new customer and then select Page Layout, Breaks, Insert Page Break. Excel will draw in a dotted line above the cell pointer to indicate that there is a page break after row 8.

Why is Insert page break not working?

If manual page breaks that you add don’t work, you may have the Fit To scaling option selected (Page Layout tab -> Page Setup group -> click Dialog Box Launcher Button image -> Page). Change the scaling to Adjust to instead.

Why is Insert Page Break not working?

Why can’t I move page break excel?

Important: 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. Click the worksheet that you want to modify.

How do you insert multiple page breaks in Excel?

1. Select the range that you will insert page breaks after every x rows, and click Printing > Insert Page Break Every Row on the Kutools Plus tab. 2. In the opening Insert Page Break Every Row dialog box, specify the interval of rows that you will insert page breaks at, and click the Ok button.

How do you drag a page break in Excel 2010?

Move a page break in Excel

Click Page Break Preview on the View tab or click Page Break Preview Button image on the status bar.
To move a page break, just drag it to a new location.

Why can’t I move page breaks?

Move a page break Important: 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. Click the worksheet that you want to modify.