Autofit Columns and Rows

Autofit allows Excel to expand columns and rows to fit the widest piece of data. This includes a demonstration of how to fit all the columns in a worksheet at one time.

[mzamnesia]

Tutorial starts at 1:55 for those in a hurry

[ExcelAtData]

Nice video Kelly 😊 There is a keyboard shortcut to resize the columns. Press Ctrl + A to select all the cells then ALT + H + O + I to automatically resizing Column widths. Similarly for Rows, Press Ctrl + A to select all the cells then ALT + H + O + A to automatically resizing Row widths.

[yaweli]

No running in circles, just straight to the point.Thanks

[solzmama]

Thank you for simplifying this, I had watched a few videos and still didn’t get it until I watch you clear and concise video explaining how to. Thanks so much for sharing.

[StevenUpshaw-vc]

Thank you so very much. I used to do these adjustments one-by-one. Your video saved me so much time.

[odanyboy]

Wow this saved me hours of work. Thank you so much hopes all is well 😁🙏

[chhunyi]

Oh my god, you are life-saving ! Thank you for this useful video

[ericnelson]

Thanks.  Short, concise and to the point!

[pradeepkumar-yxuk]

It's very easiest & simpl way to auto fit in Excel thank u mam

[cmyers]

Explained very well. With short amount of time:)

[GreenTRC]

Thank you, this is exactly what I was looking for!☺️

[kevinforde]

Thank you, easy to understand and follow.

[christopherstone]

Awesome! Well done and thank you very much.

[mikelennon]

Can you make this Automatic instead of re working every time?