How to Wrap Text in Google Sheets: A Quick Tutorial

To wrap text in Google Sheets, select the cell or range, 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. You only need a Google account and a spreadsheet open in a web browser; wrapping changes how content is displayed, not the text itself.

What You’ll Need

A Google account with access to the spreadsheet you want to edit.
A current web browser and an internet connection.
Edit access to the sheet. If you only have view access, ask the owner to grant editing permission or make an editable copy, if permitted.

You do not need to install an add-on or change a spreadsheet-wide setting. Wrapping can be applied to one cell, a selected range, a whole column, or several columns. If you are working in the Google Sheets mobile app, the controls may be arranged differently; the instructions below describe Sheets in a desktop web browser.

Step-by-Step

Open the spreadsheet and locate the content. Open Google Sheets in your browser and select the spreadsheet. Find the cells whose text is running into nearby cells, getting cut off, or making the column inconveniently wide. Wrapping is useful for long labels, notes, addresses, descriptions, and headings that need to remain visible in a compact table.
Select the cells you want to change. Click a cell to wrap just that cell. To select a continuous range, click the first cell and drag to the last, or click the first cell and hold Shift while selecting the last. To apply wrapping to a complete column, click its letter at the top of the sheet. To select several separate ranges, hold Ctrl on Windows or Command on Mac while selecting each range, if your browser and selection allow it.
Open the text-wrapping controls. From the menu bar, choose Format > Wrapping. The submenu offers three display choices: Overflow, Wrap, and Clip. Choose Wrap. This is the most dependable route if you are unsure which toolbar icon represents text wrapping or if the toolbar has been customized or narrowed.
Alternatively, use the toolbar button. With the cells still selected, find the Text wrapping button in the toolbar. Its icon represents text arranged with a wrapping arrow; hovering over toolbar buttons can show their names. Click the button and choose Wrap from the options. Both this route and Format > Wrapping apply the same text display setting.
Check the row height and the result. Look at the selected rows after applying Wrap. Sheets generally increases row height to display the wrapped lines. If the whole cell content is visible, the change is complete. If only some lines appear, the row may have a fixed height or the cell may be merged; use the troubleshooting guidance below to adjust it.
Apply wrapping to other cells when needed. Repeat the selection and wrapping steps for other ranges, or select a whole column before choosing Wrap if you want new and existing entries in that column to use the same display behavior. Applying it to a column can make a table consistent, but check whether the taller rows make the sheet harder to scan.
Adjust the column width if the layout still feels awkward. Wrapping does not choose an ideal width for you. Drag the boundary between column letters to make a column narrower or wider. A slightly wider column may reduce excessive line breaks; a narrower one may save horizontal space but increase row heights. Review the complete table after changing widths because wrapping can alter several rows at once.
Save or share as usual. Google Sheets saves changes automatically when you are online, and formatting is part of the spreadsheet. If collaborators need to see the result, confirm that you have changed the intended tab and range. Use browser zoom or scroll to inspect the sheet, rather than changing cell contents to compensate for a display issue.

For a single manual line break inside a cell, wrapping alone is not the right tool: it lets Sheets decide where lines break based on the cell width. Edit the cell, place the cursor where the break should go, and use Alt+Enter on Windows or Option+Enter on Mac. A manual break stays at that point even if the column width changes, so use it only when you want to control the line layout yourself.

Common Mistakes

Choosing Clip when you mean Wrap. These settings behave differently. Wrap puts the text on additional lines within the cell. Clip hides the part that does not fit in the cell’s visible area. Overflow lets text appear across empty neighboring cells, but nearby content can cover that overflow. If text must remain visible within its own cell, choose Wrap.

Expecting the column to expand. Wrapping usually makes the row taller, not the column wider. That is deliberate: it keeps the column within its current width and uses more vertical space. If you wanted to reveal a long entry on one line, widen the column or use overflow where appropriate instead.

Assuming hidden text has been erased. Clip and some crowded layouts can make content look missing even though it remains in the cell. Click the cell and inspect the formula bar above the grid to see the full entry. Do not retype it until you have confirmed whether the content is actually absent.

Selecting only part of the intended range. A common source of inconsistent formatting is applying Wrap to a few cells while leaving the rest of the column on Overflow or Clip. Check the highlighted selection before using the menu, especially when the sheet has frozen rows, hidden columns, or multiple tabs.

