How to Insert a New Line in Google Sheets

Feb 12, 2025

Image for how to insert a new line in a cell in Google Sheets

Quick Answer: How To Insert a New Line in Google Sheets

To insert a new line inside a Google Sheets cell, double-click the cell or press Enter to edit it, place the cursor where the line break should go, then press Alt + Enter on Windows or Option + Enter on Mac. On mobile, edit the cell and use the keyboard return key inside the cell text.

Google Sheets task	Best method
Add a line break on Windows	Press Alt + Enter while editing the cell
Add a line break on Mac	Press Option + Enter while editing the cell
Add a line break on mobile	Edit the cell and use the keyboard return key
Add line breaks with a formula	Use CHAR(10) and turn on text wrapping

If the line break is not visible, select the cell and choose Format > Wrapping > Wrap.

Do you need to quickly add a line break to a cell in Google Sheets?

Inserting line breaks in Google Sheets cells helps organize data, improve readability, and create structured lists (e.g., addresses, multi-step instructions). However, many users accidentally exit the cell when pressing "Enter" instead of adding a line break.

This guide will teach you simple methods to insert new lines, troubleshoot issues, and master advanced tips.

Using a Keyboard Shortcut to Add a New Line

The most commonly used method to add a new line in a Google Sheets cell is by using keyboard shortcuts. It is fast and easy to use.

Double-click the cell (or press F2) to enter edit mode.
Place your cursor where you want the new line. In the screenshot below, \n represents where the new line will appear within the cell.
Press:
- Windows/Chromebook: Ctrl + Enter
- Mac: Cmd + Enter
The text will break into a new line within the same cell.

Note: For older Google Sheets versions, use Alt + Enter (Windows) or Option + Enter (Mac). You should also enable text wrapping to see the new lines properly (more on this later).

Using the CHAR Function (For Formulas)

If you’re working with formulas, using CHAR(10) allows you to insert a new line dynamically. This is useful when combining multiple values into a single cell with line breaks.

Example 1: Using CHAR(10) in CONCATENATE.

=CONCATENATE("First Line", CHAR(10), "Second Line")

This will display:

Example 2: Using CHAR(10) for cell merging.

=A2 & CHAR(10) & B2

If A1 contains "First name" and B1 contains "Last name", the cell will display:

Note: Remember to enable text wrapping to display the line breaks correctly (next section).

Enabling Text Wrapping (To View Line Breaks Correctly)

After inserting a new line using a shortcut or formula, the text might still appear on a single line. To fix this:

Select the cell or range of cells.
Click Format in the menu.
Navigate to Wrapping.
Select Wrap.
Your text will now display with proper line breaks inside the cell.

Inserting New Lines on Mobile (Android & iOS)

If you’re using Google Sheets on mobile, inserting a new line isn’t as straightforward. Mobile formatting may also differ slightly from desktop.

For Android users:

Open Google Sheets and tap the cell.
Tap the formula bar at the top.
Place the cursor where you want the new line.
Tap Enter on your mobile keyboard.

For iOS users:

Unfortunately, iOS keyboards don’t support line breaks in Google Sheets. The best workaround is to enter data on a desktop or use CHAR(10) in formulas.

Troubleshooting Common Issues

Sometimes, even after following the steps correctly, new lines might not appear as expected. Below are some common issues users face and their solutions.

1. New Line not appearing: Ensure text wrapping is enabled (Format > Wrapping > Wrap).

2. Keyboard shortcut not working: Double-check that the cell is in edit mode before pressing the shortcut.

3. Formulas displaying CHAR(10) instead of a line break: Confirm that text wrapping is enabled and you’re using CHAR(10) correctly.

Final Thoughts on "How To Insert a New Line in a Cell in Google Sheets"

Inserting a new line in Google Sheets is easy once you know the right shortcuts and methods. Whether you prefer keyboard shortcuts, formulas, or working on mobile, this guide covers all the information you need. If you found this guide helpful, share it with your colleagues or bookmark it for future reference.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials!

FAQ on "How To Insert a New Line in a Cell in Google Sheets"

1. Can I insert a new line in Google Sheets without a shortcut?

Yes, you can use the CHAR(10) function in formulas to create line breaks within a cell.

2. Why is my new line not showing up?

Make sure text wrapping is enabled by going to Format > Wrapping > Wrap.

3. How do I add a new line in Google Sheets on mobile?

On Android, use the formula bar and tap enter. On iOS, line breaks are not directly supported; use a desktop for editing.

How to Freeze a Column in Google Sheets

How to Change Cell Size in Google Sheets

How to Use the IF Function in Google Sheets

Frequently Asked Questions

What is the shortcut for a new line in Google Sheets?

Use Alt + Enter on Windows or Option + Enter on Mac while editing a cell.

Why does Enter leave the cell instead of adding a line break?

Google Sheets treats Enter as a command to finish editing unless you use the line-break shortcut while the cursor is inside the cell text.

Can I add a Google Sheets line break with a formula?

Yes. Use =A1&CHAR(10)&B1, then turn on text wrapping so the line break displays correctly.

How do I make line breaks show in Google Sheets?

Go to Format > Wrapping > Wrap. Without wrapping, the cell may not visibly expand to show the new line.

Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons

We hate SPAM. We will never sell your information, for any reason.