Inserting a page break

When Spreadsheets sends your worksheet to a printer, it naturally has to divide a large worksheet up into page-size chunks. First, it calculates the page size between the margins and next it divides the sheet left to right and then top to bottom.

Selecting Print Preview from the File menu will show how this division is made.

Apart from page breaks, you can control the positioning of page breaks by print to fit and also by simply reducing or increasing column widths and font sizes.

The other way of changing the page break sequence is to manually insert a page break:

  1. Position the cursor where you would like the new page break

  2. Select Page Break from the Insert menu

  3. Select vertical or horizontal as appropriate

To delete a page break, repeat steps 1 to 3 but clear the checkboxes.

Note that you can only delete a manual page-break and not the default page breaks inserted by the software.