Excel 2007/2010 + AutoFit Columns : How to turn off?

[Rusty]

Seriously, drives me round the bend. Ridiculous feature. I absolutely hate it.

Anyone know how to turn it off?

 

[xenou]

I'm puzzled - I never get column AutoFit behavior unless I select a column and double-click at the column edge(s). It seems to me if you wouldn't want to autofit your columns, you would simply not do this. Is this a joke?

 

[Rusty]

Not a joke at all.

I get Excel 2007/2010 auto resizing columns. Generally if there is errors in them and I go to the cell.

Most of the time I'm writing reports, and thus have a standard that people want them to be displayed.

 

[GlennUK]

I get Excel 2007/2010 auto resizing columns. Generally if there is errors in them and I go to the cell.

Can you describe exactly what you do, and exactly what happens on screen?

 

[xenou]

^^ Ditto. The behavior you are describing it is completely unknown to me. I can't imagine how going to a cell with an error in it could trigger a column autofit.

 

[Rusty]

Ok, I replicated the issue and took some screenshots:


First two basic lists of data in Column A and Column C:

http://imageshack.us/photo/my-images/638/excel2010cw01.png/


I then added in a basic VLOOKUP formula to compare the lists:

http://imageshack.us/photo/my-images/713/excel2010cw02.png/


This returned a #N/A error on the formula (intended, to replicate the issue). Note the column width of D:

http://imageshack.us/photo/my-images/684/excel2010cw03.png/


When I click in cell D2 with the formula, it auto-resized column D to the width of the #N/A error:

http://imageshack.us/photo/my-images/694/excel2010cw04.png/


It's a curious one... Thanks all for your input.

PS: Not sure how to have those links as thumbnails / images

 

[xenou]

Got me. Doesn't happen to me when I try your steps. Have you checked for any odd cell formatting (though I still can't imagine what - doesn't seem to be from wrap text or shrink to fit)? Have you tried deleting all formatting (Clear | Formats from the Home | Editing group)? I assume there's not custom code in this workbook, right? Addins installed?

 

[GlennUK]

I can't replicate that in native Excel. If I write a Worksheet_SelectionChange event code chunk I can replicate it ... I assume that you haven't got anything like that in there, have you?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target.EntireColumn.AutoFit
End Sub

 

[Rusty]

Just as an update, I've narrowed this down to being caused by an add-in.

Thank you all for your help.

Still totally frustrating, but maybe the developer will fix it sometime.

 

[GlennUK]

Just as an update, I've narrowed this down to being caused by an add-in.

Thank you all for your help.

Still totally frustrating, but maybe the developer will fix it sometime.

Thanks for the feedback ... good luck with the developer.