Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 58 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

Text Wrap Option

The button to change the text wrap option is slightly hidden. Hence, adding a screenshot from the new Google Sheets UI.

share|improve this answer
+1; Perhaps it is better for Eight Days to incorporate this into his answer. Welcome on Web Applications !!!!! – Jacob Jan Tuinstra Jul 3 '15 at 12:43

If the text wrapping is on overflow and you type like two sentences it will get cut off. But if you press the down arrow on the wrap button it will be the middle option. (If this helps any. the button is on the top right side of the command bar).

share|improve this answer

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.