How to Wrap Text in Google Sheets: Settings and Tips

To wrap text in Google Sheets in a web browser, select the cell or range, then choose Format > Wrapping > Wrap. You can also use the text-wrapping control on the toolbar. Sheets will display long cell contents on multiple lines instead of letting them run into the next cell.

Wrap text in Google Sheets step by step

Wrapping is a cell-formatting setting, so it changes how content appears rather than changing the text itself. You can apply it to one cell, a selected range, or an entire column. To set it from the menus:

Select the cell or cells whose contents should wrap. To select a full column, click its letter at the top of the sheet; to select several adjacent cells, drag across them or click the first cell and Shift-click the last.
Open Format in the menu bar, point to Wrapping, and select Wrap.
If the text is still not all visible, check the row height and column width. A wrapped cell may need more vertical space to show every line.

The toolbar offers the same setting for a quicker change: select the cells, open the text-wrapping control, and choose Wrap. The icon or its position can look different when the browser window is narrow, so the Format menu is a dependable alternative. To undo wrapping, select Overflow or Clip from the same menu, depending on the display you want.

Formatting can be applied before or after typing. For example, select a column of customer comments and turn on wrapping before pasting a batch of notes; new entries in those formatted cells will use the setting too. Wrapping does not insert spaces or edit punctuation, and it does not split the text into separate cells.

What Wrap, Overflow, and Clip mean

Google Sheets provides three ways to display content that is wider than its cell. They affect what you can see in the grid, not the underlying value. The options are useful in different situations:

Overflow: Text appears across the neighboring cells when those cells are empty. This is often the default behavior for text. If a neighboring cell contains something, the overflowing text cannot display over it, so the visible portion ends at the cell boundary.
Wrap: Text continues on additional lines within the cell. The row may become taller to make room. This is useful when the full wording needs to remain visible in the sheet.
Clip: Text is visually cut off at the cell edge rather than continuing into empty cells or onto more lines. The full content is still stored in the cell and can be seen in the formula bar when the cell is selected.

For example, a long project description in column B may spill into blank column C when Overflow is selected. If C contains a due date, the description stops at B’s edge. Wrap displays the description on several lines in B, while Clip keeps B to one visible line. Choose based on whether you value a compact grid, a clear view of the full entry, or text that can extend into unused space.

Make wrapped text fit by adjusting rows and columns

Wrapping works within the cell’s column width. A narrow column creates more line breaks, while a wider one creates fewer. If a row becomes tall and difficult to scan, widening the column can often improve the layout. If the text is still crowded, increase the row height or use a combination of width and height adjustments.

To resize a row or column, drag the boundary between its numbered row heading or lettered column heading and the next one. You can also right-click a row or column heading and choose a resize option, then enter a size or choose to fit the data. Resizing a column changes the wrapping of every wrapped cell in that column, so check the rest of the table before making a large change.

When wrapped content seems cut off vertically, the row may have a fixed height that is too small. Drag the row boundary downward, or use the row’s resize menu to fit the data. If a row is already set to fit its contents, editing the text or changing the column width can alter the needed height. Merged cells can behave differently from ordinary cells when fitting row heights, so you may need to resize a merged row manually.

For a table with many rows, avoid making every row extremely tall just to show one unusually long note. Consider widening the notes column, using a separate detail column, or leaving the full text accessible in the cell while keeping the overview compact. A good layout makes the important information easy to scan without forcing every column to be the same width.

Choose wrapping for the kind of content you have

Wrapping is most useful for text that readers need to see in the sheet itself: descriptions, addresses, feedback, task details, or column headings. It is less useful when a table is intended to stay very compact, such as a dashboard with short labels and figures. In that case, Clip can keep rows uniform, while a wider column or a note in a separate area may be a better way to show lengthy wording.

Consider a simple task tracker with columns for task, owner, status, and details. The task and details columns may benefit from wrapping because entries vary in length. The status column usually contains short values such as “In progress,” so wrapping there may add no benefit. Applying the setting only where it is needed can keep the sheet easier to read.

Headings are another common case. A narrow column heading such as “Estimated completion date” may wrap to two lines instead of requiring a very wide column. If you wrap a heading row, make sure its height is sufficient and that the headings remain visually distinct from the data. Bold text, fill color, and alignment can help, but they are separate formatting choices from wrapping.

