Microsoft KB Archive/98868

{|
 * width="100%"|

Excel: Continuous Printing with Dot-Matrix Printer

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

-

SUMMARY
Microsoft Excel for Windows cannot print continuously over multiple pages when you are using a dot-matrix printer driver. Microsoft Excel will stop printing at each page break. However, by setting the margins at or near zero, the page will appear to print as one continuous page.

MORE INFORMATION
Microsoft Excel cannot ignore page breaks because the Windows printer drivers print one page at a time from all Windows applications. To minimize the line spaces between printed pages, set the top and bottom margins as small as possible. (The minimum top and bottom margin settings depend on which printer driver you use.)

To print continuously (sideways printing) over multiple pages when you are using a dot-matrix printer driver, do the following:


 * 1) For both landscape and portrait printing, set the left and right margins to 0 (zero). The majority of dot-matrix printer drivers should allow you to do this.
 * 2) In Print Preview, the left side should be completely flush (no margin) on every page (choose the Next button to verify this).
 * 3) While still in Print Preview, adjust the widths of the columns on each page so that the columns exactly fill the available width of the page. By doing this, you can make sure that there are no white spaces at the edges of the page.