Wrap Text in Google Sheets: Steps, Options, and Fixes

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 button on the toolbar and choose Wrap; the text will display on multiple lines inside the cell instead of running into neighboring cells.

How to Wrap Text in Google Sheets

Wrapping is a cell-formatting option, so it can be applied to a blank cell before you enter text or to cells that already contain content. To apply it to one cell, click that cell. To apply it to several cells, drag across a range, or select a whole column by clicking its letter at the top of the sheet. Then use the menu path Format > Wrapping > Wrap.

The toolbar is a quicker route when its controls are visible. Select the cells, click the text-wrapping icon, and choose Wrap from the choices. If you are unsure which toolbar control it is, the Format menu is a dependable way to locate the setting. The change affects how the selected cells are displayed; it does not rewrite their contents.

For example, if cell A2 contains “Delivery scheduled for Thursday afternoon” and column A is narrow, wrapping moves part of the phrase onto another line within A2. The text remains in A2, and the next column remains available for its own data. Wrapping is useful for headings, notes, descriptions, addresses, and other entries that are too long for a compact column.

What Text Wrapping Changes

A spreadsheet cell has a width and a height, while the text stored in it may be longer than the space available. The wrapping setting tells Sheets how to display that text relative to the cell’s boundaries. With wrapping on, Sheets breaks the displayed text into lines to fit the column width. It does not insert spaces or change the value itself.

In a typical sheet, the row grows taller to show the additional lines. This makes the full entry visible without widening the column, but it can also make a table take up more vertical space. A wrapped row that contains one long description may therefore be taller than nearby rows with short values.

Wrapping is a display choice, not a way to shorten data or change how a formula uses it. Copying the cell still copies the underlying content. Searching, sorting, and calculations continue to use the cell value, not merely the portion currently visible on screen. If you need shorter text, edit the entry or create a separate shortened display value; changing wrapping alone does not remove characters.

Wrap, Clip, and Overflow Compared

Google Sheets offers three wrapping behaviors: Overflow, Wrap, and Clip. You can switch between them from Format > Wrapping or from the toolbar’s text-wrapping menu. Choosing among them is mainly a trade-off between visibility, row height, and compactness.

Overflow lets text appear across empty cells to the right. It is convenient for a short label in a spacious sheet, but text stops displaying where a neighboring cell contains data. The original value is still intact.
Wrap keeps the display within the cell’s column width and puts extra text on further lines. It reveals long entries but may increase row height.
Clip displays only the part that fits in the cell’s available space. It keeps the row compact, but the remaining text is hidden from view until you select or edit the cell, or change the display setting.

These options do not delete the part of a value that is not visible. A common misconception is that clipped text has been cut off from the data. Clipping affects the on-screen display only. Similarly, overflow does not move text into the next cell: the value remains in its original cell, even when its display appears over empty neighboring cells.

Adjust Column Width and Row Height

Wrapping and column width work together. A very narrow column creates many short lines and can make a row unusually tall. A wider column creates fewer lines, while a column wide enough for the full entry may make wrapping unnecessary. To change width, drag the boundary between column letters. You can also right-click a column letter and choose Resize column to enter a size or fit the column to its data.

When a wrapped entry is not fully visible vertically, adjust the row. Drag the boundary below the row number, or right-click the row number and choose Resize row, then choose Fit to data if that option is offered. This is helpful after a row has been given a fixed height or after its contents have changed. A row that is too short can hide lower lines even though wrapping is enabled.

For a report or shared tracker, choose widths with the whole sheet in mind rather than making every column as wide as its longest entry. For instance, a task table might give the task-name column moderate width, wrap the longer description column, and keep a short status column narrow. This preserves the table’s overall shape while allowing longer notes to remain readable.

Apply Wrapping to Many Cells

You do not have to set wrapping one cell at a time. Select the relevant range before choosing Format > Wrapping > Wrap. This is useful when a column is intended to hold entries with different lengths, such as product descriptions or customer comments. Selecting the column letter applies the setting to the column, including cells you fill later.

For a mixed table, select only the cells that benefit from wrapping. Applying it to every column may make headers and short numeric fields harder to scan by increasing row heights without adding useful information. A common layout is to wrap descriptive text and leave dates, quantities, codes, and brief labels on one line, while adjusting widths as needed.

