Usually, in a spreadsheet, you’ll have one line of text, one piece of information per cell. Whatever the data may be – an amount, a date, anything really. In some instances that may not be the case though; you may find yourself wanting to keep an entire address in a field, for example, or a few sentences of a description.
Thankfully, you can – to type information into more than one line in a Google Sheets cell, click on the cell in question and type the first line of your content in.
Then, press Alt + Enter on your keyboard (or Option + Enter if you use a Mac) to get to a new line. Type your info into the second line as well and either use Alt + Enter again or click somewhere else to go to a different cell!
The info will expand your cell to the necessary size unless you manually set it to be smaller. If so, you can still double-click on the cell in order to see everything in it.
Rod Welsh says
Also, you can try to do it with merged cells , joining 2 or more cells together – if you’ve never done that before, it’s pretty straightforward.
Rod Welsh says
if that doesn’t work, and you’re wanting to get more than one line in a cell that’s taller from test-wrapping , to not split words up while text-wrapping, try adding long sections of spaces inbetween each word that you’re wanting to start at each point in the text-wrapping process ;
like this ;
———-
This is a demo of how to make a workaround if it doesn’t work
( can end up looking like this, inside a single cell )
| This is a demo |
| of how to |
| make a workaround |
| if it doesn’t work |
( not how the remaining distance before the end of each ‘line’ , and start of each line, lengthens or shortens how many spaces to put in – this is crude, since it will shrink/grow when text size changes and things like document-conversion , but it’s better than nothing sometimes, and simple to do )
Merry says
How can you get multiple lines when using Google Sheets on a mobile device? (No Alt/Option key on a device keyboard!)
Lee says
Thank you! I was 10 seconds away from throwing my computer out the window. *crisis averted*
Naomi Paul says
LIFE SAVER!!! THANK YOU!!
Lacie says
OMG! This saved my lifeeee.
Ethan says
How to do this on mobile?
Rob says
Oh wait! Yes, it does. I was pressing Shift instead of Alt. Haha!
Rob says
NO, this doesn’t work!