Autofit Rows and Columns

Here we see how to make Excel automatically re-size the height of a row or the width of a column to accommodate its contents.

All it takes is a one line of code in VBA to accomplish it.

The two files used in this tutorial are uploaded on the Watch Learn Grow Repeat group on Facebook at:

and

If you liked this video then please give it a thumbs up and if you want to see more videos like this then please subscribe.

[elenakoskha]

@4:42 I didn't understand how did you change lengthy row into lengthy column?

Why are you switching sheets all over video?

[magdastefanek]

How do you get the cell width to expand automatically while typing in the cell?

[coursecubeofficial]

How to specify only current sheet AutoFit function should work? I need AutoFit should be applied only to one sheet, not to the whole workbook

[umer]

Hi. This is really great. Can this be applied to a single specific column in a sheet? For example if i just want to resize all rows in Column B, whats the code for that? Thanks

[panagiotistheodorou]

There only one Teacher that is understood perfectly: Mr. Dinesh Kumar
You need to be more precise and clear in your 'teaching' and check your sound clarity as well.
That is why there are no comments in this Video.

[NJHeartHeart]

Very loud intro, but the instruction is barely audible.