Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to add multiple lines in a single cell in Google Sheets.
How To Add Multiple Lines In One Cell in Google Sheets
When working with spreadsheets, you may find yourself needing to combine values or text from multiple cells into one cell. For example, you may be making a list of tasks and need to add several lines of text into one cell.
Luckily, Google Sheets has a JOIN function that allows you to add multiple lines of text into one cell. The formula works by specifying a newline character as a delimiter for a range of values.
In this guide, we will show you how to use the JOIN function to add multiple lines in one cell in Google Sheets. We will also explain how to add multiple lines in one cell using Alt+Enter.
How To Insert Text in Separate Lines In A Single Cell in Google Sheets
Here’s how to insert text in separate lines in a single cell in Google Sheets.
First, select the cell you want to add multiple lines to. In this example, we want to add the three options in separate lines in cell B1.
Type the string ‘=JOIN(‘ to start the JOIN function.
The JOIN function will allow us to combine multiple strings with a custom delimiter.
Our custom delimiter will be a newline character. Since the newline character cannot be written as an argument, we’ll need to use the CHAR function.
It turns out that the formula CHAR(10) returns the newline character.
Next, we’ll add our range of options as the second argument of the JOIN function.
Evaluate the function by hitting the Enter key.
Each choice in the specified range should now appear in a separate line in a single cell.
You may also want to add multiple lines manually instead of using a formula.
First, select the cell you want to add lines to.
Type the text you want to add in the first line. Type Alt + Enter in your keyboard to move your cursor to a new line.
Begin typing the next string you want to place in the new line. Proceed to use Alt + Enter to add as many lines in one cell as you need.
This guide should be everything you need to add multiple lines in one cell in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize