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?

6 Answers 6


Google Spreadsheets will automatically wrap text when the content exceeds the width of the cell if in Wrap mode.

You can set it for a cell or range of cells using Format > Text Wrapping > Wrap Alt+Shift+O WW

There is also a wrap text button on the toolbar.

wrap text on toolbar

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

  • 3
    Upvoted for the wrapping art! Btw. it's still there, the icon just changed (it looks like an 'H').
    – bisgardo
    Commented Mar 3, 2019 at 21:46

Text Wrap Option

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

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

How to Wrap Cell in Google Sheets

  • Even selecting wrap, the content clips in my sheet. In other words, the cells do not become taller to accommodate the additional space needed. Perhaps another setting is preventing that to happen?
    – Davide
    Commented Jan 23, 2021 at 14:09

Google Sheets uses Ctrl + Enter to add a new line when typing in a cell, instead of using Shift + Enter.


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


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

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