When you're trying to add a new line inside a single cell in Google Sheets, pressing the standard Enter key won't work. Instead of creating a line break, Enter commits your text and jumps your cursor to the cell directly below.
To insert a line break manually while typing, use Ctrl + Enter on Windows or ChromeOS, and Cmd + Enter on Mac. If you prefer alternative shortcuts, Alt + Enter (Windows) and Option + Enter (Mac) also work in most web browser builds.
Mastering multi-line cells saves you from cluttering your spreadsheet with unnecessary rows and keeps address blocks, product descriptions, or combined notes clean. Beyond keyboard shortcuts, you can automate line breaks using formulas or fix hidden text issues in just a few clicks.
Manual Methods for Inserting Line Breaks
Getting text to stack vertically inside a single cell requires entering the cell's active edit mode first. If you just click a cell once and press the shortcut, nothing happens.
1. Using Keyboard Shortcuts on Desktop
To start a new line inside your text cleanly, follow these steps:
- Double-click the cell, or select it and press F2, to enter active edit mode.
- Place your text cursor at the exact point where you want the break to occur.
- Press Ctrl + Enter (Windows/ChromeOS) or Cmd + Enter (Mac).
- Continue typing your next line, then press Enter once to commit the entire cell contents.
2. Handling Line Breaks on Mobile Apps
Entering line breaks on iOS or Android mobile apps can feel frustrating because standard mobile keyboards lack a direct equivalent to desktop shortcuts.
If you're using the Google Sheets mobile app, tap into the formula bar at the top or bottom of the screen rather than trying to type directly inside the grid view. Placing your cursor in the formula bar and tapping your device's return key often inserts a line break successfully. Alternatively, type your multi-line notes in a dedicated notes application, copy the block, and paste it directly into the target cell. The clipboard usually preserves embedded line breaks.
Adding Line Breaks with Formulas
When you're combining data from multiple columns or generating automated text strings, manual shortcuts aren't practical. You can programmatically insert line breaks using the CHAR(10) function, which represents the standard line feed character in spreadsheet architecture.
Combining Text and Functions with CHAR(10)
You can chain text elements together using the ampersand (&) operator alongside CHAR(10) to stack variables vertically:
="First Line text" & CHAR(10) & "Second Line text"
For larger datasets or multi-cell arrays, pairing TEXTJOIN with CHAR(10) creates clean, consolidated text blocks without manual entry. For example, =TEXTJOIN(CHAR(10), TRUE, A1:A5) stacks an entire vertical range of cells into a single destination cell.
Important requirement: Formulas using CHAR(10) require text wrapping to be enabled on the target cell, or Google Sheets will render the line feed as an invisible character or a small square.
Troubleshooting Missing Line Breaks
If you've added line breaks—either manually or via formula—but your text still runs together in a single continuous line, the issue usually stems from one of two common display settings.
Enable Text Wrapping
By default, Google Sheets sets cells to overflow or clip content that exceeds column boundaries. To make hidden line breaks visible:
- Select the cell or entire column containing your multi-line text.
- Navigate to the top menu and select Format.
- Hover over Wrapping and select Wrap.
You can also find the text wrapping icon directly on the main toolbar—it looks like a curved arrow pointing inside a box. Turning this on forces the row height to expand automatically, revealing every stacked line clearly.
Cleaning Up Unwanted Line Breaks
If you inherit a spreadsheet stuffed with messy line breaks and want to strip them out in bulk, don't delete them manually.
- Press Ctrl + H (Windows) or Cmd + Shift + H (Mac) to open the Find and replace menu.
- Check the box labeled Search using regular expressions.
- Type
\ninto the Find field. - Leave the Replace with field blank or enter a single space to prevent words from fusing together.
- Click Replace all.
Frequently Asked Questions
Why does pressing Shift + Enter move me up a row instead of adding a line break?
Unlike text editors or word processors where Shift + Enter creates a soft return, Google Sheets assigns Shift + Enter to move your selection backward up the column. Stick to Ctrl + Enter on Windows or Cmd + Enter on Mac to stay inside the cell.
Can I export cells with line breaks into CSV files without breaking formatting?
Standard CSV (Comma-Separated Values) files treat line breaks inside cells as row delimiters. When you export a sheet containing multi-line cells to CSV, the text breaks will often split your data across multiple rows in external software. If you need clean exports, consider swapping line breaks for a semicolon or pipe symbol using a find-and-replace action before downloading.
How do I split a multi-line cell back into separate columns or rows?
If you need to reverse a stacked cell, use the SPLIT function combined with CHAR(10). Typing =SPLIT(A1, CHAR(10)) distributes each line horizontally across adjacent columns. If you want them distributed vertically down separate rows instead, wrap the formula like this: =TRANSPOSE(SPLIT(A1, CHAR(10))).
Why does my formula return an error when I use CHAR(10)?
Ensure that your syntax uses proper ampersand connectors or function delimiters. A missing quotation mark or an unclosed parenthesis will cause the formula engine to reject the calculation. Always verify that text wrapping is turned on so you can actually view the output.