Google Sheets Wrap Text Not Working? How to Fix It

In Google Sheets, wrap text often seems broken because the cell is set to Overflow or Clip, the row is too short, or merged cells prevent the row from fitting the content as expected. Select the affected cells and choose Format > Wrapping > Wrap; if text is still cut off, adjust the row height so it can show every line.

What text wrapping does in Google Sheets

Wrapping changes how cell contents are displayed; it does not edit the underlying text. With Wrap selected, Sheets breaks long content across multiple lines within the cell’s existing column width and usually increases the row height to show those lines. A long note can therefore occupy several visible lines while remaining stored in one cell.

Google Sheets offers three main wrapping behaviors:

Overflow: Text continues visually into neighboring cells when those cells are empty. If a neighboring cell contains anything, the overflow is blocked.
Wrap: Text appears on multiple lines inside the cell, and the row may grow taller to display it.
Clip: Text is visually cut off at the cell boundary instead of continuing into empty cells or wrapping onto more lines.

These options can make the same cell look very different without changing its value. For example, a long address may look complete in an empty row under Overflow, appear on several lines under Wrap, or stop at the column edge under Clip. When diagnosing a problem, check the selected wrapping mode before assuming the text is missing.

Apply Wrap to the affected cells

First confirm that Wrap is actually selected for the cells that look wrong. Click a cell or select a range, then use the menu path Format > Wrapping > Wrap. You can also use the text-wrapping control in the toolbar and choose Wrap. If only one cell is affected, selecting the whole column or range may help you apply the setting consistently.

Check the selection carefully. Formatting applies to the cells you have selected, not automatically to every cell with similar content. A common example is selecting one cell, changing its wrapping, and then entering a new note elsewhere that still uses Overflow. To format a whole column, click its letter at the top of the sheet before choosing Wrap. To format several separate cells, hold Ctrl on Windows or Command on Mac while selecting them.

If Wrap is already selected, choose Overflow and then Wrap again as a simple way to reapply the setting. This can help when a range has mixed formatting or when it is unclear which cells the previous command affected. Then inspect the row height and any merges before making further changes.

Check whether the row is too short

Wrapping can be active even when the lower lines are not visible. This usually points to a row-height issue: the cell is set to wrap, but the row has a fixed height that is too small for the displayed text. The content may still be present; the visible portion simply does not include every line.

To fit a row to its contents, move the pointer to the lower boundary of that row number and double-click. Sheets adjusts the row height to fit the data. For multiple rows, select their row headers, right-click one of the selected headers, choose Resize rows, and select the option to fit the rows to the data. If the row has a deliberately chosen height, you can instead drag its lower boundary downward.

Rows can also become too short after someone manually resizes them, copies formatting from another range, or changes the column width. A narrower column creates more wrapped lines, which may require a taller row. If a sheet is shared, another editor may have changed the dimensions without changing the text-wrapping setting, so check both properties.

Understand the effect of column width and neighboring cells

Column width affects how much text fits on each wrapped line. A narrow column creates more lines and often a taller row; a wide column creates fewer lines. If the row is not allowed to expand, widening the column can make more of the text visible, but it does not switch the cell from Overflow or Clip to Wrap.

Neighboring cells matter mainly when the selected mode is Overflow. For instance, if A2 contains a long label and B2 is empty, the label may appear to extend across B2. Entering a value in B2 blocks that visual overflow. This can look like text suddenly disappeared, but the value in A2 has not been deleted. Choose Wrap if the goal is to keep all of A2’s text visible within its own cell.

Also check whether the text is being hidden by another object or by the sheet layout. A frozen row or column does not change wrapping, but it can affect what part of the grid is currently visible while scrolling. Zoom level changes the screen appearance, not the cell’s stored text or wrapping mode.

Look for merged cells and manual line breaks

