How can I make the Google Spreadsheet automatically break a Start new line in the same cellautomatically when the text is too longotherwise content would overflow cell
I don't know when did Google changechanged the version of their Google doc SpreadsheetSpreadsheets. RightRight now when the cell's text is longer than the box,cell width the display of this line will be changed fromis no longer what it used to be. And I want the display of the text willto be brokebroken into lines when it is too long, as before.
I've made two examples here: https://docs.google.com/spreadsheets/d/1SMwAeR-mWONtCqz2bQJ7vTlmiNvcYOy9cc_8j3z6xUY/edit#gid=0here:
Cell 1: Since there is no contentscontent in the other cells behind itadjacent to the right, it will showcontent is displayed over the info above cells behindbeside it, which makes the cell look like a super long combined cell. Cell
Cell 2: Since there is content in the cell behindbeside it, it makes Cell 2much of the content is hidden automatically. People cannot see the content unless you click itthe cell is clicked.
How can I make thosesuch text automatically break the line into severalenough lines that all is visible?
Thanks in advance!