Adjust Page Break Notification For Free

On the Home tab, in the Paragraph group, click Show/Hide to show all formatting marks including page breaks. Double-click the page break to select it, then press Delete.

Click the Layout or Page Layout tab. Next, click Breaks in the Page Setup section. In the Line and Page Breaks tab, choose the settings you want to apply. Turn these all off to reduce automatic page breaks.

This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. Note In Microsoft Office Excel 2007, this problem may occur when the Enable fill handle and cell drag-and-drop check box is cleared.

Move a page breakOn the View menu, click Normal.Rest the pointer on the page break line until the pointer changes to a. , and then drag the page break line to a new location. Note: When you move an automatic page break, it changes to a manual page break. Manual page breaks are not adjusted automatically.

Adjust automatic page breaksSelect the paragraph following the unwanted page break.On the Format menu, select Paragraph, and then select the Line and Page Breaks tab.Clear the Keep lines together, Keep with next, and Page break before check boxes.

Delete a page breakSelect the worksheet that you want to modify.On the View tab, in the Workbook Views group, click Page Break Preview. You can also click Page Break Preview.Do one of the following:On the Page Layout tab, in the Page Setup group, click Breaks.Click Remove Page Break.

About Page Breaks in Excel Go to the View tab and click Page Break Preview in the Workbook Views section of the ribbon. You can close Page Break Preview any time by clicking Normal on the View tab.