Excel: Row Heights Change in Documents Converted to Excel 3.0

Last reviewed: November 4, 1994
Article ID: Q81003
Summary:

The calculation of standard row height based on font size in Microsoft Excel for the Macintosh version 3.0 differs from previous versions. Consequently, when documents that were created under previous versions are opened in Excel 3.0, page breaks may appear in different locations.

More Information:

Converted documents may need to be reformatted to account for this change. The following methods can be used to increase the number of rows that will print on a single page.

In the Page Setup dialog:

  1. Decrease top and bottom margins.

  2. Cancel the "Print Row and Column Headings" selection.

  3. Select "Larger Print Area" under Options (if available).

  4. Reduce/Enlarge the document (if available).

In the spreadsheet:

  1. Decrease row heights (adjustable in .25 increments).

  2. Delete rows within the spreadsheet.

  3. Change the font or font size.

  4. Don't use Print Titles.

Standard row heights and column widths are dependent on font size. The calculation used to determine row height was changed in Excel 3.0 to accommodate developments in font technology. Printer fonts in Excel 3.0 have a larger row height than in previous versions; screen fonts are interpreted with a slightly smaller row height.

Note: This change in row height is not reflected in the Row Height dialog. A row height of 12.00 in Excel 2.2 will display as 12.00 in Excel 3.0. The change is apparent in the number of rows that can fit on a printed page.

Reference(s):

"Microsoft Excel User's Guide," version 3.0, pages 193, 527-539


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20 3.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 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.