How to Insert Line Breaks Inside Cells in Google Sheets

When creating address rosters, itemised notes, multi-step checklists, or product descriptions in Google Sheets, cramming multiple pieces of information into a single horizontal block of text makes your spreadsheets cluttered and difficult to read. However, when you press the Enter key inside a cell, Google Sheets does not start a new line—it automatically finishes cell editing and moves your active cursor down to the row below.

Fortunately, Google Sheets supports multi-line text entries within individual cells using simple keyboard modifier shortcuts on desktop, line break tools on mobile, and automated concatenation formulas. In this guide, you will learn how to insert manual line breaks inside cells in Google Sheets across Windows, Mac, iOS, Android, and formula functions.

Why Use In-Cell Line Breaks?

Structuring cell contents with manual line breaks delivers several key layout advantages:

• Improves data readability: Neatly separates street addresses, cities, and postcodes onto separate visual lines inside a single address cell.
• Creates structured bullet points: Enables checklist entries or task summaries without creating separate unnecessary columns.
• Avoids messy merged cells: Keeps related information consolidated in one cell rather than relying on brittle merged rows that break sorting and filtering.

Method 1: Use Keyboard Shortcuts on Desktop Browsers

While typing or editing text inside a cell, use these modifier keys to trigger a clean line break:

• On Windows & ChromeOS: Press Alt + Enter (or Ctrl + Enter).
• On Mac (macOS): Press Option + Enter (or Cmd + Enter).

The cursor will immediately drop to the next line within the same cell boundary, allowing you to continue typing additional paragraphs or bulleted items. When finished, press standard Enter to save your cell.

Method 2: Insert Line Breaks Using the CHAR(10) Formula

If you are concatenating data from multiple columns (for example, joining First Name in A2 and Address in B2 with a line break in between), standard text quotation cannot hold an Enter keystroke. Instead, use the CHAR(10) function, which outputs the standard ASCII line feed character:

=A2 & CHAR(10) & B2 & CHAR(10) & C2

Alternatively, use the TEXTJOIN function to join an entire range of cells separated by line breaks:

=TEXTJOIN(CHAR(10), TRUE, A2:D2)

Note: For formulas containing CHAR(10) to display multiple lines correctly on your spreadsheet, ensure that text wrapping is enabled on that column via Format > Wrapping > Wrap.

Method 3: Inserting Line Breaks on Mobile (iPhone, iPad & Android)

Because mobile virtual keyboards do not have an Alt or Option key:

1. Double-tap the cell in the Google Sheets mobile app to open the edit bar at the bottom.
2. Tap and hold on the blue cursor handle inside the text field where you want the line break.
3. In the popup menu that appears, tap Insert line break.
4. On certain Android keyboards (such as Gboard), simply tapping the blue Return key while editing inside the formula bar will insert a line break directly.