How to Wrap Text in Google Sheets Without Overflow

To wrap text in Google Sheets instead of letting it overflow, select the cell or range, then choose Format > Wrapping > Wrap. The text will continue on additional lines inside each cell, and the row will usually grow to show it. You can change the setting back to Overflow or choose Clip at any time; neither option changes the text stored in your cells.

What You’ll Need

A Google account with access to the spreadsheet, and Google Sheets open in a web browser.
Permission to edit the cells. If the sheet is view-only or the range is protected, ask the owner for editing access before changing formatting.
A cell, column, or range with text you want to display on multiple lines. A narrow column makes the difference between overflow and wrapping easier to see.

Step-by-Step

Open the spreadsheet and locate the text. Find the cell or group of cells that appears to run into neighboring columns or is cut off. Click one cell to change just that cell. To format a range, click and drag across it, or select the first cell and use Shift while selecting the last. You can also click a column letter to select that whole column if you want its existing and future entries to wrap.
Open the wrapping options. With the cells selected, go to Format > Wrapping in the Google Sheets menu. The submenu contains Overflow, Wrap, and Clip. If you prefer the toolbar, use the text-wrapping control, whose icon resembles lines with an arrow, then choose Wrap. The menu path is a dependable option if you cannot identify the toolbar icon.
Choose Wrap. Click Wrap in the submenu. Sheets keeps the words in the selected cells but displays them on multiple lines within the existing column width. The row will generally expand vertically as needed. Check the whole selection, especially if it contains a mixture of short and long entries.
Adjust the column width if the result is too tall. Wrapping is controlled by the column width, so a very narrow column can create many short lines. Drag the boundary between column letters to widen it slightly. You can also right-click the column letter and choose Resize column, then enter a width in pixels. A modest width increase often makes a table easier to scan without returning to Overflow.
Check the row height and alignment. If the full text is not visible, drag the boundary below the row number downward, or right-click the row number and choose Resize row. To position the text within the cell, use the vertical alignment control on the toolbar and select Top, Middle, or Bottom. Top alignment is often clearest for wrapped text in a tall row.
Apply the setting consistently where appropriate. If the same column will hold descriptions or notes, select the entire column and set it to Wrap once. For a whole sheet, click the blank square at the top-left corner of the grid, above row 1 and left of column A, then choose Format > Wrapping > Wrap. Whole-sheet formatting can make a large table much taller, so use it only when wrapping is useful throughout.
Review the neighboring cells and save your layout. Confirm that text is visible, rows are not excessively high, and the columns remain readable. Google Sheets saves changes automatically. If the result is not what you want, select the affected cells and choose another wrapping option or adjust the widths and row heights.

For example, imagine column B contains a long product description and column C contains a price. If C has a value, text set to Overflow cannot spread across it, so the end of the description may appear hidden. Selecting B and choosing Wrap keeps the description inside B and moves its later words onto extra lines. The price remains in C, and the underlying description is unchanged.

Common Mistakes

Choosing Clip instead of Wrap. Clip hides the portion that does not fit in the cell; it does not create extra lines. If the text still appears cut off, reopen the Wrapping menu and verify that Wrap is selected.
Expecting Overflow to display through occupied cells. Overflow can visually extend into neighboring cells only when those cells are empty. Existing content, including a space or another value, can block that display. Wrap is the option to use when text must remain visible without relying on blank cells.
Changing the wrong selection. Clicking a cell changes only that cell, while selecting a column changes its full column. Check the highlighted range before applying the setting, particularly in a shared sheet with carefully formatted sections.
Confusing display with the cell’s actual contents. Wrapping changes how text is shown, not what is stored. It does not insert line breaks into the value or remove words. Copying a cell’s contents or looking at the formula bar can help confirm that the full text remains there.
Making the column too narrow. Wrap cannot make a long paragraph compact in a tiny cell. It may create a very tall row with only a few words on each line. Widen the column or shorten the displayed text if the layout becomes hard to read.
Using merged cells as a quick fix. Merging cells changes the table structure and can make resizing and sorting harder. It is usually better to adjust the width or use Wrap in the original cells. If the range is already merged, check the row height manually because merged layouts can make sizing less predictable.

