Forum Discussion

Najmul_Hossain's avatar
Najmul_Hossain
Copper Contributor
Jul 31, 2021

Cell Formating

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.

  • 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.