How to Insert a New Line in Google Sheets

What this guide covers

• Why does Enter move to the next cell instead of adding a line?
• How do you add a new line in a Google Sheets cell?
• How do you add a line break inside a Google Sheets formula?
• How do you make line breaks visible with text wrapping?
• How do you add a new line in the Google Sheets mobile app?
• How do you remove line breaks from a whole column?
• How do you split a cell at its line breaks?
• Why is my Google Sheets line break not showing?
• Why do line breaks disappear on CSV import or export?
• Frequently asked questions

Line breaks inside a cell keep addresses, multi-step notes, and short checklists readable without spilling into neighboring columns or forcing you to merge anything. In Google Sheets they are easy once you know the shortcut, and genuinely confusing until then.

The confusion has one source. Enter is already spoken for, and Sheets uses it to commit the cell and jump down a row. To break the line you have to hold a modifier key, and it is not the same modifier Excel uses.

Why does Enter move to the next cell instead of adding a line?

Because in Google Sheets, Enter is the command that finishes editing. It commits whatever you typed and moves the selection down one row. That behavior is deliberate, and it is the same reason Enter cannot double as a line break.

The fix is to hold a modifier so Sheets knows you want a break rather than a commit:

Shift + Enter catches people out because it is the line-break shortcut in Google Docs and Slack. In Sheets it moves you backwards through the column instead.

Rule to remember: Enter commits, Ctrl or Cmd plus Enter breaks the line. Shift + Enter is not the one you want.

How do you add a new line in a Google Sheets cell?

Four steps, and the first one is the one people skip.

1. Double-click the cell, or select it and press F2, to enter edit mode. The shortcut does nothing if the cell is merely selected.

2. Place the cursor at the exact point where the text should break. In the screenshot below, \n marks where the new line will land.

   

3. Press Ctrl + Enter on Windows or ChromeOS, or Cmd + Enter on Mac.

4. Carry on typing, then press Enter once to commit the whole cell.

Alt + Enter on Windows and Option + Enter on Mac also work in most builds, and older versions of Sheets used those as the primary combination. If one pair does nothing, try the other before assuming anything is broken. Google lists the current combination in its official Google Sheets keyboard shortcuts reference.

You can press the shortcut twice in a row to skip a line, which leaves a blank line between two blocks of text in the same cell. You will also want text wrapping turned on so the result is visible, which is covered below.

Rule to remember: the cell has to be in edit mode. The line break shortcut is ignored from the grid.

How do you add a line break inside a Google Sheets formula?

Use CHAR(10). It is the line feed character, and Sheets renders it as a break as soon as wrapping is on. It also behaves identically on Windows, Mac, ChromeOS, and mobile, which makes it the reliable option when a shortcut is not available.

Using CHAR(10) with CONCATENATE

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

Using CHAR(10) with the ampersand

=A2 & CHAR(10) & B2

If A2 holds a first name and B2 holds a last name, the two land on separate lines in one cell.

How do you join a whole range with TEXTJOIN?

Chaining ampersands stops being practical past three or four values. TEXTJOIN takes the delimiter once and applies it across the range:

=TEXTJOIN(CHAR(10), TRUE, A1:A5)

• CHAR(10) is the delimiter placed between every value.
• TRUE skips empty cells, so you do not get blank lines in the middle of the block.
• A1:A5 is the range. You can pass several ranges separated by commas.

How do you apply line breaks down a whole column?

Wrap the join in ARRAYFORMULA and write it once at the top instead of filling down:

=ARRAYFORMULA(IF(A2:A="","",A2:A&CHAR(10)&B2:B))

The IF check keeps the formula from producing a stray line break on every empty row below your data, which is the mistake that makes ARRAYFORMULA look like it filled the sheet with junk.

Rule to remember: CHAR(10) inserts the break, wrapping reveals it, and ARRAYFORMULA applies it down the whole column in one formula.

How do you make line breaks visible with text wrapping?

Sheets stores the break whether or not you can see it. Wrapping is what makes the row grow to show the extra lines.

1. Select the cell or range.

2. Click Format in the menu.

3. Open Wrapping.

4. Choose Wrap.

   

5. The row expands and each line displays inside the cell.

The three wrapping modes behave differently with line breaks, and picking the wrong one is a common reason people think the break failed:

Rule to remember: Overflow and Clip both hide line breaks. Only Wrap displays them.

How do you add a new line in the Google Sheets mobile app?

Mobile is more awkward than desktop because there is no modifier key on the on-screen keyboard.

On Android

1. Open the sheet and tap the cell.

2. Tap into the formula bar at the top rather than editing in the grid.

3. Place the cursor where the break belongs.

4. Tap the return key on the keyboard. In the formula bar it inserts a break instead of committing the cell.

On iPhone and iPad

On most iOS builds the return key commits the cell rather than breaking the line, and there is no reliable on-screen equivalent. Three workarounds that do work:

