Page break parameters

Product: MyOffice Professional, MyOffice Education

Application: Spreadsheet Desktop version

Using page breaks, the sheet is divided into fragments, each of which is located on a separate page when printing. This prevents information from being cut off from the print area and distributes data more efficiently across the page.

In MySpreadsheet, two types of breaks are available:

–Automatic: Set by the application depending on the page settings, orientation, margins and cell contents. Automatic breaks are not editable.

–Custom: Can be configured by the user if they needs to mark up the sheet in a different way.

Due to the different line sizes, the position of the automatic break in the same file may be bigger or smaller when the file is opened on different operating systems. If it is important to keep the uniformity, use the Export to PDF option. This option ensures that line heights and formatting are the same on all devices.

Show breaks

To show the breaks, select the Page layout tab and click t_page_break_button Page breaks. Select the Show breaks checkbox.

Automatic breaks are shown as oblique blue dotted lines, while custom breaks are shown as a solid blue line.

file_print_page_break_types

The break display setting is not saved for the document. When the document is closed and reopened, the breaks will be hidden again.

Insert breaks

When inserting page breaks, horizontal and vertical breaks are added along the borders of the selected cell.

To insert a break, follow these steps:

1.Select the cell where you want to add a vertical break along the left border and a horizontal break along the upper border.

2.On the Page layout tab, click t_page_break_button Page breaks and select Insert break.

page_break_insert

To use custom breaks when printing, go to the Page setup and print window, select the Scale and page breaks block and enable the option Print with custom page breaks.

When copying a range of cells, the page breaks within the range are not copied.

Delete breaks

To remove a horizontal break, follow these steps:

1.Select the cell along the upper border of which there is a break.

2.On the Page layout tab, click t_page_break_button Page breaks and select Delete break.

page_break_horiz_delete

To delete a vertical break, follow these steps:

1.Select the cell with the break on the left border.

2.On the Page layout tab, click t_page_break_button Page breaks and select Delete break.

page_break_vertical_delete

To delete both horizontal and vertical gaps, follow these steps:

1.Select the cell below and to the right of the intersection point of the page breaks to be deleted.

2.On the Page layout tab, click t_page_break_button Page breaks and select Delete break.

page_break_intersection_delete

Delete all breaks

To delete all custom breaks on the sheet, select the Page layout tab, click t_page_break_button Page breaks and select Delete all breaks.

If you are in the view mode or if you work with a protected sheet, it is not possible to modify the breaks set for the document. However, you can enable or disable the option Print with custom page breaks.

Was this helpful?

Yes