How to insert a manual page break in excel 2010

 · MS Excel / How to insert manual page break1. Select cell in worksheet where you want to insert page break2. Go to Page Layout tab3. Click Breaks button4.  · · On more way of inserting page break in Excel is to go to the Page Layout tab, click Breaks in the Page Setup group and select the corresponding option from the drop-down list. Note. 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. Inserting Page Breaks. Insert Horizontal Page Break − For example, if you want row 14 to be the first row of a new page, select cell A Then choose Page Layout» Page Setup Group» Breaks» Insert Page Break. Insert vertical Page break − In .

On the Page Layout tab, in the Page Setup group, click Breaks. Click Insert Page Break. 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). On more way of inserting page break in Excel is to go to the Page Layout tab, click Breaks in the Page Setup group and select the corresponding option from the drop-down list. Note. 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). MS Excel / How to insert manual page break1. Select cell in worksheet where you want to insert page break2. Go to Page Layout tab3. Click Breaks button4.

Mar Insert the horizontal page break. Return to the “Page Layout” tab and click the arrow beneath the “Breaks” icon. From the options, select “. Insert a page break 1. Click the worksheet that you want to print. 2. On the View tab, in the Workbook Views group, click Page Break Preview. Other page layout options, such as print titles and page breaks, can help make your workbook easier to read.