In this tutorial, you will learn how to add a new line in cells in Google Sheets.
How To Add a New Line In Cell in Google Sheets
When working with data in Google Sheets, you may encounter a scenario where you need to add a new line within a cell. This can be a great way to make your data easier to read, or to separate different pieces of information.
In this guide, we will show you how to add a new line in a cell in Google Sheets. We will also explain a few different ways to do this, depending on your needs.
We will walk you through how to add a new line using a eyboard shortcuts, as well as how to wrap text to show longer strings as multiple lines of text.
How to Insert a Line Break in Google Sheets
Here’s how to insert a line break in Google Sheets.
First, select the cell you want to add a new line to.
While your cursor is in the textbox, head to the end of the current string and type Alt + Enter.
Your cursor should now show up in a new line.
Proceed to type your desired string in the new line.
You make keep on using the Alt + Enter combination to add more new lines to the current cell.
Next, we will tackle how to use the Wrap option to add a new line in a cell automatically if the text extends the current width of the cell.
First, make sure that the cell you want to convert to wrapped text is selected.
Click on the Wrap text option in the toolbar.
Text that would either be cut off or overflow to the next cell should now appear in a new line.
This guide should be everything you need to add a new line in a cell in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.