How to Auto Wrap Text in Google Sheets: A Quick Guide

To automatically show long text on multiple lines in Google Sheets, select the cells, then choose Format > Wrapping > Wrap. Sheets will display the cell contents within the column width and expand row height as needed. You can apply wrapping to a few cells, a range, or an entire sheet, and change it later without editing the text.

What You’ll Need

A Google account with access to a spreadsheet in Google Sheets.
A desktop web browser and a sheet containing text you want to display. You do not need an add-on, formula, or special setting.

The steps below describe Google Sheets in a web browser. The mobile app has similar formatting controls, but the menus and screen layout differ. If you are using Excel instead, its command is Home > Wrap Text, not the Google Sheets menu path used here.

Step-by-Step

Open the spreadsheet. Go to Google Sheets and open the file you want to format. Find the text that is being cut off or spilling across empty cells. If you are unsure which cells need wrapping, click one of them first and check the column letter and row number so you can select the correct range in the next step.
Select the cells to format. Click a cell to wrap just that cell. To wrap a group, click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. You can also select a whole column by clicking its letter, or several adjacent columns by dragging across their letters. To select every cell on the current sheet, click the blank square in the top-left corner above row 1 and left of column A.
Open the wrapping menu. With the target cells selected, choose Format > Wrapping from the menu bar. A submenu offers Overflow, Wrap, and Clip. These options control how cell contents are displayed; they do not delete or rewrite the underlying text.
Choose Wrap. Click Wrap. Google Sheets will fit the text onto multiple lines inside each selected cell. The row will generally grow taller to show the wrapped lines, while the column keeps its existing width. The change applies to all selected cells, including cells that currently look fine, so select only the intended range if you do not want to alter other formatting.
Check the result at normal zoom. Click another cell or press Enter to leave the selection and inspect the rows. Look for text that now appears on two or more lines, and check that the full final line is visible. If a long word or unbroken string still does not fit neatly, continue to the troubleshooting section; wrapping cannot create natural break points inside every kind of text.
Adjust the column width if needed. Wrapping keeps the column width fixed, so a very narrow column can produce many short lines and unusually tall rows. To make the layout easier to read, drag the boundary between column letters to widen the column. Double-click that boundary to fit the column to its contents, but note that fitting the width may make the column so wide that wrapping is no longer useful. Choose a width that balances readable lines with the space available on screen or in a printout.
Apply wrapping to other areas as necessary. Repeat the selection and menu steps for other ranges. For a consistent sheet, select the whole sheet before choosing Wrap. You can also set a column to wrap when it contains descriptions, comments, or addresses, while leaving short ID or date columns on another setting. Review headings and totals after applying a broad selection so you can spot any rows that became taller than intended.

There is also a toolbar shortcut: select the cells and use the text-wrapping control in the toolbar to choose Wrap. The toolbar icon can be less obvious if the window is narrow or the toolbar is customized, so the Format menu is a dependable route. If you cannot see the menu bar, make sure you are editing the sheet itself rather than viewing a preview or a read-only file.

Common Mistakes

Choosing Clip or Overflow by mistake: These are different display behaviors. Overflow lets text extend into empty neighboring cells, while Clip hides the portion that does not fit within the cell. Neither option is the same as wrapping. If text remains on one line or appears cut off after a change, reopen Format > Wrapping and confirm that Wrap is selected.

Selecting only the visible cell: A cell can look like part of a larger block, but formatting applies only to the cells you actually selected. If other descriptions still run across the sheet, select those cells too and apply Wrap again. Conversely, selecting the whole sheet when you meant to change one column can make many rows taller, so verify the highlighted range before using the menu.

Expecting wrapping to widen a column: Wrap changes how text occupies the cell; it does not automatically choose a wider column. A narrow column can therefore create tall rows. Adjust width deliberately rather than repeatedly switching wrapping on and off.

Assuming hidden text is gone: Clip and a short row height can make content look missing even though the cell still contains it. Click the cell and read the formula bar to confirm its full value before changing or retyping anything. Wrapping is a display format, not a content-cleanup operation.

Ignoring merged cells: Merged cells can make row sizing less predictable, especially when a heading spans multiple columns. If wrapping does not expand a merged row enough to display everything, consider unmerging the cells or setting the row height manually. Keep merged cells for layouts that genuinely need them rather than using them for ordinary data tables.

Tips

