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.

[@mzamnesia7190]

Tutorial starts at 1:55 for those in a hurry

[@bioshock5620]

I love u

[@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.

[@syn7861]

Thank youuuu

[@yaweli2968]

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

[@solzmama679]

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.

[@user-tc4to9ru3n]

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

[@GreenTRC1]

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

[@cmyers7807]

Explained very well. With short amount of time:)

[@odanyboy84]

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

[@kevinforde2490]

Thank you, easy to understand and follow.

[@chhunyi6040]

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

[@ericnelson4337]

Thanks. Short, concise and to the point!

[@christopherstone76]

Awesome! Well done and thank you very much.

[@vincentakanda7330]

Short and clear, thank you.

[@pwillis7220]

Thank you for your video. Subscribed.

[@pradeepkumar-yx5uk]

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

[@danielolamideadeoke739]

clarity, concise and time saving

[@pacifiquendayizeye7275]

thank you very much. really helpful

[@missvillanueva6328]

Has salvado mi vida🎉😅 gracias 👍

[@michaeleisenbise4278]

Great information well presented.

[@marioh.4361]

great video

[@k94nicator12]

Awesome. Thank you.

[@wycliffmachipisa3656]

thank you.very helpful

[@letsgosurfingdude]

Nice explanation. Do more tutorials!

[@Tubefish07]

Helpful. Thank you!

[@user-zq8lw4zr2r]

Thank YOU!

[@mikelennon1078]

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

[@ExcelAtData]

Yes you can, using VBA. Press Alt + F11 to open the Visual Basic Editor (For Mac, press FN + ALT + F11). Under VBAProject --> Microsoft Excel Objects Folder, you should see ThisWorkbook. Click on ThisWorkbook to open it. You should see two dropdowns menus, first one will have "(General)" change this to "Workbook". For the second dropdown, you should see "Declarations", change this to "SheetChange". Then copy and paste the below code in the code area. Save the file as Macro-Enabled Workbook (file format .xlsm). Now the columns and rows will automatically resize. Hope that helps 😊
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Cells.EntireColumn.AutoFit
Cells.EntireRow.AutoFit
End Sub

[@ExcelAtData]

There is also 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.

[@devvv4616]

THANKS A TON!!!!

[@florenceonano3785]

This was helpful. Thanks

[@jerrysamuels8716]

Perfect!

[@user-vb8nd8bw3i]

Thank you!

[@classyal8035]

THANK YOU SO MUCH GOD BLESS

[@TheBlessingReport]

great video good job

[@sikwescarter905]

That's the way to do it!

[@PaulMerrill]

Brilliant!!

[@dufourrichard856]

Nice, good info after 1:37. thx

[@tundralane256]

thank you

[@ravindrapaturkar6147]

VERY INFORMATIVE

[@daisydelriorios7563]

Life saver

[@smileeey2470]

Thanks

[@juliebabes9667]

THANK U

[@abdallahalsandly4895]

thanks

[@johnkupa8885]

thanks mehm..

[@musicaman68]

Excel-lent!!!!

[@odracircomix7359]

great

[@mohanswarup6205]

Tq ao much mam

[@sumanthvakacharla1915]

When we close and open the file that format is not being saved

[@manojsable8482]

Row height?

[@rayray2001111]

Best

[@janaesaffold2531]

thanks \

[@ritaward6004]

can't be that easy, it just cant. LOL!

[@ArturAGO]

What about "autofit of merged cells", please?

[@rezagustiawan2430]

u stupid

[@pepsu.gujjar1909]

K gare h

[@dariencannon4430]

TALK less thank you

[@MrPink-hm3lm]

Thank you!

[@bluesapphire7548]

Perfect!

[@silvasaurusrex]

Thank you!