MrExcel Publishing
Your One Stop for Excel Tips & Solutions

AUTOFIT COLUMNS


Posted by Nahuel on December 14, 2000 10:47 AM

Can this feature be disable somehow?

I need to know whether there is a way to set it on again, if any.

May be a setting or a VBA code. Something like:

Application.column.autofit = True ????

PLease Answer ASAP


Posted by Brian on January 05, 2001 9:43 AM

I'm not sure, but I think Excel sets column autofit on a column by column basis. If you select a column and set it to a specific width, autofit will be disabled for that column. If you select an entire worksheet you can apply this simultaneously to all the columns. You can make this the default on new workbooks by applying this to your xlstart workbook.

Posted by Brian on January 15, 2001 7:15 AM

Thanks a lot for your answer!
Nahuel