63

How can one format a cell to have word wrap in Google Sheets?

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 word wrap in it.

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

87

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 the 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.

  • 2
    "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
  • 5
    This seems to have moved to Format > Text Wrapping > Wrap – arun Jun 25 '18 at 14:47
  • 3
    Upvoted for the wrapping art! Btw. it's still there, the icon just changed (it looks like an 'H'). – Halle Knast Mar 3 at 21:46
28

Text Wrap Option

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

1
First Select the Cell you want to Wrap
From The toolbar, select "Format" -> "Text Wrapping" -> "Wrap"

How to Wrap Cell in Google Sheets

0

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).

0

Instead of Shift + Enter, for some reason Google Sheets uses Ctrl + Enter to add a new line to a cell.

-3

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

Your Answer

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

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