<< Click to Display Table of Contents >> Adjusting page breaks manually

Page formatting also includes the possibility to manually control the automatic page break if required.

Normally, PlanMaker does the page break without further action: It automatically inserts a page break as soon as the end of a printed page is reached (depending on the page format you have set, see Set page format). If you take a closer look at a worksheet, you will notice that some of the gridlines between cells are darker. These lines indicate where PlanMaker has inserted automatic page breaks.

Note: On the ribbon tab View | group View, enable the option Show page breaks if the dark gridlines for page breaks are not displayed.

Inserting a manual page break

If necessary, you have the option to insert "hard" page breaks. Hard page breaks override PlanMaker's automatic page breaks. To do this, choose the ribbon command Layout | group Page setup | Page break. In the dropdown menu of this command, you will find the following options:

For horizontal page break

▪Insert before row inserts a horizontal page break above the current row.

▪Delete before row deletes such a page break. Navigate to a cell located directly below the page break before selecting this command.

▪With the options Move break one row up/down you can change the position of the page break by one row at a time. Navigate to a cell located directly below the page break before selecting this command. (Note: These options are enabled only after you have manually inserted a horizontal page break)

For vertical page break

▪Insert before column inserts a vertical page break left of the current column.

▪Delete before column deletes such a page break. Navigate to a cell located directly to the right of the page break before selecting this command.

▪With the options Move break one column left/right you can change the position of the page break by one column at a time. Navigate to a cell located directly to the right of the page break before selecting this command. (Note: These options are enabled only after you have manually inserted a vertical page break)

The command Delete all page breaks removes all manually inserted page breaks again.

Tip: Using the "Page break preview"

To visually control the page breaks, you can enable the option Page break preview on the ribbon tab View | group View. You will then see printout pages with their page numbers (displayed as "watermarks", these marks are not printed) clearly arranged with page breaks.

The area that is filled with data is automatically marked in white by PlanMaker and therefore – without further adjustments – leads to the displayed printout pages.

Adjusting manual page break with the mouse

You can manually adjust the vertical/horizontal page breaks in the Page break view by dragging a page break (recognizable by the green dashed line) while holding down the left mouse button. The page break line will change to a red line, indicating that the automatic page break will change to a manual one. The page numbers are recalculated in the process.

The manual page break adjusted in this way does the following:

▪For example, by moving a page break with the mouse, you can now enlarge the range that will be on a page for the printout.

▪In the Page setup dialog box (see Setting page format options), the Scaling mode is automatically set to the option Use fixed scaling factor and the value for Scaling (%) is adjusted to the changed page ranges.

▪Above this (in the same dialog box), a Print range is defined automatically, provided that you have moved the outer edges of the white shaded area with the mouse.

Resetting manual page breaks

To reset the page breaks (that you have changed with the mouse) to their original state, you can proceed as follows:

Open the Page setup dialog box (see Setting page format options). Here, set the value for Scaling (%) back to 100% and, if necessary, remove the newly created Print range in the input field above.