How to Remove Wrap Text in Google Sheets

To remove wrap text in Google Sheets, select the cells, then choose Format > Wrapping > Overflow. This stops text from breaking onto extra lines within a cell. Choose Clip instead if you want the text to stay on one line but not spill into neighboring cells. You can make the change to one cell, a range, whole rows or columns, or the entire sheet in a browser.

What You’ll Need

A Google account with access to the spreadsheet. You need Editor access to change cell formatting; Viewers cannot change it.
The spreadsheet open in Google Sheets in a web browser. The menu names below describe the desktop browser interface.
An idea of whether you want long text to overflow into empty cells or be clipped at the cell edge. Both options turn off wrapping, but they display text differently.

Step-by-Step

Open the spreadsheet and find the wrapped cells. Go to Google Sheets in your browser and open the file. If you are unsure which cells are wrapped, click one of them and look at the row: wrapped text commonly appears on multiple lines, making the row taller. A tall row alone does not prove wrapping is on, since someone may have set its height manually.
Select the cells you want to change. Click a single cell to change only that cell. To change a continuous range, click the first cell and drag across the range, 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. For non-adjacent selections, hold Ctrl on Windows or Chromebook, or Command on Mac, while selecting additional cells or ranges.
Open the wrapping options. In the top menu, click Format, point to Wrapping, and choose one of the available display modes. Google Sheets offers Overflow, Wrap, and Clip. The current selection determines which cells the change affects; selecting the wrong range is a common reason the result seems incomplete.
Choose Overflow to turn off wrapping and let text extend. Click Overflow when you want text to remain on a single line and show in neighboring cells if those cells are empty. This is usually the closest match to “turn off wrap text.” The text is still stored in its original cell; it only appears to extend across the blank cells beside it.
Choose Clip if text should stay within the cell’s visible area. In the same Format > Wrapping menu, select Clip. The content remains in the cell, but any part that cannot fit in the cell’s width is hidden from view. Clip can be useful in a compact table where you do not want long entries visibly running across adjacent columns.
Use the toolbar as an alternative. With the target cells selected, click the Text wrapping button in the toolbar and choose Overflow or Clip. If you are unsure which button it is, hover over toolbar icons to see their labels. The toolbar and Format menu change the same wrapping setting, so you do not need to use both.
Apply the setting to a larger area when needed. To change a whole sheet, click the blank square at the top-left corner of the grid, above row 1 and left of column A, then choose Format > Wrapping > Overflow or Clip. You can also select specific columns or rows by clicking their headers. Check the selection before applying the setting so you do not unintentionally change formatting elsewhere.
Check the result and adjust sizing separately if necessary. Look at the selected cells and nearby columns to confirm the text now displays as intended. Turning off wrapping does not always undo a row height that was manually increased earlier. If a row is still unusually tall, right-click its row number, choose Resize row, then select Fit to data, or enter a suitable height. Widening a column is another option if you need more of a long entry visible.

Google Sheets saves formatting changes automatically. If the cells are shared with others, they may see the updated display as soon as the change is saved. The cell values themselves are not deleted or rewritten when you switch between wrapping modes.

Common Mistakes

Choosing Clip when you expect the full text to show. Clip hides the part that does not fit in the cell. It does not delete that text, but you may need to click the cell or read its contents in the formula bar to see it. Choose Overflow if you want the text to appear across adjacent blank cells.
Expecting Overflow to cover neighboring content. Overflow only displays into cells that are empty. If the next cell contains a value, the text cannot visibly run through it. The original content remains intact, but the displayed text may look cut off at that point.
Changing only one cell by mistake. A setting applied to the active cell will not automatically change the rest of the column or sheet. Select the complete range, the relevant row or column headers, or the whole-sheet selector before choosing a wrapping mode.
Assuming a tall row means wrapping is still on. A row may keep a manually set height after wrapping is turned off. Check the wrapping menu for the selected cells, then resize the row if the height is still affecting the layout.
Confusing text wrapping with text rotation or alignment. Wrapping controls whether text breaks onto multiple lines. Horizontal alignment, vertical alignment, and rotation are separate formatting settings and will not turn wrapping off.
Trying to fix the display by deleting or editing the text. Usually, no content change is needed. Change the wrapping mode first. Deleting characters or adding spaces can alter the actual cell value and may affect formulas or reports that use it.

Tips

