An in-cell line break lets an address or short note occupy several lines without creating extra spreadsheet rows. It works best when wrapping and row height allow the full content to appear.
Insert the break while editing the cell
Double-click the populated cell or enter its editing mode, then place the cursor where the new line should begin. Google’s computer instructions use Ctrl + Enter on Windows and Command + Enter on Mac to add a line within the cell.
Finish the edit and check that the text remains in one cell. Pressing Enter outside the appropriate editing context can complete an entry or move the selection instead of inserting the intended break.
Make every line visible
Apply text wrapping from the toolbar or formatting controls. If the row remains too short, resize it or use the row’s Fit to data option. Adjust the column width to a useful reading width before judging the required height.
A hidden lower line is not necessarily missing data. Inspect the formula bar or reopen the cell for editing before retyping content and accidentally duplicating it.
Check where the text will go next
Preview printed or exported output, since a narrow page can change wrapping and pagination. When sending data to another application, test whether that application preserves embedded line breaks within a field.
Do not replace ordinary row structure with large blocks of multiline records if you later need sorting, filtering, or analysis by individual fields. Keep names, dates, and amounts in their own columns where appropriate. Use line breaks for presentation inside a field, and retain a small test example to verify the receiving workflow before exporting a large contact or address list.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.