2

This question already has an answer here:

I don't know when Google changed the version of Spreadsheets. Right now when the cell's text is longer than the cell width the display of this line is no longer what it used to be. I want the display of the text to be broken into lines when it is too long, as before.

I've made two examples here:

WA66203 question example

Cell 1: Since there is no content in the cells adjacent to the right, content is displayed over the cells beside it, which makes the cell look like a super long combined cell.

Cell 2: Since there is content in the cell beside it, much of the content is hidden automatically. People cannot see the content unless the cell is clicked.

How can I make such text automatically break into enough lines that all is visible?

marked as duplicate by Jacob Jan Tuinstra, Vidar S. Ramdal, Eight Days of Malaise, Sathyajith Bhat Aug 15 '14 at 14:52

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • @pnuts, no. Just wrap text. How can I do that? – Hao Wu Aug 12 '14 at 3:24
  • 1
    @pnuts, Cool ,it works! Thx alot! – Hao Wu Aug 12 '14 at 3:46
8

With the gradual roll out of new Google Sheets from very late 2013 onwards the default text wrapping behaviour changed from “on” to “off” (which suits me). So what may have been taken for granted now requires a conscious choice, though only to select the range to which wrapping is to be applied and clicking a button:

WA66203 example

NB: As of May 2019 the icon now looks like this (the right most icon)

enter image description here

The button toggles.

Not the answer you're looking for? Browse other questions tagged or ask your own question.