Cell Formating

%3CLINGO-SUB%20id%3D%22lingo-sub-2596743%22%20slang%3D%22en-US%22%3ECell%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596743%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CBR%20%2F%3EI%20want%20you%20to%20learn%20about%20an%20XL%20function.%3CBR%20%2F%3EThat%20is%2C%20%3CSPAN%3EI%20specify%20the%20width%20of%20a%20column%2C%20then%20whatever%20I%20write%20in%20any%20cell%20of%20that%20column%20is%20larger%20than%20the%20width%20of%20that%20column%2C%20the%20row%20height%20will%20automatically%20become%20changed.%3C%2FSPAN%3E%20I%20mean%20creating%20another%20line%20of%20writing%20automatically%20on%20that%20cell%2C%20much%20like%20the%20wrap%20text%20function%2C%20that%20is%2C%20to%20manually%20wrap%20text%20and%20row%20enlarging%20will%20not%20be%20required.%3CBR%20%2F%3EI%20will%20be%20very%20grateful%20if%20anyone%20will%20give%20me%20the%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2596743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2596783%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596783%22%20slang%3D%22en-US%22%3EI%20am%20delighted%20very%20much.%20Thank%20you%20for%20your%20kind%20support!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2596756%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596756%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1115287%22%20target%3D%22_blank%22%3E%40Najmul_Hossain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20turn%20on%20Wrap%20Text%20for%20the%20column%2C%20Excel%20should%20automatically%20increase%2Fdecrease%20the%20row%20height%20of%20cells%20as%20you%20edit%20them%2C%20unless%20you%20have%20merged%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello
I want you to learn about an XL function.
That is, I specify the width of a column, then whatever I write in any cell of that column is larger than the width of that column, the row height will automatically become changed. I mean creating another line of writing automatically on that cell, much like the wrap text function, that is, to manually wrap text and row enlarging will not be required.
I will be very grateful if anyone will give me the solution.

2 Replies

@Najmul_Hossain 

If you turn on Wrap Text for the column, Excel should automatically increase/decrease the row height of cells as you edit them, unless you have merged cells.

I am delighted very much. Thank you for your kind support!