How to Show All Text in Google Sheets (Wrap, Resize, or Overflow)

To show all the text in a Google Sheets cell, select the cell, then go to Format > Wrapping > Wrap. The text breaks onto new lines inside the cell, and the row grows taller to fit it. You can also widen the column, let the text overflow into empty cells, or simply read the full contents in the formula bar.

Why Google Sheets cuts off text

Every cell uses one of three text wrapping settings:

• Overflow (the default): long text spills into the next cell to the right, but only if that cell is empty. As soon as the next cell has anything in it, your text looks cut off.
• Wrap: text breaks onto extra lines within the cell, and the row height increases so all of it is visible.
• Clip: text is cut off at the cell border no matter what is next to it.

Nothing is ever deleted. The full text is still in the cell, even when you can’t see it.

Method 1: Wrap text (best for most sheets)

1. Select the cells. Click a column letter to select a whole column, or click the box at the top-left corner of the sheet to select everything.
2. Go to Format > Wrapping and choose Wrap.

You can also use the Text wrapping button on the toolbar (the icon with a bent arrow) and pick the middle option. If the toolbar is narrow, the button may be hidden under the three-dot More menu.

Method 2: Resize the column or row to fit

If you prefer each entry on one line, make the column wide enough:

1. Move the pointer to the right edge of the column letter until it turns into a double arrow.
2. Double-click. The column resizes to fit its longest entry.

Or right-click the column letter, choose Resize column, and select Fit to data. See our full guides to autofitting in Google Sheets and adjusting column width.

Wrapped text can still look cut off if someone set a fixed row height. Right-click the row number, choose Resize row, and select Fit to data to fix it. More detail is in our guide on setting row height in Google Sheets.

Method 3: Let text overflow into empty cells

For titles or notes at the top of a sheet, Overflow often looks best. Select the cell, go to Format > Wrapping > Overflow, and make sure the cells to the right are empty. Even a space in the neighboring cell will block the overflow.

Method 4: Read it in the formula bar

Click any cell, and its full contents appear in the formula bar above the grid. For long text, drag the bottom edge of the formula bar down, or select the small arrow at its right end, to make it taller. This lets you read or edit the whole entry without changing the layout of the sheet.

Add your own line breaks inside a cell

Wrapping breaks text wherever it runs out of space. To choose where a new line starts, double-click the cell to edit it, place the cursor, and press Ctrl + Enter on Windows or ChromeOS, or ⌘ + Enter on a Mac. Pressing Enter alone just moves to the next cell.

Show all text in the Google Sheets mobile app

1. Open the sheet in the Google Sheets app and tap the cell or column.
2. Tap the Format icon (the letter A with lines).
3. Open the Cell tab and turn on Wrap text.

Tips

• Apply wrapping to entire columns before you paste in data, so new rows use it automatically.
• Very long paragraphs make rows tall and hard to scan. Consider a wider column plus wrapping, or move long notes to a separate column at the end of the sheet.
• Use Clip on purpose for columns like URLs or IDs, where you don’t need to see every character.

Frequently asked questions

Why does my text disappear when I type in the next cell?

The first cell is set to Overflow. Once the neighbor has content, the overflow stops. Switch the first cell to Wrap.

Can I make wrapping the default for new sheets?

Not directly. Select all cells in a new sheet (Ctrl + A or ⌘ + A) and apply Wrap once, or start new sheets from a copy that already has it.

Does wrapping change my data?

No. It only changes how the text is displayed. Formulas, sorting, and filters work the same.