Article ID: 214123 - View products that this article applies to.
This article was previously published under Q214123
The standard column width in Microsoft Excel 2000 is 8.43 characters; however, the actual width that you see on the screen varies, depending on the width of the font defined for the Normal style of your workbook. Changing the default font also changes the column width. This behavior occurs because of the way that Excel stores the column width information for individual fonts. This article discusses how column widths are determined.
Excel begins with a default width of 8 characters and translates this into a given number of pixels, depending on the Normal style font. It then rounds this number up to the nearest multiple of 8 pixels, so that scrolling across columns and rows is faster. The pixel width is stored internally in Excel for positioning data on the screen. The number that you see in the Column Width dialog box is the pixel width retranslated into character units (based on the Normal font) for display.
A column width of 8.43 means that 8.43 of the default font's characters fit into a cell. The default font for the worksheet is the font that is assigned to the Normal style. Excel 2000 uses a factory default font of Arial 10.
Note Changing Printer DPI can affect the font metrics and can adjust the column widths.
Microsoft Office Excel 2007 uses a default theme that is named Office. This default theme has Cambria as the default heading font and Calibri 11 as the default body font.
To determine the default font on your worksheet, follow these steps:
To change the default font in Excel 2007, follow these steps:
If the default font is a non-proportional (fixed width) font, such as Courier, 8.43 characters of any type (numbers or letters) fit into a cell with a column width of 8.43 because all Courier characters are the same width. If the font is a proportional font, such as Arial, 8.43 integers (numbers such as 0, 1, 2, and so on) fit into a cell with column width of 8.43. This is because numbers are fixed-spaced with most proportional fonts. However, because letters are not fixed-spaced with proportional fonts, more "i" characters fit and fewer "w" characters fit.
When you change the width of a column to a fractional number, the column width may be set to a different number depending on the font used in the Normal style. For example, with a Normal style font of Arial, if you attempt to change the width of a column to 8.5, the column is set to 8.57 or 65 pixels. This behavior occurs because of the translation of font characters to pixel units. Fractional pixel units cannot be displayed; therefore, the column width rounds to the nearest number that results in a whole pixel unit.
Example of Column Width Behavior
Column Width behavior in Excel 2007To set the column width in Excel 2007, follow these steps:
Article ID: 214123 - Last Review: June 13, 2008 - Revision: 6.0
Contact us for more help
Connect with Answer Desk for expert help.