Google Sheets: How to Wrap Text in Cells and Fix Rows

To wrap text in Google Sheets in a web browser, select the cell or cells, then choose Format > Wrapping > Wrap. The text will display on multiple lines inside each cell, and Sheets will usually make the row taller so the content is visible.

What text wrapping does in Google Sheets

A cell can contain more text than its current width can show on one line. Wrapping changes how that text is displayed: instead of extending across neighboring empty cells or being cut off at the cell edge, it continues on additional lines within the same cell. The cell’s stored value does not change, and wrapping does not insert spaces or line-break characters into the text.

This is useful for column headings, addresses, notes, product descriptions, and other entries where making a column very wide would make the rest of a sheet harder to read. For example, a narrow column headed “Delivery instructions” can show the whole heading across two lines instead of forcing the column to take up a large part of the screen.

Wrapping is a display setting, not a way to edit or shorten content. A wrapped cell still contains the full text, which remains available in the formula bar when you select the cell. You can search, copy, and use the value in formulas as usual.

Wrap text using the Format menu

The menu method is reliable even if the toolbar layout or icons differ in your browser window. To apply it:

Open the spreadsheet in Google Sheets.
Select the cell, range, or column you want to format. To select a whole column, click its letter at the top of the sheet.
Choose Format > Wrapping > Wrap.
If necessary, adjust the column width or row height so the wrapped text is easy to read.

To wrap several separate cells together, drag across a range or select the first cell and extend the selection with the keyboard. The setting applies to the selected cells, including cells that are currently blank. If you select the whole sheet using the blank square above row 1 and left of column A, the setting applies across the sheet; use that broad selection only when you want a sheet-wide change.

Google Sheets also provides a text-wrapping control in the toolbar. Select the cells, open that control, and choose Wrap. If you are unsure which icon it is, hover over toolbar buttons to see their names, or use the Format menu path above.

How column width and row height affect wrapped text

Wrapping responds to the available column width. A narrower column generally creates more lines, while a wider one creates fewer. If a sentence breaks in an awkward place, try widening the column slightly before changing the wording. This is often a better choice for a table with a few descriptive columns than making every row much taller.

When a row contains wrapped content, Sheets generally increases its height to display the additional lines. That can make the table easier to read, but it can also make a long sheet substantially taller. If a row has a manually specified height, or if the text still appears cut off, resize the row: move the pointer to the boundary below its row number and drag, or right-click the row number and choose Resize row. You can also select several rows before resizing them.

There is a practical trade-off between width and height. A very narrow notes column may turn a short note into many lines and slow down scanning. A very wide notes column may push important columns off-screen. Choose widths based on the information people need to compare, and let occasional longer entries take extra row height where that is reasonable.

Wrap, overflow, and clip compared

Google Sheets offers three text-wrapping behaviors. They change what is visible in the grid, not the underlying cell value:

Overflow lets text appear in adjacent empty cells. If a neighboring cell contains data, the visible text stops at that boundary. This can be convenient for brief labels, but the display may change when nearby cells are filled.
Wrap displays text on multiple lines inside the cell. It is usually the clearest choice when readers need to see the full value in the grid.
Clip keeps the text on one line and hides the part that does not fit within the cell. The hidden portion is still in the cell and can be viewed by selecting it, but it is not displayed in the grid.

To change between them, select the cells and open Format > Wrapping, then select the desired option. For a report or shared data-entry sheet, Wrap is often preferable for explanatory text. For a compact dashboard where the full value is not essential, Clip may keep rows aligned. Overflow can work well for an occasional heading, but it is less predictable when adjacent cells will be used.

Wrapping is different from adding a line break

Automatic wrapping and a manual line break can look similar, but they serve different purposes. Wrapping lets Sheets decide where text moves to another line based on the current column width. If you later widen or narrow the column, those line positions can change. A manual line break is part of the cell’s text and keeps a chosen break in place, even if the column width changes.

