column width excel

[gustaf111]

Hello,

I notice that if you have column width 4, when 5 columns (4x5 = 20) does not have the same width as a single column with columnsize 20 ?? Why ?? In the 4x5 colums you can write 3 more characters (calibri 11)

Is it a way to change this behaviour ?

 

[Andrew Poulsom]

No you can't change that behaviour. Here's how a column width is calculated:

http://support.microsoft.com/kb/214123

 

[gustaf111]

Thank you. I do not understand, what is the correct width with the 5 cells with width to be the same as as ingle cell with width 20 ?

 

[Andrew Poulsom]

Excel leaves some space at the beginning of the column. With 4 cells with a column width of 5 the characters use this space. The width of a cell with a column width of 5 is 30; the width of a column with a column width of 20 is 108.75, not 4 * 30 = 120.

PS a column width of 22.14 is equivalent to a width of 120.

 

[gustaf111]

... how much space is it extra for a column with width 4 ? 4.1 ? 4.2 ? 4.3 ? ... ?

 

[Andrew Poulsom]

A column width of 4 is equivalent to a width of 24.75, and 5 of those is 123.75 which is equivalent to a column width of 22.86.

 

[gustaf111]

Thanks! Sorry for me stupied!