New Contributor

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

2 Replies

# Re: Cell Formating

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.

# Re: Cell Formating

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