Use wrapping for ordinary paragraphs, labels, and notes. Use a manual break when a specific split is meaningful, such as putting a person’s name and job title on separate lines in one cell. In Google Sheets, edit the cell and insert a line break with the keyboard command supported by your operating system and browser; because shortcuts can vary by platform, check Help > Keyboard shortcuts in Sheets if the usual key combination does not work. You can also keep the text in separate rows or columns when it needs to be sorted or analyzed as separate fields.

Manual line breaks do not replace the Wrap setting in every situation. If the cell is too narrow, a manually split line can itself wrap further. Conversely, a wide cell may leave extra space after a manual break. Check the finished layout at the column width people will actually use.

Common problems and how to fix them

If wrapping appears not to work, first confirm that you selected the cell whose text you are looking at. Then reopen Format > Wrapping and check that Wrap is selected. A cell may already be wrapped while its row height or column width makes the result look unexpected.

Only one line is visible: Increase the row height by dragging the row boundary or using Resize row. Check for a manually constrained height.
Text stops at the cell edge: The cell may be set to Clip rather than Wrap. Select it and choose Wrap from the Wrapping menu.
The row becomes too tall: Widen the column, shorten the text if appropriate, or use Clip for content that does not need to be shown in full.
Text seems to spill over: That is usually Overflow, not Wrap. Switch the cell to Wrap, or put content in neighboring cells only if that matches the table design.
A merged cell does not resize as expected: Merged cells can make automatic row sizing less convenient. Adjust the row height manually or reconsider whether merging is necessary.

Also check whether the content contains an unusually long string without spaces, such as a tracking code or web address. Such strings may not break at useful points, so widening the column or placing the identifier in its own column can be more readable than relying on wrapping alone.

Apply wrapping consistently to a table

For a table that will grow, format the whole relevant column rather than only the cells that currently contain text. Click the column letter and choose Format > Wrapping > Wrap. New entries in that column will use the chosen formatting in the cells included in the selection. If the sheet has a title or special header layout, select only the data columns or ranges that should follow the same rule.

Consistency matters when several people enter data. For example, a shared issue log might wrap the Description and Resolution columns while keeping short fields such as Priority and Status on one line. This makes long explanations visible without making every column wide. It also helps to set sensible column widths before people begin entering lengthy notes.

Formatting does not validate what people type. Wrapping a Description column will display long descriptions, but it will not enforce a maximum length or ensure that an entry is complete. If the sheet is intended for data collection, use clear headings and instructions as well as suitable formatting.

Viewing wrapped cells on different devices

The steps above describe Google Sheets in a web browser. The Google Sheets mobile app has a different interface, so its menus and controls may not match the browser’s Format menu exactly. If you are using a phone or tablet, select the cell and look in the app’s formatting controls for text wrapping. For detailed layout work, the browser version makes it easier to select full ranges and adjust rows and columns precisely.

People viewing a shared sheet may also have different screen sizes. A layout that fits a desktop monitor can require much more scrolling on a phone, especially if many columns are wrapped. Keep essential information near the left side of the sheet, use concise headings, and avoid wrapping every column without considering how the table will be read.

In Microsoft Excel, text wrapping is available too, but the menus are different. Excel for Microsoft 365 on Windows uses Home > Wrap Text; that is not the Google Sheets menu path. Instructions for one program should not be assumed to apply to the other.

Frequently Asked Questions

How do I wrap text in Google Sheets?
Select the cell or range and choose Format > Wrapping > Wrap. The text then displays on multiple lines within the selected cells.

Does wrapping text change the cell value?
No. Wrapping changes how the value is displayed. It does not remove text or insert line breaks into the stored value.

Why is my wrapped text still cut off?
The row may be too short, or the cell may be set to Clip. Confirm Wrap is selected and increase the row height if needed. Merged cells may also need manual row sizing.

How do I wrap an entire column?
Click the column letter to select it, then choose Format > Wrapping > Wrap. This applies the display setting to the selected column, including its blank cells.

Can I wrap text without making the row taller?
Wrapping normally needs additional row height to show all the lines. If you keep the row short, some text may not be visible; use Clip when a single-line display is more important than seeing the full value.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.