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

1 Reply

  • 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