Wrap Text in a Google Sheets Column: A Step-by-Step Guide

To wrap text in a Google Sheets column, select the column by clicking its letter, then choose Format > Wrapping > Wrap. The cell contents will display on multiple lines instead of running into the next cell or being cut off. You can also apply wrapping to just a selected range, and it does not change the text itself.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
At least one cell with text or other content you want to display on multiple lines.
Permission to edit the spreadsheet. If you can only view it, you will not be able to change its formatting.

Step-by-Step

Open the spreadsheet and identify the column. Find the column whose entries are too long to read comfortably. Wrapping works for text, numbers, dates, and other cell contents; it changes how the contents are displayed, not the underlying value. If the sheet has a header row, decide whether the setting should apply to the header as well as the data.
Select what you want to format. To wrap every current and future cell in a column, click its letter at the top of the sheet, such as B. The entire column should become highlighted. To change only part of the column, click and drag across the cells you need, or select the first cell and then extend the selection with Shift-click. For example, select B2:B30 if you want to leave the heading in B1 unchanged.
Open the wrapping options. In the Google Sheets menu bar, click Format, then point to or click Wrapping. The submenu contains the options Overflow, Wrap, and Clip. These choices control what happens when the contents are wider than a cell.
Choose Wrap. Click Wrap in the submenu. Sheets will display the selected cells’ contents on additional lines when needed. If you selected a column letter, the setting applies to the whole column; if you selected a range, it applies only to those cells. The cell contents remain intact, and you can still edit or copy them normally.
Check the result in the grid. Look at a cell that previously appeared cut off or ran across empty cells. Its text should now break onto lines inside the same cell. Sheets generally increases the row height to show the wrapped lines, so one long entry can make its row taller than neighboring rows. Scroll or zoom if necessary to confirm the whole entry is visible.
Use the toolbar as an alternative. If the toolbar shows the text-wrapping control, select the same column or range, click the Text wrapping button, and choose Wrap. The icon may look like lines with an arrow, and the button may be grouped with other text-formatting controls. If you cannot identify it, use the Format menu path instead; the menu is the dependable option.
Adjust the column width if the layout needs it. Wrapping does not widen a column. If the column is too narrow, drag the boundary between its letter and the next column letter to make it wider. A wider column usually means fewer wrapped lines; a narrower one means more lines and taller rows. Find a width that keeps the entries readable without making the whole sheet unwieldy.
Apply the setting to other columns if needed. Repeat the selection and wrapping steps for each column that needs the same treatment. To return a selection to its previous single-line behavior, open Format > Wrapping and choose Overflow or Clip, depending on how you want text to appear. Overflow can show content over adjacent empty cells, while Clip hides the part that does not fit.

In Microsoft Excel, the equivalent command is usually Home > Wrap Text on Windows. The steps above are for Google Sheets in a browser, where the menu path is Format > Wrapping > Wrap.

Common Mistakes

Selecting a cell when you meant to select the whole column: If only one cell is active, wrapping changes only that cell. Click the column letter when you want the setting for every row in that column. Conversely, avoid selecting the whole column if you only want to format a small block; select a specific range to keep headings or unrelated cells unchanged.

Expecting wrapping to widen the column: Wrap keeps the content inside the cell and uses additional lines. It does not automatically create more horizontal space. If the column is very narrow, the result may be a stack of short words and unusually tall rows. Adjust the width as well if the layout looks cramped.

Confusing Wrap with Clip or Overflow: Clip hides text that does not fit inside the cell. Overflow can display it across neighboring empty cells, but another cell’s content can block that display. Wrap is the option to use when the goal is to see the full contents within the column without relying on empty cells beside it.

Assuming the text has been edited: A visual line break caused by wrapping is not necessarily a line break inserted into the cell’s value. The content can still be one continuous string. If you copy it into another program, the pasted appearance may differ because the destination handles line breaks and cell formatting separately.

Ignoring merged cells or fixed row heights: Merged cells and manually set row heights can make the expected display less predictable. If a wrapped entry remains partly hidden, check whether its row has a fixed height or the cell is merged with adjacent cells before repeatedly changing the wrapping setting.

