Secure Page Break Record For Free

On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements you want people to be able to change. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.

Select the paragraphs that you want to keep together on a page. On the Format menu, click Paragraph, and then click the Line and Page Breaks tab. Select the Keep with next check box.

After you open the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.

Try it! Select Layout. In the Paragraph group, select the small arrow. In the Paragraph dialog box, select Line and Page Breaks. Under Pagination, choose the option that works best for you: Widow/Orphan control. Keep with next. Keep lines together. Page break before.

Try it! Select Layout. In the Paragraph group, select the small arrow. In the Paragraph dialog box, select Line and Page Breaks. Under Pagination, choose the option that works best for you: Widow/Orphan control. Keep with next. Keep lines together. Page break before.

To break a page unconditionally after a particular section in a report you should do so by setting the ForceNewPage property of the relevant section to 'After Section' in the section's property sheet in report design view.

To use the Page Break Preview feature, go to the View tab and click on Page Break Preview. This will show you how your data will be divided up into pages based on the current page setup. To protect the page breaks, go back to the View tab and click on Protect Sheet.