Undo Wrap Text in Google Sheets and Fix Cell Display

To undo text wrapping in Google Sheets, select the wrapped cells and choose Format > Wrapping > Overflow. This turns off wrapping so text stays on one line and can spill into neighboring empty cells; choose Clip instead if you want text to stay on one line but remain inside its cell boundary. You only need access to the sheet and permission to edit it.

What You’ll Need

A web browser with the Google Sheets file open. These steps describe Sheets in a browser, not Microsoft Excel.
Editor access to change the cell formatting. If you can only view or comment on the file, ask its owner for edit access or make a copy if that option is available.
An idea of whether you want text to overflow into empty cells or be clipped at the cell edge. Both options turn wrapping off, but they display long text differently.

Step-by-Step

Open the spreadsheet and find the wrapped text. Locate a cell where the contents appear on multiple lines. Click it once to select it. If you are unsure which cells have wrapping applied, look for rows that are taller than neighboring rows or text displayed on several lines. Those are clues, but row height alone does not prove that wrapping is on.
Select every cell you want to change. To change one cell, leave that cell selected. For a continuous range, click the first cell and drag across the others, or click the first cell, hold Shift, and click the last cell. To select separate cells or ranges, hold Ctrl on Windows or ChromeOS while selecting them; on a Mac, hold Command. You can also click a column letter or row number to select the whole column or row.
Open the text-wrapping menu. In the menu bar, click Format, point to Wrapping, and wait for its options to appear. The menu contains Overflow, Wrap, and Clip. If you do not see the submenu, make sure you are in the Google Sheets editing interface rather than a file preview.
Choose Overflow to remove wrapping. Click Overflow. The setting applies to all selected cells. Text remains on one line and can extend visually across neighboring cells that are empty. If an adjacent cell contains data, the displayed text will not cover that data; the contents of the selected cell are not deleted or shortened.
Use Clip if overflow is not the display you want. If long text should not appear over the next empty cell, go back to Format > Wrapping and select Clip. This also keeps the text on one line, but hides the portion that does not fit within the cell’s width. The complete value remains in the cell and is visible in the formula bar when you select it.
Check the result in the sheet. Click outside the selected range or select a changed cell. Confirm that its text is no longer broken across multiple lines. If you chose Overflow, check how the value displays beside empty and populated cells. If you chose Clip, select the cell and check the formula bar if you need to confirm that the hidden portion is still present.
Adjust row height or column width if needed. Turning off wrapping does not guarantee that every row or column will take the size you prefer. If a row remains unusually tall, drag the line below its row number upward or right-click the row number and choose Resize row. To show more text, widen the column by dragging the boundary between its column letters. Resizing changes the layout, not the cell’s contents.

Common Mistakes

Choosing Clip and expecting text to spill across the row. Clip disables wrapping but hides overflow at the cell boundary. If you want the text to continue visually into empty neighboring cells, choose Overflow instead. Neither option changes the actual value stored in the cell.

Thinking hidden text has been erased. With Clip, part of a long value may not be visible in the grid. Select the cell and inspect the formula bar to see its full contents. You can also widen the column temporarily or copy the cell into a text editor to inspect the value, but avoid editing it unless you intend to change the data.

Changing only the cell you clicked. A setting applies to the current selection, not automatically to every cell in the sheet. Select the entire target range, row, or column before choosing Overflow or Clip. If just one cell looks different afterward, reselect the intended range and apply the setting again.

Confusing text wrapping with row height. A tall row may have a manually set height, or it may be tall because another cell in that row still wraps. Turning off wrapping on one cell will not necessarily shrink the row if another cell determines its height or if the height was set manually.

Using browser zoom or font size as a substitute. Zooming changes how large the whole sheet looks on your screen; it does not turn off wrapping. Changing the font can affect how much text fits, but it does not change the wrapping mode either. Use the Wrapping menu to change the actual cell setting.

Tips