Wrapping does not make a long entry more readable by itself. A paragraph with no punctuation may still be difficult to scan, and a very narrow column can create many short lines. When practical, write concise entries, use line breaks to organize genuinely separate points, or divide information into appropriate columns. Keep related values together so that wrapping does not make it unclear which row an entry belongs to.

Wrap text in the Google Sheets mobile app

You can change wrapping in the Google Sheets app as well as in a browser. The exact placement of controls can vary a little by device or app version, but the general process is similar on Android and iPhone or iPad:

Open the spreadsheet and tap the cell, or select the range, you want to format.
Tap the Format button, usually shown as an A with formatting lines.
Open the Cell tab and turn on Wrap text.

If the option is not immediately visible, check that you are in the Cell formatting controls rather than the Text controls, and scroll through the available settings. The app may show fewer cells at once after wrapping because rows need extra height. You can still adjust the layout by changing column width or row height where those controls are available.

For a large range or detailed layout work, using Sheets in a desktop browser can be more convenient because the menu bar, column headings, and row boundaries are easier to work with. Changes made in the app sync with the spreadsheet when the file is connected and saved, so you can use the browser and mobile app for the same document.

Fix common wrapping problems

The text still appears on one line: Confirm that the cells are set to Wrap, not Overflow or Clip. Open Format > Wrapping again after selecting the cell. If you selected only one cell, the rest of the column will not automatically receive the setting.
The text is hidden below the visible part of the cell: Increase the row height or choose a fit-to-data resize option. Also check whether someone set a fixed row height or whether the cell is merged.
Text runs into the next column: That is usually Overflow, or the neighboring cell may be empty and allowing text to extend visually. Choose Wrap if you want the text to stay within its own cell.
Only part of the text is visible: The cell may be set to Clip, or an adjacent populated cell may prevent overflow. Select Wrap and check the row height. The content itself is not necessarily deleted; select the cell to inspect it in the formula bar.
Wrapping changed after a column resize: That is expected. The available width determines where lines break. Adjust the column width again or restore the earlier width if the new layout is not suitable.
Some cells wrap and others do not: Formatting may have been applied to only part of the range, or the cells may have different settings. Select the full intended range and apply Wrap once to make the display consistent.

When troubleshooting, check the selected range before changing formatting. A common mistake is to select a heading or a single cell and assume the entire column has been updated. Clicking the column letter selects the whole column, which is useful when every entry in that field should wrap, but it may also affect cells beyond the visible portion of your table.

Wrapping, printing, and sharing a sheet

Wrapping is useful in the on-screen grid, but consider how the sheet will be printed or exported. Extra wrapped lines increase row heights, which can make a report span more pages. Before printing, use the print preview to check page breaks, scaling, and whether the text remains legible. Shrinking a large sheet to fit on one page can make wrapped text too small to read; changing page orientation or print range may be a better compromise.

When sharing a spreadsheet, remember that wrapping is formatting stored in the sheet, not a personal display preference. Other viewers generally see the same cell layout, though their screen size and zoom level can make it look different. If recipients need to read long notes comfortably, keep columns wide enough and rows tall enough, and avoid relying on text spilling into neighboring blank cells. A later entry in one of those neighboring cells can make overflow disappear.

Google Sheets and Microsoft Excel both offer text wrapping, but their interface paths and display details are not identical. These steps use Google Sheets in a web browser; they are not Excel ribbon instructions. If you open the file in Excel, use Excel’s own Home tab wrapping control and check the layout there, since row heights and rendering can differ between spreadsheet programs.

Frequently Asked Questions

How do I wrap text in an entire column in Google Sheets?
Select the column by clicking its letter, then choose Format > Wrapping > Wrap. This applies the display setting to the selected column, including cells you fill later.

Does wrapping change or delete the text in a cell?
No. Wrapping changes how the cell displays its existing contents. It does not rewrite the value or split it among multiple cells.

Why is my wrapped text still cut off?
The row may be too short, the cell may be merged, or wrapping may not actually be selected. Choose Wrap, then increase the row height or fit the row to its contents and check the cell again.

Can I wrap text on my phone?
Yes. In the Google Sheets app, select the cell or range, tap the Format button, open the Cell tab, and turn on Wrap text. The control’s placement may vary slightly by app version.

How do I stop text from wrapping?
Select the cells and choose Format > Wrapping > Overflow or Clip. Overflow can show text across empty neighboring cells; Clip keeps the visible content within the cell boundary.

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.