Columns Won't narrow?

[Dazzawm]

When I select the entire sheet and double click on the columns they won't shrink to the minimum size for the data in each column? Like below.

Excel 2010

	B
MVRIS
1
1
1
1
1
1
1
1
1

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

</tbody>

Sheet1​

The column should be a lot more narrow? Actually it looks like it should be on here, but on the sheet it is twice the size?!

 

[Dryver14]

It looks like it has, it takes the heading into account too

 

[Dazzawm]

Like I say it looks fine on here, but on the actual sheet the column is twice the width?

 

[Dryver14]

where is the info coming from? maybe worth putting a column next to it and put formula = len(cell to left) and see what results you get