Choose the display behavior based on how the sheet will be read. Overflow can make short labels or notes easy to scan when the cells beside them are empty. It can also make a sheet look crowded if long text spills across several columns. Clip gives a tidy grid for tables with adjacent data, but readers may not realize that a value continues beyond what is visible. For important long descriptions, consider widening the column or keeping wrapping on for that column.

Apply the setting to a whole column when new or existing entries in that column should use the same behavior. Click the column letter, then select Format > Wrapping > Overflow or Clip. Be aware that this changes the formatting of every cell in that column, including cells that already had a different wrapping setting. For a mixed-use column, select only the cells you want to change.

If you are formatting a large range, check a few different rows after applying the change. A neighboring cell with content can stop overflow from appearing, while an empty neighbor may let the text show across it. This difference is normal. It does not mean that the setting failed or that the text moved into the neighboring cell.

Google Sheets saves edits automatically when you are online. You do not need a separate Save command after changing wrapping. If the file is shared, remember that formatting is visible to other editors and viewers. If you only want to inspect a different layout without changing the shared sheet, make a copy first if you have permission.

Troubleshooting

The text still appears on multiple lines. Confirm that you selected the correct cell or range, then reopen Format > Wrapping and select Overflow or Clip. Make sure you did not select Wrap again. If the cell looks unchanged, check whether it contains manual line breaks: wrapping controls how text flows to fit the cell, while line breaks are part of the cell’s content. A line break entered in the value can keep text on multiple lines even when wrapping is off. Edit the cell to remove the unwanted break only if changing the content is appropriate.

The text disappears after you turn wrapping off. The value is likely clipped because Clip is selected, or because a neighboring cell contains data and prevents overflow from displaying. Select the cell and inspect the formula bar. To make more of the value visible in the grid, choose Overflow and ensure the cells to its right are empty, or widen the column. Do not clear neighboring cells unless you are certain their data is no longer needed.

The row is still too tall. Check other cells in the same row; one of them may still be wrapped. If none are, the row may have a custom height. Right-click the row number and choose Resize row, then enter a smaller height or choose the available fit-to-data option. If the row has merged cells, layout behavior can be less straightforward, so inspect the merged range and adjust its dimensions carefully.

The menu option is unavailable or nothing changes. You may have viewer or commenter access rather than editor access. Check the sharing status or ask the owner to grant editing permission. Also make sure the browser has finished loading and that you are editing the actual Google Sheets file. If you selected a chart, image, or another object instead of cells, click a cell first and repeat the steps.

You changed the wrong cells. If the change was your most recent action, use Edit > Undo or press Ctrl+Z on Windows or ChromeOS; on a Mac, press Command+Z. Then select the correct cells and apply the desired wrapping option. Undo can reverse recent sheet changes, but if other edits have occurred since, check carefully before undoing so you do not remove unrelated work.

Frequently Asked Questions

What is the difference between Overflow and Clip?
Both keep text on one line rather than wrapping it. Overflow lets text appear across neighboring empty cells; Clip hides the part that does not fit inside the cell. In either case, the full value remains stored in the original cell.

Can I undo wrapping for an entire spreadsheet?
Yes. Select the whole sheet using the blank square at the upper-left corner where the row numbers and column letters meet, then choose Format > Wrapping > Overflow or Clip. This changes the wrapping setting throughout the selected sheet, so use a narrower selection if some areas should keep wrapping.

Will turning off wrapping delete or change my text?
No. Overflow and Clip change how cell contents are displayed, not the stored value. The exception is if you separately edit the cell to remove a manual line break or alter its text.

Why can I see overflow in one row but not another?
Overflow can display across neighboring cells only when those cells do not block it. If the next cell contains a value, the text will stop at that point in the display. The neighboring value remains unchanged.

Is there a keyboard shortcut to turn off wrapping?
Google Sheets does not provide a standard dedicated keyboard shortcut for selecting Overflow or Clip. Use the Format menu, or use the wrapping control in the toolbar if it is visible. The exact toolbar layout can vary with window size.

Does this work the same way in Excel?
No. This guide uses Google Sheets menu names and behavior. Excel has its own Wrap Text control and different display rules, so use Excel’s Home tab controls when working in an Excel workbook.

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.