Excel: Printing Different Number of Rows from Same Document

Last reviewed: November 29, 1994
Article ID: Q51066
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

The selection of installed fonts available when a Microsoft Excel version 2.20, 3.00 or 4.00 worksheet is printed can affect the row heights on the printed document. When the same document is printed from machines with different sizes of installed fonts, the number of rows per page might differ. This is true even when the font used on the worksheet is installed on both machines; the presence or absence of fonts in the larger sizes may still affect the row height.

This occurs because of the way in which Excel scales fonts -- Excel uses scaled, larger sized fonts for greater precision.

MORE INFORMATION

This behavior can be reproduced as follows:

  1. Boot up the computer with a System that contains only the fonts required by the System and Times 12.

  2. Create an Excel worksheet at least one page in length, formatting it as Times 12.

  3. Print the worksheet on a LaserWriter.

  4. Add large sizes of Times (48, 56) to the System being used.

  5. Reprint the Excel worksheet. The two printouts will contain different numbers of rows. The characters within cells do not differ in size, but close inspection will show that the heights of the rows vary slightly.


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.2 2.20 2.21 3.0 3.00 4.0 4.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.