How to Wrap Text in Google Sheets Without Clipping Cells

To wrap text in Google Sheets, select the cells, then choose Format > Wrapping > Wrap. Sheets will display long cell contents on multiple lines instead of letting them run into neighboring cells or hiding them. You can also use the text-wrapping control on the toolbar. This guide covers Google Sheets in a web browser; if you meant rotating or bending text rather than wrapping it, that is a different formatting effect.

What You’ll Need

A Google account with access to the spreadsheet you want to edit.
A web browser open to Google Sheets, plus permission to edit the sheet. If you only have view access, ask the owner for editing permission or make an editable copy if that option is available.
A cell, range, row, or column containing text you want to display on multiple lines. You do not need to change the text itself.

Wrapping changes how content is displayed, not the underlying value. It does not insert line-break characters into the cell or alter the text that formulas and searches use. Excel has a similarly named Wrap Text command on its Home tab, but the menu locations and interface are different; the steps below are for Google Sheets.

Step-by-Step

Open the spreadsheet and identify the text. Go to sheets.google.com or open the file from Google Drive. Find the cells where long entries are cut off, overflow into adjacent blank cells, or make the table hard to scan. Wrapping is useful for headings, notes, descriptions, addresses, and other content that needs to stay visible within a column.
Select the cells to format. Click a single cell to wrap only that cell. To apply the setting to a range, click the first cell and drag across the rest, or click the first cell, hold Shift, and click the last cell. To select a whole column or row, click its letter or number header. You can select multiple non-adjacent cells with Ctrl-click on Windows or Command-click on Mac, if you want to apply the same setting to separate areas.
Open the wrapping options. In the menu bar, click Format, then point to Wrapping. Choose Wrap from the submenu. The text should now break across lines inside each selected cell. The setting applies to the selected cells; it does not automatically change every cell in the sheet.
Use the toolbar as an alternative. With the target cells still selected, find the text-wrapping control in the toolbar. Click it to open the options, then choose Wrap. If you do not see the control, use the Format menu instead; toolbar contents can vary with window size, screen zoom, or available space. Hover over toolbar controls to read their tooltips rather than guessing from an icon.
Check the row height and column width. Wrapping normally lets a row grow taller to show the additional lines, while the column keeps its existing width. If the row looks too short, right-click its number on the left and choose Resize row, then select Fit to data when offered. You can also drag the lower boundary of the row number downward to make more room. To keep the table compact, widen the column slightly instead of making every row very tall.
Review the result at normal zoom. Click outside the selected range and look at the affected rows in context. Confirm that each entry is readable, that row heights are reasonable, and that the wrapping has not made a heading or adjacent data difficult to compare. If a phrase breaks awkwardly, consider widening the column a little or shortening the cell text before making the whole sheet wider.
Apply the same layout elsewhere if needed. Select another range and repeat the Wrap command. For a consistent table, select the whole relevant column before choosing Wrap so both existing entries and future text entered in those cells use the setting. Avoid selecting the entire sheet unless you really want wrapping throughout; that can make many rows unexpectedly tall.

Google Sheets offers three wrapping choices: Overflow, Wrap, and Clip. Wrap shows the full cell contents on multiple lines. Overflow allows text to appear across adjacent empty cells, but neighboring content blocks that display. Clip hides the part that does not fit in the cell’s current width. If you want long text to remain contained and readable in its own cell, choose Wrap.

Common Mistakes

Choosing Clip instead of Wrap. Clip can look as if the text has disappeared because the extra characters are hidden at the cell edge. Reopen Format > Wrapping and choose Wrap to display them on additional lines.
Expecting the column to get wider. Wrapping generally adds lines and affects row height; it does not expand the column to fit the whole entry on one line. If you need one-line labels, resize the column or use a shorter label instead.
Formatting only one cell by accident. If other entries remain unchanged, check the selection before applying the command. Select the whole intended range or column first, then set wrapping.
Assuming wrap inserts line breaks into the text. It is a display setting, not an edit to the cell’s contents. If you need a deliberate break at a particular point, edit the cell and insert a line break where appropriate; simply choosing Wrap will not set a custom break position.
Making every row taller to solve one problem. A broad selection can affect more cells than intended. Select only the table or column that needs wrapping, and check whether a manually fixed row height is preventing all lines from showing.

Tips

Set wrapping before polishing the layout. Apply it to the relevant data first, then adjust column widths and row heights. Changing widths afterward changes where the text breaks, so you may need to review the table again.
Use wrapping selectively. Descriptions and notes often benefit from Wrap, while short identifiers, dates, and compact numeric fields may be easier to compare on one line. A mix of wrapping settings can make a sheet clearer than applying one choice everywhere.
Use a readable width. A very narrow column can turn one sentence into a tall stack of short fragments. Widen the column enough for natural phrase breaks, then let the row expand to show the remaining lines.
Consider alignment after wrapping. Vertical alignment can affect where text sits in a taller cell. If the lines appear low or centered in a tall row, use the vertical alignment control on the toolbar to align them at the top.
Think about printing and sharing. Wrapped rows can increase the number of pages or change how a table fits on a printed page. Check print preview or the shared view after substantial layout changes, especially for reports with many long descriptions.

Troubleshooting

The text still looks cut off. First confirm that the cells are set to Wrap, not Clip, by selecting them and checking Format > Wrapping. Then inspect the row height. If it was set to a fixed size, use the row header’s right-click menu and choose Resize row > Fit to data, or drag the row boundary lower. A merged cell or unusual layout can also affect how much content is visible, so try the same setting on an unmerged test cell.

The wrapping option seems to do nothing. Check that you selected the cell containing the text rather than a neighboring blank cell. If the selected cell is empty, there is nothing visible to wrap. Also check whether the text already fits in the column; a short entry may look unchanged even though Wrap is selected. Try a longer sample in a spare cell to confirm the setting.

The row becomes too tall. The column may be too narrow, or the cell may contain a long paragraph. Widen the column, shorten the text, or use a concise summary in the cell and keep the full note elsewhere. If you only need to show part of the text, Clip may suit that specific field, but it will hide content rather than make it readable.

The change affects the wrong cells. Use Undo immediately if you just applied the formatting, then select the intended range more carefully and repeat the command. Formatting can be applied again without changing the cell values. If you are working in a shared sheet, confirm that another editor has not changed the selection or layout at the same time.

Frequently Asked Questions

Is it wrap text or warp text?
In Google Sheets, the feature is called text wrapping, so the usual instruction is “wrap text.” Warping generally means distorting text into a shape, which is not the same as displaying a long cell entry on several lines.

Can I wrap text in Google Sheets on a phone?
Yes. In the Google Sheets mobile app, select a cell or range, open the formatting controls, and look for the cell text-wrapping option. The app’s layout differs from the browser version, so the exact control placement may vary by device. The browser instructions above use Format > Wrapping > Wrap.

Will wrapping change the text or formulas in a cell?
No. Wrapping changes the display, not the cell’s stored text or formula result. You can change the wrapping setting without editing the underlying value.

Can I wrap text in an entire column?
Yes. Click the column letter to select it, then choose Format > Wrapping > Wrap. This applies the display setting to the column, including cells you fill later, and can also make rows taller where long entries appear.

How do I make text appear on a new line at a specific place?
Wrapping creates line breaks according to the available cell width. To control a break manually, edit the cell and insert a line break at the desired point; the keyboard combination can depend on your operating system and browser. Afterward, keep Wrap enabled so the rest of the content remains visible.

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.