CODEWITHSUNDEEP
excelgoogle-sheetsgoogle-drive-apigoogle-docs
Hoopdady
Hoopdady

Reputation: 2356

Google Doc Spreadsheet Doesn't Wrap Text When Editing

When I edit text in a cell, the editor forces all the text to a single line. When I exit the cell it goes back to wrapping just fine, but its annoying that when I double click on the cell it expands it out and puts my cursor at the end of the cell. I would rather it keep it the same and put my cursor in line where I clicked like it does in excel. Here is what I'm talking about:

enter image description here

If anyone has any ideas on how to get this desired behavior, let me know.

Upvotes: 10

Views: 15430

Answers (4)

AZK
AZK

Reputation: 1

I faced the same problem, and found that it is due to conditional formatting. when I remove conditional formatting, text wrap works fine.

Upvotes: 0

Peleg Tabib
Peleg Tabib

Reputation: 44

Select the wanted cell, Go to the menu-bar : Format > Text Wrapping > Wrap

Upvotes: 2

Feisal
Feisal

Reputation: 19

I had the same problem. Ctrl + E works and seems to be the only way to wrap text. It would be better to have a WRAP TEXT option in FORMAT options.

Upvotes: 1

wchiquito
wchiquito

Reputation: 16559

The most I've gotten is to prevent the cell to expand to the maximum, doing the wrapper manually (Ctrl+Enter). Upon returning to the cell, the wrap is maintained.

enter image description here

Upvotes: 3

Related Questions