In this tutorial, you will learn how to add a line in Google Sheets.
Everyone who has worked in Google Sheets knows that hitting enter while typing in a cell exits edit mode instead of adding a new line like it would in a text editor. But what if you want to add a new line inside the cell? Fortunately, Google Sheets has several different features for creating cells with multiple lines of text. Read on to learn how to use these features.
Keyboard Shortcut Method
The simplest way to add a new line is to use the keyboard shortcut. While simply hitting enter on the keyboard doesn’t insert a new line, you can insert new lines quickly with keyboard shortcuts by following these steps
Select the cell you want to add a new line to and start typing. When you come to the place you want to insert a new line, hit ALT+ENTER on your keyboard and a new line will be inserted. Continue typing to add text to the new line
If you want to add a line to a cell that already has text in it, select the cell and hit enter to enter edit mode, then click on the location in the text that you want to add a line to put the cursor there and hit ALT+ENTER to insert the new line
The above method works great for cells containing plain text, but what if you want to use a formula to display text? In these cases the formula method is the way to go
This method can be used anywhere you have a formula that outputs text, but for the sake of clarity this tutorial uses one of the simplest types of text formula where a text string and a formatted date are combined using the “&” character
Follow these steps to add new lines to your formula text:
If you don’t already have a text formula, add one to your spreadsheet. Text inside formulas must be surrounded by quotes. We’ll use this formula for the tutorial: “=”Today is ” & TEXT(TODAY(), “MM/DD/YYYY”)”
To add new lines to the formula, we’ll use the CHAR(10) function, which inserts the new line character. When joining any string segments together, always use the “&” character. So our formula becomes: “=”Today is ” & CHAR(10) & CHAR(10) & TEXT(TODAY(), “MM/DD/YYYY”)” and displays with two added lines as in the screenshot below
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to add a line in Google Sheets. Want more? Check out all the Google Sheets Tutorials.