How to Wrap Text in Google Sheets Without Clipping

To wrap text in Google Sheets, select the cell or range, then choose Format > Wrapping > Wrap. The text will display on multiple lines inside each cell, and rows can grow to show the full content. You can also use the Text wrapping button on the toolbar. These steps are for Google Sheets in a web browser; Google Sheets menus differ from Excel’s ribbon.

What You’ll Need

A Google account with access to the spreadsheet you want to edit.
A web browser with the spreadsheet open in Google Sheets. You do not need an add-on, formula, or special file format.
Edit access if you need to change formatting. With view-only access, you can inspect the sheet but cannot apply wrapping to it.

Step-by-Step

Open the spreadsheet and locate the text. Find the cells whose contents are running into nearby columns, disappearing at the cell edge, or making the sheet difficult to read. Wrapping is a formatting setting, so it changes how content appears without changing the words, numbers, or formulas stored in the cells. If the text is in a single cell, you can format just that cell. If you expect several cells in a column to contain longer entries, select the whole range or column instead.
Select the cells you want to format. Click one cell to wrap only that cell. To select a continuous range, click the first cell and drag to the last, or click the first cell, hold Shift, and click the last. To format an entire column, click its letter at the top; to format an entire row, click its number at the left. You can select multiple separate ranges by holding Ctrl on Windows or Command on Mac while selecting additional cells. Check the highlighted selection before changing the setting so you do not accidentally format more of the sheet than intended.
Open the wrapping options. In the menu bar, click Format, point to Wrapping, and select Wrap. This is the dependable menu route in the browser version of Google Sheets. If you prefer the toolbar, look for the Text wrapping button, which has an icon suggesting text and an arrow or lines. Click it and choose Wrap. If you cannot identify the toolbar control, use the Format menu rather than guessing at an icon.
Check how the selected cells display. After you apply Wrap, long text should continue onto additional lines within its cell instead of extending across an empty neighboring cell or being cut off at the boundary. The row will usually expand to accommodate the extra lines. Look at the cells below as well: an expanded row moves later rows downward, but it does not move the text into another cell. If the result is difficult to read, adjust the column width or row height as described below.
Adjust the column width if needed. Wrapping controls line breaks, but the width of the column determines how much text fits on each line. To change the width, move the pointer to the boundary between two column letters and drag it left or right. You can also right-click the column letter and choose Resize column to enter a specific width or fit the column to its data. A slightly wider column may reduce the number of lines; a narrower one may make descriptions taller and harder to scan.
Fit the row height to the wrapped content. Sheets often adjusts row height when wrapping is applied. If all lines are not visible, select the affected row or rows, right-click a row number, and choose Resize rows. In the dialog, choose Fit to data and confirm. For a single row, you can also move the pointer to the lower border of its row number and double-click to fit the height. This is useful when a row has a manually set height that is too small.
Apply the setting to future entries, if appropriate. If a column is meant for notes, addresses, or descriptions, select the whole column and set it to Wrap before adding more content. New text entered in those cells will then use the same wrapping format. If only a few cells need multiple lines, keep the selection limited to those cells so short values elsewhere remain compact. You can change the selection’s wrapping option later without editing the cell contents.

Common Mistakes

Choosing Clip instead of Wrap. The Wrapping menu includes different display behaviors. Overflow lets text extend into adjacent empty cells; Clip hides the part that does not fit in the cell; Wrap displays the text on multiple lines inside the cell. If the text still seems missing after formatting, reopen Format > Wrapping and confirm that Wrap is selected for the affected cells.

Formatting the wrong range. The setting applies to the selected cells, not automatically to every cell in the sheet. A common reason some entries wrap while others do not is that only one cell or part of the column was selected. Select the intended range and apply Wrap again. Conversely, avoid selecting the entire sheet just to fix one note unless you want the whole sheet’s layout to change.

Expecting wrapping to change the column width. Wrap changes where text appears on lines; it does not automatically make a narrow column wider. A narrow column may produce many short lines and a tall row. Resize the column if the resulting layout is awkward. Also remember that increased row height can make the sheet longer to scroll, which is normal when more content is displayed.

