Last Updated on October 31, 2023 by Jake Sheridan
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.
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 Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize