Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

How can one format a cell to have wordwrap in Google Spreadsheets?

I've tried Shift+Enter, but that doesn't seem to work.

One thing I know works is to place the Spreadsheet into List Mode and then if you edit your cell you can have wordwrap in it.

But is there a way to do this without switching Modes?

share|improve this question

2 Answers 2

up vote 51 down vote accepted

Google Spreadsheets should automatically wrap text when the content exceeds the width of the cell.

If not, you should be able to see a button on the toolbar to Wrap Text. Hit that when focus is on the cell you want to wrap text for.

wrap text on toolbar

Alternatively you can force a linebreak in the cell with Ctrl + Enter.

share|improve this answer
Nice drawing btw ;) –  AronVanAmmers May 9 '13 at 19:12
"should automatically wrap text" is kind of subjective ;) I for one am trying to figure out how to prevent that. –  doub1ejack Dec 28 '13 at 16:22
I linked my Stack Exchange account here just so I could upvote your drawing. (Okay, the answer was helpful, too.) –  Mike Branski Jan 13 '14 at 3:03
cool , loved the drawing :p –  Ali Apr 15 '14 at 8:27

An alternative to pasting just the long URL is to make a hyperlink - text that has a specific web address attached to it. By writing a short text word and turning this word into a hyperlink to your preferred URL works well.

Instruction are at this hyperlink

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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