How to AutoFit Columns and Rows in Excel | AutoFit Cell Size to Contents | AutoFit Shortcuts

In this video I demonstrate how to autofit column width and row height in Microsoft Excel.

AutoFit Column Width
You can autofit individual columns or all columns by double-clicking between columns at the top of your worksheet. This will adjust the column width to fit the widest text or numeric value in that column. Sometimes this is not quite what you want. You may, for example, have a heading at the top of your worksheet that is wider than the contents in the same column below. To get around this you can select the cells that you want to base you adjusted column width on and then use the shortcut ALT H, O, I.

Autofit Row Height
Like columns you can autofit individual rows or all rows within a worksheet: double-clicking between row numbers on the left of your worksheet achieves this. You can also use the shortcut ALT H, O, A.
------------------------

[FathomSoundProAudio]

My Mac Excel program has an issue when trying to edit the source field (to accomplish the same thing automatically), so this method has been incredibly useful! Thank you!

[khatariinsaan]

Great tutorial Straight to the point !

[userme]

you cover important stuff. very nice thank you

[countduckula]

Thanks Chester; I learnt something new from your tutorial. 🖖

[DROIDFARM]

Liked and subscribed! Saved my buns in some homework!

[wayneedmondson]

Hi Chester. Great tips.. I use them often. As you suggested, I've memorized ALT, h, o, i and ALT h, o, a. Comes in handy to do these from the keyboard. Thanks for sharing. Thumbs up!!

[LicoInvestments]

thanks. and what if i do Not want excel to auto-fit

[BaylorBlogger]

Hi Chester, how do you autofit a row with multiple line items in one cell? When I try to auto-fit in that scenario, it only fits the first line and therefore hides the rest despite word wrap.