SOLVED

Cell Formating

Copper 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
best response confirmed by allyreckerman (Microsoft)
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.

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

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
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.

View solution in original post