How To Add a New Line In Cell in Google Sheets

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.