Excel: Column Width Increments Dependent on Font Size

Last reviewed: November 29, 1994
Article ID: Q61497

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

In Microsoft Excel, when column widths are changed, the increments that the columns move are dependent on the font and font size of the text.

If the standard font is used (Geneva 10 point), the column increments will be .14 (or occasionally .15). For example, the column may be set at 9.00 or 9.14 but not at any point in between. This setting will not allow you to set exact column widths of .5 point increments because a break would occur at the 9.57 mark in the previous example.

The following settings may also be useful:

   Font                 Result
   ----                 ------

   Geneva 9 point       Breaks at every .17 points (approximate)
   Times 9 point        Breaks at every .20 points (approximate)
   Courier 9 point      Breaks at every .20 points (approximate)

KBCategory: kbusage
KBSubcategory:
Additional reference words: 2.20 3.00 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.