Tips

Use whole-column wrapping for a column that will keep receiving long entries, such as descriptions, notes, addresses, or task details. It means you do not need to repeat the formatting for each new row. If the sheet has a title or a short header that should stay on one line, select only the data range instead of the entire column.

Think about the reading direction of the sheet. A narrow notes column can keep a table from spreading too far across the screen, but wrapping may make individual rows quite tall. A moderately wider column can reduce that height and make it easier to compare records. Try a few widths and judge the result using the longest typical entry, not just the first short example.

Use wrapping together with alignment and formatting only when those changes help readers. For example, left-aligning descriptive text can make wrapped paragraphs easier to scan, while keeping dates or short numeric values centered or right-aligned may suit a table. Wrapping itself does not set alignment, font size, or text color; those are separate formatting choices.

When working with a shared sheet, consider whether changing an entire column will affect other people’s layout. If the sheet is a structured report or template, formatting only the relevant data range may be less disruptive. You can also check the sheet at its normal zoom level and on a smaller screen, because a width that looks comfortable on a large monitor may produce many more lines on a narrow display.

If a cell contains an especially long description, wrapping is often easier to maintain than manually inserting line breaks. Manual breaks can leave awkward spacing when someone edits the text later. Use them only when you deliberately need a break at a specific point, such as separating an address into lines; ordinary wrapping lets Sheets decide where text should continue based on the available width.

Troubleshooting

The text still appears cut off. First confirm that the intended cell or column is selected and that Wrap, rather than Clip or Overflow, is active. Reopen Format > Wrapping and select Wrap again if needed. Also check whether the value is actually in the cell you formatted; text in a neighboring column is not affected by selecting the wrong column.

The text wraps but the bottom lines are not visible. The row may have a set height that is too small, or a merged cell may be interfering with the layout. Try making the row taller by dragging the boundary below its row number. You can also double-click that boundary to fit the row to its contents. If several rows need attention, select their row numbers, right-click, choose Resize rows, and use the fit-to-data option if it is available in the dialog.

The row becomes much taller than expected. Check the column width and look for unusually long text, repeated spaces, or a long unbroken string such as a URL or code. Widening the column may reduce the number of lines. If only one entry is unusually long, consider whether it belongs in a separate notes field or whether the row should remain tall so its full contents can be read.

The toolbar option is missing or hard to recognize. Toolbar layouts can vary with window size and available space. Maximize the browser window or use the menu route Format > Wrapping > Wrap, which avoids searching for the icon. If the menu command is unavailable, check that you have edit access and are not viewing a protected range that prevents formatting changes.

Only some of the cells changed. Look at the highlighted selection before choosing the command. A partial range, a filtered view, or an accidental single-cell selection can make it seem as though the setting failed. Select the column letter again to apply wrapping throughout the column, or deliberately select the full data range you want to format.

Frequently Asked Questions

Does wrapping change the contents of a cell?
Usually, no. Wrapping changes how Sheets displays the existing contents inside the cell. It does not automatically insert line-break characters into the value.

Can I wrap text in just one column?
Yes. Click that column’s letter, then choose Format > Wrapping > Wrap. To affect only some rows in the column, select a cell range instead of the column letter.

Will new entries in the column also wrap?
If you applied the setting to the entire column, new entries in its cells use that formatting too. If you formatted only a limited range, entries outside that range may not wrap until you apply the setting to them.

Why did wrapping make some rows taller?
Sheets needs enough vertical space to display the additional lines. A cell with more wrapped lines can increase its row’s height. If the row height was manually limited, you may need to resize the row so all lines show.

Can I wrap text in multiple columns at once?
Yes. Select the columns or cell ranges you want to format, then choose Format > Wrapping > Wrap. Check the selection carefully first so you do not change unrelated parts of the sheet.

How do I stop text from wrapping?
Select the affected cells or column, open Format > Wrapping, and choose Overflow or Clip. Choose Overflow to let text extend into empty neighboring cells, or Clip to keep it visually 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.