Would you like to learn more about Excel Please consider supporting me by buying me a coffee (it takes a lot of coffee to write these articles).

Excel Cell References Excel Dos and Donts - Removing Gridlines 2020, Spreadsheets Made Easy.

When i first put the text in, it shows the whole sentence spilling out of the cell.

If i then wrap text, the row height automatically increases to fit the whole sentence in.

The problem is if i then ever sort the cells so the sentence ends up somewhere else, which i often do, it auto resizes again.

So, how do I turn this auto resize thing off I have looked everywhere i can think of.

I want to use the cells in a column to store historical data but do not want the row height to increase as the data is entered.

Right click and select row hight Enter the desired row height and click OK.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged c excel office-interop or ask your own question.

Automatically Adust Columns For Wrap Text Excel Mac