How to Wrap Text in Google Sheets on Desktop and Mobile

To wrap text in Google Sheets, select the cell or cells, then choose Format > Wrapping > Wrap. The text will display on multiple lines inside each cell, and the row will usually grow to show it. You can also use the Text wrapping button on the toolbar. These steps are for Google Sheets in a desktop web browser; the mobile app has a similar setting in its cell-formatting panel.

What You’ll Need

A Google account with access to the spreadsheet you want to edit.
A web browser and a sheet containing text that is being clipped, spilling into nearby cells, or difficult to read.
Edit access to the spreadsheet if you need to change its formatting. Viewers can see existing wrapping but cannot apply it.

You do not need to change the cell’s contents or add a formula. Wrapping is a display setting: it keeps the text in the same cell and shows it on additional lines as needed. The original value remains available in the formula bar when you select the cell.

Step-by-Step

Open the spreadsheet and locate the text. Go to sheets.google.com or open the file from Google Drive. Find the column or cells whose contents are hard to read. If you are working in a shared file, check that you have editing permission before changing the layout.
Select the cells to format. Click one cell to wrap only that cell. To apply wrapping to a range, click the first cell and drag across the rest. To format a whole column, click its letter at the top; click a row number to select a whole row. You can select several non-adjacent cells by holding Ctrl while clicking on Windows or ChromeOS, or Command on a Mac.
Choose the Wrap setting from the menu. With the cells selected, open Format > Wrapping > Wrap. Sheets applies the setting immediately. Longer entries should appear on multiple lines within their cells rather than extending across the row or disappearing at the cell edge.
Or use the toolbar wrapping control. Look for the Text wrapping button in the toolbar; its icon may resemble an arrow and lines, and its position can vary with window width. Click it and choose Wrap. If the control is not visible, widen the browser window or use the Format menu instead. The menu route is a reliable alternative when toolbar buttons are hidden in an overflow menu.
Check the row height. A row generally expands to accommodate wrapped content. If the last line is still hidden, move your pointer to the boundary below that row’s number and double-click to fit the row to its contents. You can also right-click the row number, choose Resize row, and select the option to fit the data or enter a custom height. A custom fixed height can prevent all the wrapped lines from being visible.
Adjust the column width if the result is awkward. Wrapping uses the available width of the column. Drag the boundary between column letters to make the column wider or narrower. A wider column usually means fewer lines; a narrower one means more. Try a modest width change before making a whole table unusually wide or forcing entries into many short lines.
Review the rest of the selected range. Check a short entry and a long one, and look at the rows above and below. Wrapping might make some rows taller than others, which is normal. If the layout looks right, continue editing; Sheets saves changes automatically when you are online.

There are three wrapping behaviors worth distinguishing. Wrap displays text on multiple lines within its cell. Overflow lets text appear over neighboring cells when those cells are empty. Clip hides the part that does not fit in the cell’s width. You can find these choices in the same Format > Wrapping menu. If your text seems to vanish, it may be clipped rather than deleted.

Common Mistakes

Selecting the wrong range: Applying Wrap to one cell does not automatically format the entire column. Select the column letter or the full range first if you want consistent formatting throughout it.
Confusing wrapping with a line break: Wrap changes how text is displayed according to the cell width. It does not insert a permanent new line into the cell’s contents. If you need a line break at a specific place, edit the cell and insert one deliberately; do not expect changing the column width to preserve a particular break.
Expecting adjacent cells to remain visible behind overflow: Overflow only displays across neighboring cells when they are empty. Content in the next cell blocks the spillover, which can make the text appear clipped. Use Wrap when you want the complete entry displayed without relying on empty cells.
Setting a row height too small: A fixed or manually reduced row height can hide lower lines even when Wrap is on. Fit the row to its data or increase its height before deciding that wrapping failed.
Using merged cells and expecting ordinary auto-sizing: Rows containing merged cells may not resize to show wrapped content in the same predictable way as ordinary cells. If a merged heading is cut off, increase the row height manually or reconsider whether merging is needed.
Assuming the text itself changed: Wrapping is formatting, not editing. It neither shortens a value nor removes words. If the cell’s content is actually incomplete, inspect it in the formula bar and check the source data separately.