Use wrapping where it improves scanning: longer notes, product descriptions, addresses, and column headings are common candidates. Short values such as codes, quantities, and dates often read better on one line. A mixed layout is usually easier to use than wrapping every cell automatically, because it avoids making compact columns unnecessarily tall.

Set column widths before fine-tuning row heights. When you widen a column, the text may fit on fewer lines; when you narrow it, it may take more lines. Working in that order reduces repeated resizing. For a tidy table, keep related columns at consistent widths and use wrapping for the columns expected to contain variable-length text.

If a row is still too tall or too short, you can adjust its height. Right-click the row number and choose Resize row, then enter a height or choose the option to fit the data. For multiple rows, select their row numbers first and use the corresponding resize option. Use fit-to-data when you want the visible text to determine row height; use a fixed height when a uniform layout matters more and you have checked that the text remains readable.

Remember that wrapping is a cell-format setting. It normally remains in effect as the text changes, so adding a longer description later can cause that row to grow. If you paste content from another source and the display looks different, check the destination cells’ wrapping setting: pasted formatting may affect how the result appears. When only the text should be brought in, use the paste option that pastes values only if it is available and appropriate for your task, then check the layout.

For a sheet that will be printed or exported, preview the page after setting widths and wrapping. A layout that is comfortable in the browser may use many printed pages if rows have become tall or columns are too wide. In Excel for Microsoft 365, wrapping is also supported, but the Windows command is Home > Wrap Text; the menu names and placement differ from Google Sheets.

Troubleshooting

The text still runs into the next cell. Confirm the correct cell is selected and choose Format > Wrapping > Wrap. If the neighboring cells are empty, overflow can make text appear to cross a boundary; if those cells contain values, Sheets may stop the overflow. Wrapping forces the text to remain within its own cell and display across lines. Also check whether you selected the cell whose text is visible rather than an adjacent blank cell.

The text is wrapped, but the bottom lines are hidden. The row may have a manually constrained height. Point to the bottom boundary of the row number and drag it downward, or right-click the row number and choose Resize row and then fit the row to its data. If several rows need attention, select their row numbers together before resizing. A merged cell may not resize as expected, so test with a regular, unmerged cell if the problem persists.

Only some cells changed. Check the selection you made before applying the command. If a range was missed, select the remaining cells and set Wrap. If the cells are separated, select one range, apply the setting, and repeat for the others, or use Ctrl-click to add non-adjacent cells on a desktop browser where that selection behavior is supported. Avoid selecting entire columns just to fix a few cells unless you want future entries in those columns to use the same format.

The row became extremely tall. A very narrow column, long paragraphs, or text with line breaks can create many displayed lines. Widen the column, shorten unnecessary text, or set a practical row height after checking what will remain visible. You may also decide that Clip or Overflow is more suitable for a particular column, but understand that those options can hide text or let it extend outside the cell.

The change does not seem to save. Google Sheets normally saves edits automatically when you are online. Check the connection indicator and wait for the document to finish saving. If you have view-only access, you will not be able to change formatting; ask for edit permission or make an authorized copy. If the menu is unavailable, reload only after confirming that any pending changes have been saved, then reopen the sheet and try again.

Frequently Asked Questions

Does Google Sheets automatically wrap text by default?
Not in every cell. Cells commonly use overflow behavior, so text can appear across empty neighboring cells or be visually limited by nearby content. Choose Wrap for the cells or range where you want text to stay within the cell and continue on additional lines.

Does wrapping change the text in the cell?
No. It changes how the text is displayed, not the value itself. You can still select the cell and edit the original text, and switching to Overflow or Clip changes the display without removing the contents.

Can I wrap text in an entire column?
Yes. Click the column letter to select it, then choose Format > Wrapping > Wrap. This applies the setting to the column’s cells, which can be useful when new or existing entries may contain long text. Check the column width afterward so the rows do not become unnecessarily tall.

Can I wrap text on multiple cells at once?
Yes. Select a contiguous range by dragging over it or using Shift-click, then apply Wrap once. For separate ranges, repeat the operation or select the relevant cells together if your browser and selection method allow it. Verify the highlighted cells before changing the format.

Why does wrapping make my row taller?
Sheets needs more vertical space to show the additional lines while keeping the column width unchanged. This is expected. Widening the column can reduce the number of lines, while reducing the row height can conceal some of the wrapped text.

How do I undo wrapping?
Select the affected cells, choose Format > Wrapping, and select Overflow or Clip, depending on how you want the text displayed. This changes the display behavior only; it does not undo edits to the cell contents.

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.