Adjust Page Break Permit For Free

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.

Excel displays a solid line (manual page break) to show you where the new page begins. Dashed lines are page breaks inserted automatically by Excel. Note: in a similar way, you can select a column to insert a vertical page break. 4.

Word automatically adds page breaks when add more content than can fit on one page, but sometimes you'll want to add a break somewhere else -- for example, if you're creating a new section in a long document or you want to create more space around an image or chart.

Click the worksheet that you want to modify. On the View tab, in the Workbook Views group, click Page Break Preview.To move a page break, drag the page break to a new location. Note: Moving an automatic page break changes it to a manual page break.

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.

Click the Microsoft Office Button, click Excel Options, and then click the Advanced tab. Click to select the Enable fill handle and cell drag-and-drop check box, and then click OK.

Sometimes, Word won't let you delete a page break.If you need to delete a page break, you must turn off Track Changes, delete the break (make sure you're in Normal view), and enable Track Changes when you're done.