Forum Discussion

Dave_Bowden's avatar
Dave_Bowden
Copper Contributor
Jan 02, 2022

formatting rows automatically

can one make excel row height change automatically without intervention if column width is fixed and alignment set to wrap for cell entries.
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 02, 2022

Dave_Bowden 

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)
    Target.EntireColumn.AutoFit
    Target.EntireRow.AutoFit
End Sub

 

 

Hope this information could help you.

Thank you for your understanding and patience

 

Wish you a nice day.

Nikolino

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.

Resources