Excel Tips - Autofit Row Height to Cell Contents | Auto Text Wrap | Easy Method

Hey team,

In this quick video I will show you how to set up Excel so that it automatically adjusts row height to match the content size in your cell based on what you entered.

[remorrey]

A great tip. First time I've added code. Thank you

[nakulgoyal]

I was searching this video for quite a few days. It works. Thanks 👍

[finlayjoseph]

Wow - thanks - really easy to follow and it works. Many thanks, much appreciated

[yamenymooon]

I was searching this video for quite a few days. It works. Thanks

[edchizu]

I noticed that this does not work if the rows are merged

[youngwill]

Great tip and thank you saved a lot of work

[mishkabehardien]

Thank you! This saved me sooo much time

[davidn.]

Thank you! I just subbed and turned on notifications. Everyone else was yapping on YouTube but you have the solution!

[FarahNabilah-tk]

Hey may I know, is it possible to do this if I already have other VBA code in the sheet?

[imranbinamdammoe]

Cells.WrapText=True
Cell.EntireRow.Autofit

[algot]

How can I make the text inside the squares be aligned to the top as well? Right now they all align to the bottom. Edit: you type in: Cells.VerticalAlignment = xlTop

[rahuldass]

How would you do this on Excel in sharepoint? There isn't a "view code" option when right clicking the tab.

[frenchcnnectiion]

I get this error: Variable uses an Automation type not supported in Visual Basic

[totisause]

Thank you! Is there a way to apply this only to a certain range?

[portiazwicker]

This isn't working for me. In fact, if I do Cell Styles > AutoFit Row Height, the cell adjusts and then REVERTS to the way it was. Help!

[rafaelcano]

thanks for the video, my issue is after I autofit and closed excel if I come back its not organized. I want to open the excel file and have it already locked so i dont have to autofit everytime i open the file, can you tell me how to do that. Thank you

[K_p_k]

Windows 11 doesnt have view code pls explain

[wsjeefo]

I took time to read the comments and I must commend you for engaging all the comments with a response. Thank you.
However I will like to reiterate "the problem with Copy paste data from one cell to another)

Have you found the solution?

[cottagekeeper]

Any thoughts on how to accomplish this with two merged cells and only apply it to a row with specific text? My example is at the bottom of my invoice I have Terms of Service: in order for my terms of service to fit I have merged to columns in that row. I will add and delete rows above the terms of service as I add products or delete products from my invoice. I also adjust the terms of service based on each client. It is a royal pain to manually adjust the terms of service row each time I create an invoice. Would love to know your thoughts.

[pauljohnson]

When I right clock the sheet. View code is not an option