Assuming the content was edited or split. Wrapping is not the same as inserting a line break or splitting text into multiple cells. It is a visual layout choice, and the full value remains in one cell. If you copy the cell, the original content is still one cell value. Do not use wrapping when your goal is to separate a name, address, or other entry into different columns.

Tips

Use wrapping selectively to make long entries readable while keeping numeric tables compact. It is often useful for headings, comments, product descriptions, addresses, and task details. For a sheet with many columns, wrap only the descriptive columns; wrapping every column can create tall rows and make comparisons harder. For a clear header row, consider wrapping the headings and then making the row a little taller so the labels are easy to scan.

Think about column width and row height together. For example, a notes column that is too narrow can turn a two-sentence note into a very tall cell. Widening it may reduce the line count. If the sheet is intended for printing, use Print preview to see whether the extra row height creates page breaks in inconvenient places. Wrapping affects the sheet’s layout and may change how much content fits on each printed page.

To apply the same layout to a set of cells, select the range once rather than repeating the command cell by cell. If you are unsure how a formatting change will affect a large table, try it on a small range first. You can undo the change with the Undo button or Ctrl+Z on Windows; on Mac, use Command+Z. Undo reverses the recent formatting action, although it may also undo any later action if you have continued editing.

When a cell contains a long paragraph, consider whether the paragraph belongs in the sheet at all. Wrapping makes it visible, but it does not make lengthy text easier to compare or analyze. A concise note, a link to a longer document, or a separate notes tab may be more useful for some workflows. Keep the original content in the cell if it is important; wrapping itself does not remove or shorten it.

Troubleshooting

The text still appears cut off. Select the affected cell and check Format > Wrapping > Wrap. If Wrap is already selected, inspect the row height. A fixed or manually reduced row height can hide lower lines, so use Resize rows > Fit to data. Also check whether the column is so narrow that each word breaks onto a new line or the cell becomes unusually tall.

The row does not get taller. Select the row, right-click its number, choose Resize rows, select Fit to data, and apply the change. If the cell is merged across multiple columns, automatic row sizing may not behave as expected. Try unmerging it if that suits the layout, or adjust the row height manually by dragging its lower boundary. Merged cells can also make sorting and filtering more difficult, so use them only when the sheet design requires them.

Only some cells wrap. The cells may have different formatting, or your selection may not have covered the whole range. Select the full intended range and choose Format > Wrapping > Wrap again. If the sheet is protected, you may not have permission to change formatting; ask the owner or an editor for access. If you are working in a filtered or hidden area, confirm that the cells you want to change are included in your selection.

The layout looks different after resizing. Row height and column width affect the visible layout, and changing one can alter how many lines appear. Use Undo if the resize caused an unwanted result, then resize the relevant column or use Fit to data on the affected rows. If the text itself contains intentional line breaks, those breaks remain part of the displayed content; wrapping adds line breaks as needed to fit the cell but does not remove the intentional ones.

Frequently Asked Questions

What does Wrap do in Google Sheets?

Wrap displays long cell content on additional lines inside the same cell. It keeps the full value in that cell and can increase the row height so more of the text is visible.

Can I wrap text in an entire column?

Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. All cells in that column use the setting, including cells you fill in later.

Does wrapping change the actual cell value?

No. It changes how the value is displayed, not the content stored in the cell. It does not split the text into separate cells or insert new characters into the value.

How do I stop text from wrapping?

Select the cells, open Format > Wrapping, and choose Overflow or Clip. Overflow displays text in adjacent empty cells where possible; Clip keeps the display within the cell and hides content that does not fit.

Why is wrapped text still not fully visible?

The row may have a fixed height, or the cell may be merged. Use Resize rows > Fit to data, increase the row height manually, or review whether the merged layout can be changed. Also verify that Wrap is selected for the cell.

Can I wrap text in Google Sheets on a phone?

Yes, but the controls are arranged differently in the Android and iOS apps than in the browser. Select the cell or range, open the formatting controls, and look for the text wrapping option. The browser steps above apply to Google Sheets on a computer.

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.