Tips

Set a useful width before wrapping a large table. Choose a readable column width, then apply Wrap to the relevant range. This avoids making every row taller than necessary because a column is extremely narrow.
Use consistent formatting for a whole field. If a notes column should always show full entries, select the column and wrap it once. This also applies to cells you fill later, as long as the formatting remains on the column.
Keep row heights practical. Long descriptions can make a sheet difficult to scan when every row expands dramatically. Consider widening the column, shortening repeated labels, or keeping detailed notes on a separate tab rather than making the table excessively tall.
Use the menu to confirm the current behavior. If you are unsure whether a cell is set to Wrap, select it and open Format > Wrapping. Choosing Wrap again is safe; it simply applies that display setting.
Remember that screen size affects the view. A sheet may look crowded in a narrow browser window even when the cell formatting is correct. Widen the window, zoom out in the browser, or scroll horizontally to inspect the layout before changing many column widths.
For mobile editing, use the Sheets app. Select the cell or range, tap the formatting icon, open the Cell tab, and turn on Wrap text. Labels and controls can vary slightly by device or app version. The desktop browser menu path remains Format > Wrapping > Wrap.

Troubleshooting

The text still appears cut off. Select the cell and confirm that Format > Wrapping > Wrap is active. Then check the row height. If a row is too short, double-click its lower boundary or use Resize row to fit the data. Also check whether the text is in a merged cell, which can need a manual height adjustment.

Text does not move onto extra lines. Confirm that you selected the correct cell and that Wrap, rather than Clip or Overflow, is selected. Then make sure the column is not so wide that the text fits on one line already. If a value contains an explicit line break, that break may also affect where lines appear.

The text spills into the next cell. That is the Overflow behavior, not Wrap. Select the affected cells and choose Format > Wrapping > Wrap. If you expected overflow to work, check whether the adjacent cells contain values, spaces, or formulas; any content there can block the spillover.

Only some cells changed. Check the selection before applying formatting. If you selected a small range by mistake, select the intended column or full data range and apply Wrap again. Formatting a column can also affect headings or other cells in that column, so inspect the whole column afterward.

The row becomes too tall or the sheet is hard to scan. Widen the column a little, reduce unnecessary text, or use a more compact layout. You can also select a row and set a custom height, but a height that is too small will hide wrapped lines. Balance readability against the number of rows visible at once.

The setting appears not to save. Check that you are online and that you have edit access. Look for a permission notice or a connection warning, and wait for Sheets to finish saving before closing the tab. If the spreadsheet is view-only, ask its owner for editing access or request that they apply the formatting.

Frequently Asked Questions

Does wrapping text change the contents of a cell?
No. It changes how the value is displayed in the grid, not the value itself. The complete text remains in the cell and can be viewed in the formula bar when you select it.

How do I wrap text in an entire Google Sheets column?
Click the column letter to select the full column, then choose Format > Wrapping > Wrap. You can also select only the data range if you do not want to change the heading or other cells in that column.

Can I wrap text in Google Sheets on a phone?
Yes. In the Google Sheets app, select the cell or cells, tap the formatting icon, go to the Cell tab, and enable Wrap text. The exact appearance of the controls can vary between Android and iOS versions.

Why does wrapped text not show every line?
The row may have a fixed height that is too small, or the cell may be merged. Fit the row to its data or increase its height manually. In a merged cell, manual resizing is often needed.

What is the difference between Wrap, Clip, and Overflow?
Wrap uses extra lines inside the cell. Clip hides text that exceeds the cell’s display area. Overflow displays text over adjacent empty cells. These options affect presentation, not the stored value.

Does Google Sheets have a keyboard shortcut for wrapping?
There is no standard dedicated keyboard shortcut for the Wrap setting in Google Sheets. Use the toolbar’s Text wrapping control or the Format > Wrapping > Wrap menu path instead.

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.