Formatting can also be copied when you want another range to match. Copy a cell or range with the desired wrapping, select the destination, and use Edit > Paste special > Paste format only if that option is available in the current menu. This applies formatting without replacing the destination’s values. Check the result afterward, since copied formatting may include other visual properties as well as wrapping.

Use Manual Line Breaks for Specific Layouts

Automatic wrapping decides where lines break according to the cell width. If you need a deliberate break—for example, to put a person’s name on one line and a department on the next—you can edit the cell and insert a line break at the desired point. Double-click the cell or select it and edit its contents, place the insertion point where the break should go, and use the line-break shortcut supported by your device. In Google Sheets on a computer, this is commonly Ctrl+Enter on Windows or ⌘+Enter on Mac.

A manual break is part of the cell’s content, unlike an automatic wrap point, which shifts when the column width changes. This makes manual breaks useful for a few carefully designed labels, but less suitable for a column of unpredictable descriptions. If you insert a break into every record, later changes to column width may leave awkwardly short lines. Use automatic wrapping for ordinary data and manual breaks when a particular division has meaning or improves a fixed presentation.

Fix Common Wrapping Problems

If the text still appears on one line, first confirm that the correct cells are selected and that the setting is Wrap, rather than Overflow or Clip. Then check the column width and row height. A wide column may leave the text on one line because it already fits; a short row may show only some of the wrapped lines. Resizing the column or using Fit to data for the row can clarify which issue is responsible.

If text seems to disappear, inspect the neighboring cells and the wrapping mode. With Overflow, content may be visible only while the cells to the right are empty; another value can block that display. With Clip, content beyond the cell’s visible area is hidden. Neither case means the value was erased. Select the cell and look at the formula bar to inspect the full entry, or switch to Wrap to show it within the column.

Unexpectedly tall rows often mean that a column is too narrow for its longest wrapped entry. Widening that column can reduce the number of lines. If the sheet has many rows, use wrapping selectively instead of applying it to every field. Also check for manually inserted line breaks, which can create extra lines even when the column is wide.

For merged cells, be cautious when relying on automatic row sizing. Merging changes how cells occupy the grid and can make a layout harder to resize or sort. If wrapped content is not fully visible in a merged area, adjust the row height manually or reconsider whether merging is necessary. For tabular data, keeping cells unmerged usually makes filtering, sorting, and editing easier.

Choosing a Readable Sheet Layout

Use wrapping when readers need to see complete text but the column should stay within a reasonable width. It is especially helpful for comments, descriptions, addresses, instructions, and long column headings. Use Clip when compact rows matter more than seeing every character at once, such as in a dense overview where users can select a cell to inspect its full value. Use Overflow for short text in a clean area where adjacent cells are usually empty.

Think about how the sheet will be used. A data-entry sheet benefits from enough row height and wrapped instructions so people can understand what to enter. A dashboard may prioritize a tidy, consistent grid and use shorter labels or clipped detail. A sheet that will be printed may need a print preview check: wrapped rows can increase page length, and a column width that looks good on screen may not fit the printed page.

Wrapping is not the only way to make long content manageable. You can widen a column, shorten a label, move detailed notes into a dedicated column, or keep the full text in a cell and let users inspect it in the formula bar. These alternatives are useful when wrapping would make a large table too tall. There is no universally best setting; choose based on whether visibility, compactness, or quick scanning matters most.

Frequently Asked Questions

How do I wrap text in Google Sheets?

Select the cells, then choose Format > Wrapping > Wrap. You can also open the toolbar’s text-wrapping menu and select Wrap.

Does wrapping text change the cell value?

No. It changes how the value is displayed, not the stored text. Formulas, searches, and other operations still use the original cell content.

Why is my wrapped text cut off?

The row may be too short, or the text may be set to Clip rather than Wrap. Check the wrapping mode, then resize the row or choose Fit to data from the row’s resize options.

What is the difference between Wrap and Clip?

Wrap displays additional text on new lines inside the cell and can make the row taller. Clip keeps the row compact but hides the portion that does not fit on screen.

Can I wrap text in an entire column?

Yes. Click the column letter to select it, then choose Format > Wrapping > Wrap. New entries in that column will use the selected formatting.

Can I wrap text in the Google Sheets mobile app?

Yes, but the controls differ from the browser interface. Select the cell or range in the app, open its formatting controls, and enable text wrapping. The steps above describe Google Sheets in a web browser.

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.