Tips

Use Wrap selectively. It is useful for comments, addresses, descriptions, and headings, but wrapping every numeric column can make a data table unnecessarily tall. Set only the columns that need multiline text.
Choose width and wrapping together. A good workflow is to set Wrap first, then widen the column until the text forms readable lines. There is no universal ideal width; consider the length of entries and how much horizontal room the sheet has.
Use top alignment for uneven entries. When some rows have one line and others have several, top-aligned text makes the start of each entry line up. You can change vertical alignment with the toolbar without changing wrapping.
Keep headings readable. Wrap can prevent a long heading from spilling into the next column, but a narrow heading column may become too tall. Widen the column, shorten the heading, or use a deliberate line break when you want a specific break point.
Use a deliberate line break only when needed. To split text at a chosen place while editing a cell, position the cursor where the break belongs and press Alt+Enter on Windows or Option+Enter on a Mac. This inserts a line break in the cell’s content; it is different from automatic wrapping and can affect how the text looks if the column width changes.
Apply formatting before sharing or printing. A wrapped layout can look different when someone changes column widths or opens the sheet on a smaller screen. Review the sheet at its intended viewing size, and check print settings separately if the table is meant for paper.

Troubleshooting

The text still looks cut off. Select the affected cell and check Format > Wrapping. Confirm that Wrap, not Clip or Overflow, is active. Also check whether the text is actually present in the cell by clicking it and reading the formula bar. If it is present but not visible, increase the row height and confirm that text color and cell background are not making it difficult to see.

The row does not expand enough. Drag the lower border of the row number downward, or right-click the row number and use Resize row. A custom row height may be too small for the wrapped content. If several rows need adjustment, select their row numbers and resize them together, or use the row boundary to adjust the selected rows.

Text is wrapping into too many lines. Widen the column by dragging its right boundary, or use Resize column to enter a larger width. If the column cannot be widened because the sheet has many fields, consider shortening the text, moving detailed notes to another column, or using a separate notes area rather than making every row very tall.

Only some cells change. The selection may have included only part of the range, or different cells may have been formatted separately. Select the complete intended range and apply Wrap again. If a protected-range warning appears or the menu action is unavailable, you may need the owner to change permissions or protection settings.

The layout changes when you reopen the sheet. Google Sheets saves formatting automatically, but another editor may have changed the column width or row height. Check the version history or coordinate with collaborators, then reapply the desired wrap setting and sizing. Wrapping itself does not lock the layout against later edits.

Frequently Asked Questions

What is the difference between Overflow, Wrap, and Clip?
Overflow lets text visually continue into adjacent empty cells. Wrap keeps it inside its cell on multiple lines. Clip displays only the portion that fits in the cell without adding lines.

Does wrapping change or delete the text?
No. It changes the display only. The full value remains in the cell, and changing back to Overflow or Clip does not remove it.

Can I wrap an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. This also applies to cells you fill in later, though it may make existing rows taller.

Why does wrapped text not show all its lines?
The row may have a custom height that is too small, or the column may be extremely narrow. Increase the row height and, if practical, widen the column. Also make sure the cell is set to Wrap rather than Clip.

Can I wrap text on the Google Sheets mobile app?
Yes, although the controls differ from the browser. Select the cell or range, open the formatting controls, and turn on text wrapping in the cell-format options. Menu placement can vary between Android and iOS app versions; the steps above describe Sheets in a web browser.

Is wrapping in Google Sheets the same as in Excel?
The goal is similar, but the menus differ. In Google Sheets, use Format > Wrapping > Wrap. Excel for Microsoft 365 has its own ribbon controls, so do not look for the Google Sheets menu path there.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.