Merged cells deserve a separate check. Merging combines the display area of multiple cells, and automatic row sizing may not behave as expected for a wrapped value in a merged range. If a merged cell shows only some lines, try unmerging it temporarily using Format > Merge cells > Unmerge, apply Wrap, and fit the row. If that fixes the display, consider keeping the cells unmerged or setting the row height manually.

Manual line breaks can also affect the result. A cell may contain a line break inserted by the person who entered the text, so it starts a new line even before it reaches the right edge. This is different from automatic wrapping: changing the column width may move automatically wrapped text, while an inserted line break stays in the content. If the line breaks are intentional, allow enough row height for them; if they are not, edit the cell contents and remove them.

When a cell contains a formula, the same display rules apply to the formula’s result. Wrapping does not alter the formula or shorten its returned text. If the displayed result is genuinely incomplete, click the cell and inspect the formula bar to distinguish a display issue from a formula that returns only part of the text.

Rule out formatting and selection surprises

Formatting can be inconsistent across a pasted range. For example, copying cells from another sheet may bring along their wrapping and row-height choices. If only some cells behave differently, select the full affected range and apply Wrap again, then fit the relevant rows. Avoid selecting the entire sheet unless that is what you intend, because changing wrapping on a large area can make many rows taller.

Text color, fill color, and font size do not turn wrapping off, but they can make the result harder to interpret. Large fonts may require taller rows, and text that matches the cell’s fill color can appear to be missing. Check the cell’s actual value by selecting it and looking at the formula bar. If the value is present there, the issue is likely display or formatting rather than lost data.

Filters and hidden rows are another possible source of confusion. They can hide entire rows, but they do not change a cell’s wrapping mode. Clear or adjust a filter and unhide the row if the expected content is not visible at all. If only the lower portion of a visible cell’s text is missing, focus instead on wrapping, row height, and merged cells.

A quick troubleshooting sequence

Use this order to identify the cause without changing unrelated formatting:

Select the cell and confirm that its full value appears in the formula bar.
Choose Format > Wrapping > Wrap for the cell or affected range.
Check whether the text is in a merged cell; temporarily unmerge it if needed.
Fit the row to its data by double-clicking the row boundary or using the row-header resize options.
Look at the column width and the contents of adjacent cells, especially if the prior mode was Overflow.
Check for manual line breaks, unusually large text, hidden rows, or pasted formatting.

Make one change at a time and observe the result. If the text appears after fitting the row, the problem was row height, not missing content. If it appears after switching from Clip or Overflow to Wrap, the display mode was the cause. If it remains incomplete even in the formula bar, investigate the source value or formula rather than formatting.

When to use Wrap, Clip, or Overflow

Wrap is useful for notes, descriptions, addresses, and headings that must remain readable within a fixed column. It can increase row heights, so a sheet with many long entries may become harder to scan. If compact rows matter more than seeing every word at once, Clip can be appropriate, provided readers can select a cell to inspect its full value.

Overflow can work well for short labels when the cells to the right are usually empty. It is less dependable in dense tables, because adjacent content blocks the extension. A practical choice is to use Wrap for columns where the complete text should be visible, Clip for compact data tables, and Overflow only where extending into blank space is intentional. These are display choices: none deletes or rewrites the original cell value.

Frequently Asked Questions

Why does Google Sheets wrap text but not make the row taller?
The row may have a fixed height, or the text may be in a merged cell. Fit the row to its data from the row-header resize options, and test an unmerged cell if the problem continues.

Why does text disappear when I type in the next cell?
The first cell is probably using Overflow. Overflow can extend into an adjacent cell only when that cell is empty. Select Wrap if you want the text to stay visible inside its own cell.

Does wrapping change the actual cell value?
No. Wrap changes the way the value is displayed, not the underlying text. Select the cell and check the formula bar to see its content.

Can I wrap text for an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. You can also select a range if you do not want the setting applied to every cell in that column.

Why is only part of my wrapped text visible?
Check whether the row is too short, the cell is merged, or the font and line breaks require more vertical space. Fit the row to the data or increase its height, then confirm that Wrap is still selected.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.