Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Row Height Changes When You Print to a Different Printer


View products that this article applies to.

This article was previously published under Q214278

↑ Back to the top


Symptoms

In Microsoft Excel, when you print a worksheet to one printer, such as a Hewlett-Packard (HP) LaserJet III, the height of the rows on the printout may be different than they are when you print the same worksheet to a another printer, such as an Apple LaserWriter II NT.

For example, if you format a row on your worksheet for a row height of 20, the height of this row on the printout from one printer may be slightly larger or smaller than the height of this row on the printout from a different printer.

↑ Back to the top


Cause

This behavior occurs because Microsoft Excel uses the ratio of the height of the Normal style screen font to the height of the font that is printed. Excel applies this ratio to the row height on the printout. For example, when you print a worksheet with a row height of 20, the value 20 is multiplied by this ratio to determine the printed row height. Because different printers use different fonts, this ratio depends on the printer you use. Therefore, the same worksheet is printed with a slightly different row height on one printer than on a another printer.

Note Row height in Microsoft Excel is measured in points (one point equals approximately 1/72 of an inch).

↑ Back to the top


Keywords: KB214278, kbprint, kbprb

↑ Back to the top

Article Info
Article ID : 214278
Revision : 7
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 464