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.
Step 1
First, select the cell you want to add a new line to.
Step 2
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.
Step 3
Proceed to type your desired string in the new line.
Step 4
You make keep on using the Alt + Enter combination to add more new lines to the current cell.
Step 5
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.
Step 6
Click on the Wrap text option in the toolbar.
Step 7
Text that would either be cut off or overflow to the next cell should now appear in a new line.
Summary
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.