Column Width Not the Same When Printed

This article was previously published under Q163621
This article has been archived. It is offered "as is" and will no longer be updated.
When you print or preview a worksheet, the column widths fail to beprinted or appear as they appear on the screen in normal view.
Depending on the fonts you use, column widths and row heights may appeardifferently when you print or view a worksheet in print preview. Thisbehavior occurs when you use proportionally spaced fonts, such as aproportional TrueType font.

This problem does not occur when you use monospace fonts (fonts with fixedwidths), such as Courier New. The discrepancy in font metrics is afunction of how Microsoft Windows reports the font information to MicrosoftExcel.
To work around the column width problem, use either of the followingmethods.

Method 1: Use a Monospace Font

  1. Select the cells that contain the data. On the Format menu, click Cells.
  2. In the Format Cells dialog box, click the Font tab and select a monospace font, such as Courier New.

Method 2: Manually Resize the Column

  1. Drag the boundary on the right side of the column heading until the column is the width you want.


    Select the column you want to resize, point to Column on the Format menu and click Width. Type a smaller number and click OK.
  2. On the File menu, click Print Preview to preview the page.
  3. Repeat steps 1 and 2 as necessary until the column appears correctly.
Most printers offer a much higher resolution (300 or 600 dots per inch)than a computer screen (72 dpi). Therefore, information that is displayedon the screen is rendered differently than the printed output. When youselect a column or row, and then use the AutoFit command, the font metricsthat are used on the screen are different than the metrics the printeruses; some characters for some fonts may use a fractional value. Forexample, a font may report 9.1 pixels, but because a display driver isunable to work with fractional amounts, it rounds the amount to thenearest whole pixel value. In this example, 9.1 pixels is rounded down to9.0 pixels. When a higher resolution printer renders the view in printpreview or is used when you print the worksheet, the characters may beprinted at a resolution of 9.1 pixels. Because the column width iscalculated based on the rounded whole number value, the printed output ofthe column width is different from the displayed column width. Thisdiscrepancy is particularly apparent when you use the AutoFit command to resize columns that contain long text strings.
For more information about using the AutoFit command, click the Index tabin Help, type the following text
   columns, width				
and then double-click the selected text to go to the "Change a columnwidth or row height" topic.
XL97 8.00 best fit mono-space kerning XL

Article ID: 163621 - Last Review: 01/11/2015 16:42:35 - Revision: 1.3

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • kbnosurvey kbarchive kbprb kbprint kbualink97 KB163621