1

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells.

Mac OS: 10.13.6 (17G65)

Chrome: Version 73.0.3683.103 (Official Build) (64-bit)

I select all cells via cmd + A and apply text-wrap:

enter image description here

I scroll to a cell on the bottom I've never formatted previously and type in a long string (Let's say C1000):

enter image description here

The text wraps and expands the cell C1000 as expected:

enter image description here

I add text to a cell I had conditionally formatted (conditional format is simply to change it green on a certain value) and changed font of, and add long text, let's say at C125:

enter image description here

The text doesn't wrap in C125 even though wrapping is applied to it:

enter image description here

To reveal remaining text in C125, I had to manually drag the cell height:

enter image description here

I thought maybe one of the conditional formats was screwing with it, so I cleared formatting for all cells, and tried entering long text again in C125:

enter image description here

Again, it doesn't wrap. The text continues on in the cell but doesn't push the cell down and expose rest of text:

enter image description here

Lastly, I thought perhaps that text-wrap applies to correctly formatted cells as plain text, so I selected all cells again and set the formatting. No luck.

enter image description here

Can there be a bug with specific cells? Or does copying and pasting text from other sources, such as Mac Notes, cause bugs of this nature?

How can I restore to default such that text-wrap works for all cells?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.