Autofit makes columns max width of 255

[go3go3go]

In some of my spreadsheets when I double click for Autofit it makes the column width 255 when obviously it is nowhere near that wide. Anyone else ever have this issue?

[José Augusto]

Hi @go3go3go

I suppose we need to know at least the Office version that you are using. Please update your profile. Thank you.

[go3go3go]

Gotcha. version 2010.

[go3go3go]

bump per rules

[go3go3go]

So no one else has ever had this problem?

[shg]

Maybe you have some padding, like spaces?

Post an example workbook.

[go3go3go]

See column A please.

Thanks!

[GeoffW283]

For me (Excel 2010) it seems to work correctly. Double clicking your sample file col A/B boundary reduces col-A width to 10.33

[ianb_ca]

Me too, must be some setting in Excel itself, not in the file.

[go3go3go]

Yeah, it is definitely wierd. and doesn't do it all the time.