Using manual breaks as a substitute for normal wrapping. A cell can contain deliberate line breaks as well as wrapping. If you insert breaks in every entry, changing the column width may leave awkward short lines or extra-tall rows. Start with Wrap and add manual breaks only for a specific presentation need.

Trying to solve layout problems by merging many cells. Merged cells can make tables harder to sort and edit, and their row heights may not adjust to wrapped content as expected. For a data table, keep each value in its own cell where possible. Use a manual row-height adjustment if a merged heading genuinely needs multiple lines.

Tips

Use wrapping selectively. It is often helpful for description or notes columns, while short numeric columns are easier to compare when each row remains compact. If a whole table becomes very tall, wrap only the columns that need it instead of applying the setting to every cell.

Consider setting the column width before fine-tuning row heights. Width determines where Sheets breaks the lines, so resizing a column later can change how many lines each entry needs. A practical sequence is to set the column width, apply Wrap, review the tallest rows, and then adjust row heights only where necessary.

You can resize a row by dragging the boundary below its row number. To fit a row to its contents, right-click the row number, choose Resize row, and choose the fit-to-data option if it is available in the dialog. You can also double-click the boundary below a row number to fit that row to its data. Names and exact dialog wording can vary slightly as Google updates the interface.

For more predictable formatting, use the same wrapping choice across cells that serve the same purpose. For example, wrap all entries in a long-description column, but leave a date column unwrapped. Consistency makes it easier to scan and helps readers understand which rows have extra detail.

Remember that text wrapping is a display format. It does not shorten a value, change a number, or add characters to the cell. If the content itself needs editing, edit the cell separately. You can remove wrapping later by selecting the cells and choosing Format > Wrapping > Overflow or another appropriate option.

These instructions are for Google Sheets in a browser. Excel has a separate Wrap Text control, commonly found on the Home tab, and its menu layout and behavior are not identical. If you are following a Google Sheets guide, use the Sheets menus rather than looking for an Excel ribbon command.

Troubleshooting

The text still appears on one line. Confirm that the cells are selected and that the setting is Wrap, not Overflow or Clip. Open Format > Wrapping again to check. If the cell is wide enough to hold all its text on one line, wrapping is active but no visible line break is needed. Narrow the column temporarily to check the effect.

The row does not get taller or some lines are cut off. A manually set row height may be limiting the display. Drag the bottom edge of the row downward, or right-click its row number and use Resize row to fit it to the data. Merged cells can prevent automatic row sizing from behaving as expected, so increase the height manually if the cell is merged.

The text seems to spill into the next cell. The selected cell may still be set to Overflow, or the neighboring cells may be empty and allowing overflow to show. Select the source cell and choose Wrap. If the neighboring cell contains content, overflow will not display over it, but the source text is still in its own cell.

Only some cells change. Recheck your selection and make sure you are on the intended sheet tab. If you selected a whole column, verify the column letter; if you selected a range, look for gaps or missed rows. Then apply Wrap again to the complete intended range.

The menu or toolbar is unavailable. Make sure you have edit permission and that the sheet is not protected in a way that prevents formatting. If the toolbar is too narrow, a button may be hidden in an overflow menu; use Format > Wrapping instead. Reloading the browser can help if the interface is temporarily unresponsive, but check that pending edits have finished saving first.

Frequently Asked Questions

Does wrapping change the text in a cell?
No. Wrap changes how the existing content is displayed. It does not delete, shorten, or rewrite the value. Click the cell to inspect its full content in the formula bar.

Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. This affects the selected column, including cells that are currently blank, so consider whether taller rows are useful for that part of the sheet.

Why is the row much taller after I turn on Wrap?
The cell has enough text, or the column is narrow enough, to require several display lines. Sheets increases row height so those lines can be shown. Widening the column may reduce the number of lines and the row height.

Can I choose exactly where a line breaks?
Yes. Edit the cell and insert a manual line break with Alt+Enter on Windows or Option+Enter on Mac. Normal wrapping breaks lines according to the available cell width; a manual break gives you a specific break point.

Will the wrapping appear for other people who open the sheet?
Yes. Wrapping is saved as cell formatting, so collaborators with access see the same setting. Their screen size or zoom may change how the sheet fits on screen, but it does not remove the formatting.

What is the difference between Wrap, Clip, and Overflow?
Wrap shows the text on multiple lines inside the cell. Clip keeps it on one line and hides the part that does not fit. Overflow lets the text extend into adjacent empty cells. Choose based on whether you want a taller row, a compact cell, or a visible one-line entry.

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.