• Build the value with a CHAR(10) formula, which behaves the same on mobile as on desktop.
• Type the multi-line text in the Notes app, copy it, and paste it into the cell. Pasted breaks are preserved.
• Pair a physical keyboard, which restores the Cmd + Enter shortcut.

Rule to remember: on iOS, use a CHAR(10) formula or paste text that already contains the breaks.

How do you remove line breaks from a whole column?

This is the reverse problem, and it usually arrives with imported data. Text pasted from a website, a PDF, or an exported system carries breaks you never asked for, and they quietly break sorting, VLOOKUP, and anything matching on exact text.

The formula route. Put this in a helper column and let it fill:

=ARRAYFORMULA(TRIM(SUBSTITUTE(SUBSTITUTE(A2:A,CHAR(13),""),CHAR(10)," ")))

The inner SUBSTITUTE clears stray carriage returns that arrive with Windows-formatted text, the outer one turns line feeds into spaces, and TRIM tidies the double spaces that leaves behind. Copy the result and use Edit > Paste special > Values only over the original when you are happy with it.

The find and replace route. Press Ctrl + H to open Find and replace, tick Search using regular expressions, type \n in the Find field, put a single space in the Replace field, and click Replace all. Without the regex box ticked, Sheets treats \n as two literal characters and finds nothing.

Careful with CLEAN. It removes the break without putting anything in its place, so a name over a city becomes one run-on string. If word boundaries matter, use SUBSTITUTE with a space.

Rule to remember: in Google Sheets find and replace, \n only works with Search using regular expressions ticked.

How do you split a cell at its line breaks?

When the stacked cell is the problem and you want each line in its own column, use SPLIT with CHAR(10) as the delimiter:

=SPLIT(A2, CHAR(10))

To run it down a column at once:

=ARRAYFORMULA(SPLIT(A2:A10, CHAR(10)))

The menu route, Data > Split text to columns, is less useful here because the custom separator box will not accept a typed line break. The SPLIT formula is the practical option in Google Sheets.

If you want the lines going down into rows rather than across into columns, wrap it: =TRANSPOSE(SPLIT(A2, CHAR(10)))

Rule to remember: SPLIT with CHAR(10) is the only dependable way to break a multi-line cell apart in Sheets. The Split text to columns menu cannot take a line break.

Why is my Google Sheets line break not showing?

The break is almost always there and simply not being displayed. Work down this list.

1. Wrapping is set to Overflow or Clip. This is the cause most of the time. Go to Format > Wrapping > Wrap.
2. The cell was not in edit mode. If you pressed the shortcut with the cell merely selected, nothing was inserted. Double-click first, then try again.
3. The row height is fixed. If a row height was set manually, Sheets will not grow it. Right-click the row number, choose Resize row, and select Fit to data.
4. Vertical alignment is set to Bottom. In a tall row the top line can sit out of view. Set alignment to Top.
5. The cell is merged. Merged cells do not autofit their height, so the extra lines stay hidden. Resize the row manually or unmerge.
6. The formula shows CHAR(10) as text. That means the cell is formatted as plain text. Set the format to Automatic and re-enter the formula.

Rule to remember: check wrapping first and edit mode second. Those two explain nearly every missing line break.

Why do line breaks disappear on CSV import or export?

A line break inside a cell is valid in a CSV file, but only when the whole field is wrapped in quotation marks. Google Sheets does that correctly on export, so a Sheets to Sheets round trip normally survives. The problems come from what happens next.

• Tools that split on the newline character read your one record as two rows. Import scripts and older systems do this routinely. If the destination cannot handle quoted multi-line fields, strip the breaks with SUBSTITUTE before you export.
• Importing a CSV with File > Import preserves quoted multi-line fields. If the breaks vanish, the file itself was probably written without the quotes.
• Text from Windows systems carries CHAR(13) and CHAR(10) together. Sheets shows the CHAR(10) as a break and leaves the CHAR(13) sitting invisibly in the cell, which is why two values that look identical refuse to match.
• Copying between Google Sheets and Excel generally keeps the breaks intact in both directions. Check the wrap setting on the receiving side before concluding they were lost.

Rule to remember: if the receiving system cannot read quoted multi-line CSV fields, swap the breaks for a separator such as a semicolon before exporting.

Google Sheets line breaks at a glance

Ctrl + Enter or Cmd + Enter while the cell is in edit mode, CHAR(10) inside formulas, TEXTJOIN or ARRAYFORMULA to do it at scale, SPLIT to undo it, and Format, Wrapping, Wrap to make any of it visible. That set covers essentially every in-cell line break job in Sheets.

Working in Excel instead? The shortcut and the cleanup functions differ, so see our companion guide on how to start a new line in an Excel cell.

You can browse more step by step Google Sheets guides on the blog, or pick up ready-made Google Sheets and Excel templates with the formatting already handled. We post short walkthroughs on the Simple Sheets YouTube channel as well.

Related Articles

How to Wrap Text in Google Sheets

How to Start a New Line in an Excel Cell

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