Pick the mode based on what the sheet is for. Overflow is handy for notes or descriptions when adjacent cells are empty. Clip keeps a dense table visually tidy. Wrap is still useful for cells where readers need to see every word without widening the column, so you do not have to disable it everywhere.
Make a deliberate choice about column width. If a long label should be readable at a glance, widening its column may be clearer than relying on Overflow. Consider the effect on the rest of the sheet, especially when columns have carefully sized data or headings.
Check neighboring cells before choosing Overflow. A value in the next cell blocks the visible spillover. If the text seems clipped even though Overflow is selected, the neighbor may not be empty; it could contain a space, formula, or other value. Do not remove neighboring content unless you know it is safe to do so.
Keep formatting consistent across similar data. For a table with many rows, select the relevant column or data range and apply one mode to all of it. This avoids a mix of wrapped and unwrapped entries that can make the sheet harder to scan.
Remember that formatting can be copied. Pasting cells or using the paint format tool can bring wrapping settings along with other formatting. If new or pasted cells wrap unexpectedly, select them and set the desired mode again.
Use a copy if you are unsure about a large change. Changing wrapping does not alter cell values, but selecting the whole sheet changes formatting broadly. For a complex shared spreadsheet, you can make a copy before applying a large-scale layout change.

Troubleshooting

The text still appears on several lines. Select one of the affected cells and open Format > Wrapping to see the available modes. Confirm that Overflow or Clip is being applied to the cell, not just to a nearby cell. If several cells are involved, select the full range and set the mode again. Also check whether the content contains an inserted line break; wrapping controls automatic line breaks, but a line break inside the cell’s text can still put text on another line.

The text is cut off after choosing Overflow. Look at the cells immediately to the right. Overflow is visible only across empty cells, so another value or formula can stop the display. You can widen the column, use Clip if a neat edge is more important than seeing the full text, or move the content in the neighboring cell only if doing so is appropriate. The text has not been removed just because it is not all visible.

The row remains tall after wrapping is turned off. The row height may have been manually set or may not have adjusted to the new display. Right-click the row number and choose Resize row, then use Fit to data or set a smaller height. If several rows need adjustment, select their row numbers first and use the resize option for the selection. Be aware that a very short fixed row can make the cell’s contents harder to inspect.

The menu option is unavailable or the change will not stick. Check whether you have Editor access; view-only access does not let you change formatting. A protected sheet or range may also restrict changes, in which case you may need to ask the owner or an authorized editor to update the protection or make the change. If you have edit access but the page has not updated, wait briefly for the connection to recover, then refresh the browser and check the cells again. Avoid repeatedly making the same change while the connection is unstable.

The change affects only some of the cells. Recheck the selection before applying the command. Hidden rows, filtered data, merged cells, or a range that starts or ends in the wrong place can make the visible result confusing. Select the intended columns or the whole sheet, apply the mode, and inspect a few cells at different points in the range. If the file is being edited by others, another editor may also change formatting after you do.

You are using Excel rather than Google Sheets. The Google Sheets menu path does not apply in Excel. In Excel for Microsoft 365 on Windows, select the cells and use Home > Alignment > Wrap Text to toggle wrapping. The Excel interface differs from Google Sheets, so look for its Wrap Text control rather than the Sheets Overflow and Clip choices.

Frequently Asked Questions

Does removing wrap text delete any of my cell content?
No. Overflow and Clip change how the cell is displayed, not the value stored in it. With Clip, some characters may be hidden from view, but they remain in the cell and can still be selected or edited.

Should I choose Overflow or Clip?
Choose Overflow if you want text to show beyond the cell when the neighboring cells are empty. Choose Clip if you want it restricted to the cell’s visible width. Both stop automatic wrapping onto multiple lines.

Can I remove wrapping from an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Overflow or Clip. If you only want to change part of the column, select that range instead.

Can I remove wrapping from the whole spreadsheet at once?
Yes. Click the blank square above row 1 and to the left of column A to select the grid, then choose the wrapping mode. This changes formatting broadly, so use a specific range or column if other parts of the sheet should keep their current layout.

Why does the text still look hidden after I turn wrapping off?
The cell may be set to Clip, the next cell may contain data that blocks Overflow, or the column may simply be too narrow. Check the selected mode and neighboring cells, then widen the column if you need more text visible.

Will new rows also have wrapping turned off?
Not necessarily. New or pasted cells can inherit formatting from nearby cells or from the source you copied. Check the wrapping mode in new rows and apply Overflow or Clip to them if needed.

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.