Wrap Text in Google Sheets Without Changing the Cell Value

To wrap text in a Google spreadsheet, select the cell or range and choose Format > Wrapping > Wrap. The text will display on multiple lines inside each cell instead of extending across neighboring columns.

Wrapping changes the display, not the underlying cell value. It does not split the text or add line-break characters. That makes it useful for reviewing long fields such as Description, Methodology or Source notes before publishing a table.

Wrap one cell, a range or a whole column

On a computer:

1. Select the cell or range containing the long text.
2. Choose Format > Wrapping > Wrap.
3. Widen the column if each record occupies too many lines.
4. Check that each row is tall enough to show the complete value.

You can also use the Text wrapping button in the toolbar. Google includes text wrapping among the current Google Sheets cell-formatting controls.

To apply the setting more broadly:

• Whole column: Click its letter, such as D, and apply Wrap.
• Several columns: Drag across their column letters, then apply Wrap.
• Entire sheet: Click the blank square above row 1 and left of column A, then apply Wrap.

For a table you plan to publish, apply wrapping mainly to columns that contain prose. Wrapping short identifiers, dates and numeric measures adds little and can create uneven row heights that are harder to scan.

Choose Wrap, Overflow or Clip

Google Sheets provides three text-display strategies:

• Wrap: Moves text that exceeds the cell width onto additional lines.
• Overflow: Keeps text on one line and displays it over the next cell while that cell is empty.
• Clip: Hides the portion that does not fit within the cell width.

Google’s WrapStrategy documentation confirms these behaviors and notes that Overflow acts like Clip when the adjacent cell is not empty.

Use Wrap when readers need to inspect the complete description. Use Clip for a compact working view when you can inspect the full value in the formula bar. Do not rely on Overflow to present a finished table: entering data in the adjacent cell can hide part of the overflown text.

If wrapped text is still cut off

A row with a specified height may not show every wrapped line. Select the affected rows, right-click a row number, choose Resize rows, and select Fit to data. You can also drag a row boundary manually.

If rows become excessively tall, widen the column instead of forcing a long prose field into a narrow space. Top-aligning cells can also make records with different amounts of text easier to compare.

Wrap text on Android, iPhone or iPad

In the Google Sheets mobile app:

1. Tap a cell and drag the blue selection handles over the required range.
2. Tap Format.
3. Open the Cell tab.
4. Turn on Wrap text.
5. Tap the sheet to save the change.

Google documents this Cell-tab control for both Android and iPhone and iPad.

Wrapping is not the same as adding a line break

Wrapping lets Sheets decide where each displayed line ends based on the column width. A manual line break becomes part of the cell’s content. While editing a cell on a computer, press Ctrl + Enter on Windows or Command + Enter on Mac to insert another line, according to Google’s desktop instructions.

Use manual breaks only when the internal structure matters, such as separating a short title from its note. Because those breaks are part of the value, inspect them when you validate a CSV export against the original spreadsheet.

If one cell contains several categories, people or observations that must be sorted and filtered independently, wrapping will not fix the data structure. Put those values in separate fields or rows. For consistently delimited values, see how to split a spreadsheet column into separate fields.

Do not merge cells merely to make long values fit. Merged cells complicate sorting and tabular reuse; try wrapping and a suitable column width first. If the sheet already uses merged headings, review how to merge cells without losing text.