Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
12 years, 6 months ago
How can one format a cell to have word wrap in Google Sheets?
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?
43.4k 18 18 gold badges 87 87 silver badges 286 286 bronze badges
Dec 1, 2010 at 18:06
2,123 6 6 gold badges 23 23 silver badges 34 34 bronze badges
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.
Alternatively you can force a linebreak in the cell with
Ctrl + Enter.
25.8k 8 8 gold badges 48 48 silver badges 76 76 bronze badges
Feb 17, 2011 at 5:32
The button to change the text wrap option is slightly hidden. Hence, adding a screenshot from the new Google Sheets UI.
Jul 3, 2015 at 10:56
Varun Bhatia Varun Bhatia
393 5 5 silver badges 5 5 bronze badges
First Select the Cell you want to Wrap
From The toolbar, select "Format" -> "Text Wrapping" -> "Wrap"
Mar 3, 2019 at 9:12
Google Sheets uses
Ctrl + Enter to add a new line when typing in a cell, instead of using Shift + Enter.
Feb 3, 2019 at 15:37
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).
Mar 4, 2016 at 18:18
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
Apr 11, 2013 at 3:02
Highly active question
. Earn 10 reputation (not counting the
) in order to answer this question. The reputation requirement helps protect this question from spam and non-answer activity.
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only