Excel tip to autofit text auto column width adjustment

Auto fit text in columns in Excel with automatic width adjustment. This VBA code is a quick way to have automatic column width adjustment as you type.

#excel #exceltips #exceltricks

[mr.munchy]

Appreciate the tip.

Am I correct in that I would need to do this each time I open a new workbook?

Thanks again. Cool channel.

[IzzyUsi]

Awesome. Now what file type is this saved as?

[LeahyPhoto]

I always wondered why this was not an option. Now I’m wondering the same thing all over again.

[nonfiction]

Just double click the column header at its border? You can just highlight all columns and do that, takes 2 seconds and autofits every column

[hvysmokerhvysmoker]

It is a good tip but it will prevent undo/redo from working.

[AnnPatri]

Or….highlight the entire sheet by selecting the triangle in the top left corner of the sheet and selecting “auto fit column width” from the ribbon top right

[noboundaries]

When I right click the tab I do not have a view code option

[Philri]

How to get the pictures also auto fit?

[marcorossi]

"Undo" doesn't work after this?

[mormril]

It sounds nice in theory, but that would drive me crazy.

[afifkhaja]

This is neat but could also backfire badly

[DevArt]

Why isn’t this a default, seems like a sane default behavior smh