Excel 2007 : Column Width

**Paul** · 09-03-2008, 08:23 PM

According to this Microsoft KB article: http://support.microsoft.com/kb/214123

..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.

Perhaps there is a font that will allow you to set it to 14.25? Maybe, maybe not. I don't plan on trying that many fonts personally, though.

**royUK** · 09-04-2008, 04:43 AM

I only have 2000 on this computer, setting Column Width to 14.25 automatically defaults to 14.29.

If you convert your 2003 workbook to 2007 then column widths should transfer & be the same. Do this & try printing the sheet. I think if you check 2003 you will find the column width has defaulted to 14.29 as pjoaquin says.

**Robin2** · 09-04-2008, 05:54 AM

Hi
Thanks for all the help. Made a mistake as the previous excel version I was using was 2002 but some of my other office products were 2003 so naturally assumed that excel was also. I used Arial 10 normal font and it took 14.25 width and it did not revert. I will have to revise all my column widths in 2007 as I do not have my original anymore. Thanks again.