Microsoft KB Archive/30673

Multiplan: Entering a Manual Page Break PSS ID Number: Q30673 Article last modified on 04-16-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Printers consider ASCII Character 12 to be the formfeed character. When printers receive this character, they advance the paper to the beginning of the next page.

If you want to force a page break at a certain location in the spreadsheet, do the following:


 * 1) Select the cell.
 * 2) Select the Value command.
 * 3) Type “Char(12)” in the cell.

When this specific cell is encountered during the print process, the ASCII code for 12 is sent to the printer and the printer performs a formfeed.

More Information:

Please note that the count of how many lines have already been printed on the page is not reset by the formfeed that is sent in this manner.

If the Page Length is set to 10 lines and the formfeed is sent at the end of the fifth line, another formfeed will be sent after the first five lines have been printed on the next page.

To ensure that the pages break only where you enter the Char(12) formula, you must also set the page length under Print Margins to a number larger than the total number of lines in the spreadsheet.

Copyright Microsoft Corporation 1990.