How to wrap text in Google Sheets
Learn how to wrap text in Google Sheets so long cell content displays on multiple lines instead of overflowing into neighboring cells.
Quick answer
Select the cell or range with overflowing text, then click the Text wrapping icon in the toolbar and choose Wrap. Google Sheets will resize the row height so the full text displays on multiple lines within the cell instead of spilling into neighboring cells or getting cut off visually.
Steps at a glance
- Select the cell or range containing long text.
- Open the Format menu in the toolbar.
- Click Text wrapping, then choose Wrap.
- Or click the Text wrapping icon in the toolbar directly.
- Row height adjusts automatically to show wrapped text.
- Repeat for multiple columns or the entire sheet if needed.
Summary
Text wrapping in Google Sheets forces long cell content to break onto multiple lines instead of overflowing into adjacent cells or getting hidden. It's a core formatting tool for keeping spreadsheets readable, especially when working with notes, descriptions, or addresses.
Step-by-step guide
Step 1
Select the cell, row, or range you want to format
Click a single cell, or click and drag to select a range, an entire column, or an entire row. If you want the same formatting across a whole table, select the full data range including headers.
Step 2
Open the Format menu
Click Format in the top menu bar, then hover over Text wrapping. A submenu appears with three options: Overflow, Wrap, and Clip. Overflow is the default behavior that lets text spill into empty neighboring cells.
Step 3
Choose Wrap from the submenu
Click Wrap to force long text to break onto multiple lines within the cell boundaries. You can also skip the Format menu entirely by clicking the Text wrapping icon directly in the toolbar, which cycles through the same three options.
Step 4
Let Google Sheets adjust the row height automatically
Once Wrap is applied, the row height expands automatically to fit all the wrapped lines of text. If a row still looks cramped, drag the bottom edge of the row number to resize it manually.
Step 5
Apply wrapping to multiple columns at once
Select several columns by clicking and dragging across the column headers, then apply Wrap the same way. This is useful for large tables you plan to organize further, such as before you sort a table or apply a filter to narrow down results.
Step 6
Wrap text in the Google Sheets mobile app
Tap the cell or range on your phone or tablet, then tap the formatting icon (the letter A with lines) in the toolbar. Tap Text wrapping and choose Wrap from the options shown at the bottom of the screen.
Step 7
Check formatting after importing or exporting data
Text wrapping settings can behave differently when data comes from an external source. If you've just finished an import CSV workflow, reapply Wrap to any columns with long text since imported formatting doesn't always carry over cleanly.
Why this matters
You're building a spreadsheet with detailed notes, addresses, or descriptions, and long entries keep spilling into empty columns, making the table look messy. Wrapping text keeps every column visible and readable, so you can scan rows quickly without widening columns or losing formatting when you share the sheet with others.
Frequently asked questions
What's the difference between Wrap, Overflow, and Clip?
Overflow lets long text spill into empty adjacent cells (the default). Wrap breaks text onto multiple lines within the cell and expands the row height. Clip cuts off text at the cell border without changing the row height.
Can I set text wrapping as the default for new sheets?
Google Sheets doesn't have a global default setting for text wrapping. You need to apply it to each new sheet or range, though you can copy formatting from an already-wrapped cell using the paint format tool to speed this up.
Does wrapping text change the actual cell content?
No, wrapping is purely a display formatting option. The underlying text and any formulas remain unchanged, so wrapping is safe to toggle on or off without affecting your data or calculations.
Is there a keyboard shortcut for wrapping text?
Google Sheets doesn't include a built-in keyboard shortcut for text wrapping by default. You can create one using a custom macro under Extensions, then assign it a shortcut key for faster repeated use.
Create interactive demos like this one — free, no coding required.
Start for free →