Modify the smallest units for column width in Excel without changing the default font
Posted on 2013-05-12
Note: This is kind of is of a bizarre question but if someone knows a solution, it will save me several hours of work. :)
Is there a way to modify the smallest units for column width in Excel (2010) without changing the default font? What I mean is probably most easily explained by going directly to an example:
When Excel's default font is set to Calibri, the column width settings in the narrowest range are limited to the following:
0.00 > 0.08 > 0.17 > 0.25 > 0.33 > 0.42 > ...
In other words, if you try to set the column width to say, 0.16, it will actually set to 0.17 as the precise value 0.16 is not allowed.
On the other hand, when the default font is set to Comic Sans MS, the column width settings in the narrowest range are limited to:
0.00 > 0.08 > 0.15 > 0.23 > 0.31 > 0.38 > ...
If a column width of 0.16 is entered in this case, it is again not accepted exactly but in this case will come out as 0.15.
My question is whether or not there is a way to remove the limitations described above without changing the default font setting?
PS The following is a bit more information which is specific to my workbook and may or may not be helpful:
When Calibri is set as the default font, all 10 numeric digits of both Calibri & Comic Sans MS (set to 8 pts) will display when entered in five merged cells (width 0.17).
However, when Comic Sans MS is the default font, 9* of the 10 numeric digits of both Calibri & Comic Sans MS (set to 8 pts) will not display when entered in five merged cells (width 0.15).
*The digit "1" is the exception.