Google Doc Spreadsheet Doesn't Wrap Text When Editing

Question

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.

score 3 · Answer 1 · answered Oct 17 '13 at 15:03

3

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

answered Oct 17 '13 at 15:03

wchiquito

16,177
2
34
45

3

Yeah, I thought of that. It just feels like a lot of extra work for something that I think should be a standard feature. Thanks for the input though. – Hoopdady Oct 17 '13 at 15:04
Has anyone made an add-on to correct this behavior? My cell contents tend to be 300+ words that need to be edited regularly, so re-finding the portion I want to edit is too time-consuming. – SirenKing Jan 12 '19 at 03:30

score 2 · Answer 2 · edited May 18 '15 at 11:57

2

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

edited May 18 '15 at 11:57

Jack Ryan

8,396
4
37
76

answered Jan 28 '15 at 02:40

Peleg Tabib

44
3

Nowadays it's actually Format > Text wrapping > Wrap/Overflow/Clip – olofom Mar 16 '15 at 20:32
You misunderstood the question. The desired behaviour is to wrap text while editing the cell. – Apr 15 '17 at 20:37

score 1 · Answer 3 · edited Dec 15 '13 at 10:57

1

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.

edited Dec 15 '13 at 10:57

TLama

75,147
17
214
392

answered Dec 15 '13 at 10:38

Feisal

19
2

You misunderstood the question. The desired behaviour is to wrap text while editing the cell. – Apr 15 '17 at 20:37

score 0 · Answer 4 · answered Mar 23 '17 at 11:13

0

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

answered Mar 23 '17 at 11:13

AZK

1

Google Doc Spreadsheet Doesn't Wrap Text When Editing

4 Answers4