How to Wrap Text in Google Sheets (2026 Guide)
To wrap text in Google Sheets, select the cells, click the Text wrapping icon in the toolbar, and choose Wrap. Long entries then break onto multiple lines inside the cell and the row gets taller to fit. Here are all three wrapping modes (Wrap, Overflow, Clip), where to find them, and how to do it on mobile.
1. Wrap Text with the Toolbar
The quickest method:
- Select the cell, range, column, or row with the long text.
- Click the Text wrapping icon in the toolbar (it looks like an arrow bending down into a line).
- Click the middle option, Wrap.
The text now shows in full across multiple lines, and the row height grows automatically so nothing is hidden.
2. Wrap Text from the Format Menu
The same controls live in the top menu, useful if your toolbar is collapsed:
- Select your cells.
- Go to Format > Wrapping.
- Choose Wrap.
Both routes do exactly the same thing, the menu just spells out the option names.
3. Understand Wrap vs Overflow vs Clip
Google Sheets has three text wrapping modes. Knowing the difference saves a lot of confusion:
- Overflow (the default): long text spills out over the cells to its right, but only if those cells are empty. The moment a neighbor has data, the text gets cut off at the border. Nothing is lost, it just is not all visible.
- Wrap: text breaks onto new lines inside its own cell, and the row height increases to show everything. Best when the cells beside it contain data.
- Clip: text is cut off at the cell’s right edge with no overflow and no wrapping. The full value is still stored, it is just not shown. Useful for keeping rows a fixed height in dense tables.
In short: use Wrap to read everything, Overflow for occasional long labels over empty cells, and Clip to keep a tidy fixed-height table.
4. Apply Wrapping to a Whole Column or Sheet
To wrap an entire column (so future entries wrap too):
- Click the column letter at the top to select the whole column.
- Click the Text wrapping icon and choose Wrap.
For an entire row, click the row number first. To wrap the whole sheet, click the blank corner box above row 1 and left of row A to select everything, then choose Wrap.
Applying wrap to a whole column means any long text you type later wraps automatically, with no need to reformat.
5. Control Row Height After Wrapping
When you turn on Wrap, Sheets auto-sizes the row to fit the tallest wrapped cell. If you would rather set a fixed height:
- Right-click the row number.
- Choose Resize row.
- Enter a specific pixel height, or pick Fit to data to return to auto-sizing.
To restore auto-height on several rows at once, select them all first, then Resize rows > Fit to data.
6. Wrap Text in the Mobile App
On the Google Sheets app for iOS or Android:
- Tap the cell or select a range.
- Tap the Format icon (the A with horizontal lines) in the toolbar.
- Open the Cell tab.
- Toggle Wrap text on.
The mobile app supports the same Wrap behavior as the web, so long entries break onto multiple lines and the row grows to fit.
Quick Reference
| Mode | What it does | Use when |
|---|---|---|
| Overflow | Spills over empty cells, cut off by data | Occasional long label, blank neighbors |
| Wrap | Breaks onto multiple lines, row grows | Neighboring cells have data |
| Clip | Cuts off at the cell edge | Fixed-height, dense tables |
Let Carly Handle the Repetitive Data Entry
Formatting a sheet so it reads cleanly is a one-time job, keeping it fed with fresh entries is the recurring one. Carly is an AI assistant that connects to 200+ apps including Google Sheets and handles the follow-through, logging incoming details into the right cells, pulling values out of a sheet into emails or tasks, and sending recurring reports, so you set the layout once and stop copy-pasting. Carly starts at $35/month.
More on Google Sheets: How to freeze rows in Google Sheets · How to use conditional formatting in Google Sheets · How to create a drop-down list in Google Sheets · Google Sheets integration
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
