formatting rows automatically

Occasional Visitor

can one make excel row height change automatically without intervention if column width is fixed and alignment set to wrap for cell entries.

1 Reply


If I can recommend you in advance, always include the information about your Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.) in your question. Ideally, if possible, add a file (without sensitive data) or photo-s with your plans and on the basis of this you explain your plan / wish step by step.

This will save you and others a lot of time.

I don't know which Excel version and operating system you have, but a suggested solution would be with VBA.

Also attached is an example file (write a text in whichever cell you want) and the VBA code.

Additional Info:  formatting rows & columns


Private Sub Worksheet_Change(ByVal Target As Range)
End Sub



Hope this information could help you.

Thank you for your understanding and patience


Wish you a nice day.


I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.