How to Wrap Text in Google Sheets on a PC: A Guide

To wrap text in Google Sheets on a PC, select the cell or cells, then choose Format > Wrapping > Wrap. The text will appear on multiple lines inside each cell instead of running across the sheet or being cut off. You can do this in Google Sheets in a web browser; the setting changes how the cell is displayed, not the text itself.

What You’ll Need

A PC with a web browser and access to Google Sheets.
A spreadsheet containing the text you want to display. If it is not already in Sheets, open or import the spreadsheet first.
Permission to edit the relevant cells. If you only have view access, ask the file owner for editing permission.

Step-by-Step

Open the spreadsheet. Go to Google Sheets in your browser and open the file that contains the text. Wait for the sheet to load and check that you are on the correct tab at the bottom. Wrapping applies to cells on the active sheet; if your data is on another tab, select that tab first.
Select the cells to format. Click one cell to wrap just that cell. To format a range, click the first cell and drag across the cells you want, or click the first cell, hold Shift, and click the last cell in the range. You can select a whole column by clicking its letter at the top, or select a whole row by clicking its number on the left. To select the entire sheet, click the blank square at the top-left corner between the row numbers and column letters. Select only what needs wrapping when possible, so unrelated cells are not changed.
Open the wrapping options. In the menu bar at the top of the sheet, click Format. Point to or open Wrapping in the menu. The available choices are Overflow, Wrap, and Clip. These options determine how text that is wider than its cell is shown; they do not delete or rewrite the cell contents.
Choose Wrap. Click Wrap. The selected cells should show long entries on multiple lines. The column width generally stays the same, while row height expands to make room for the wrapped lines. If a cell already fits on one line, you may not see a visible change, even though the Wrap setting has been applied.
Check the result and adjust the view. Look at the longest entries in the selected range. If a row has expanded, its text should be readable within the cell boundaries. If the text still looks cramped, widen the column slightly by dragging the divider between its letter headings. If the column is already wide enough, you can leave it as it is; wrapping does not require changing column width.
Repeat for other ranges as needed. If another section or tab needs the same treatment, select that range and repeat Format > Wrapping > Wrap. Formatting one range does not automatically apply the setting to every cell in the spreadsheet. To apply it throughout a sheet, select the whole sheet before choosing Wrap.

Google Sheets saves changes automatically as you work, so there is no separate Save command for this formatting. If you apply Wrap to the wrong cells, use Ctrl+Z on a Windows PC to undo the last action, or choose Edit > Undo. The equivalent shortcut on a Mac is Command+Z, though this guide’s menu instructions are for Sheets in a PC browser.

Common Mistakes

Choosing Clip or Overflow instead of Wrap. Clip hides the part that does not fit in the cell. Overflow can let text appear across empty cells next to it, but nearby content can stop that display. Neither option creates the stacked lines you get with Wrap. Reopen Format > Wrapping and confirm that Wrap is selected.
Formatting the wrong selection. If only one cell is active, only that cell changes. If you select a whole column by mistake, every cell in it may receive the setting. Check the highlighted range before using the menu, and undo promptly if the formatting spread too far.
Expecting the column to grow automatically. Wrap normally keeps the column width and adds height to the row. If you want fewer lines, widen the column; if you want a narrow column, keep it narrow and allow the row to become taller.
Assuming hidden text was deleted. When text is clipped or covered by neighboring content, the full entry may still be stored in the cell. Click the cell and inspect the formula bar above the grid to see its contents. Applying Wrap changes display, not the underlying value.
Expecting a whole spreadsheet to change after formatting a few cells. The wrapping setting is attached to the selected cells. Select additional ranges or the entire sheet if you need a broader change, and remember that other tabs are separate sheets.

Tips

Use wrapping for readability, not to repair the text. It is useful for descriptions, notes, addresses, instructions, and headings that are too long for a single line. It will not correct spelling, add missing spaces, or split a string at a specific character.
Keep column widths consistent for tables. If several columns contain similar types of information, a consistent width makes the sheet easier to scan. Wrapping lets longer descriptions take extra row height without making one column exceptionally wide.
Try a small width adjustment before making a row very tall. A modestly wider column may reduce a long entry from many lines to two or three. Drag the boundary between column letters to change width; this affects the column for all its rows, so check how the other cells look afterward.
Use the formula bar to read a long entry quickly. Select the cell and look above the grid. This can help you inspect the complete value without widening the column or scrolling through a tall row.
Check headings and filters after changing layout. Taller rows can change how much of the sheet is visible at once. If the header row contains long labels, wrapping can make those labels clearer, but a very tall header may take up useful screen space.
Remember that cell alignment is separate. Wrapping controls line breaks and visibility. If you also want the text positioned at the top or center of a tall cell, use the vertical alignment control in the toolbar. Changing alignment does not turn wrapping on by itself.

Troubleshooting

The text still appears on one line. First check whether the entry is long enough to exceed the cell width. If it fits, wrapping has no visible effect. Make the column narrower temporarily to verify the display, or select a cell with a longer entry. Then check Format > Wrapping and ensure Wrap is selected.

The row does not show all the wrapped lines. Check whether the row height has been set manually. Right-click the row number and choose Resize row, then choose Fit to data if that option is available. You can also drag the lower edge of the row number downward to increase its height. If the row contains merged cells, automatic row sizing may not behave as expected; try unmerging the cells or set the row height manually.

Text is hidden behind another cell or seems cut off. Confirm that the selected cell is set to Wrap rather than Clip or Overflow. Also check that the row is tall enough and that the text color is visible against the cell background. Select the cell to inspect the full value in the formula bar; if it is incomplete there too, the stored text itself may need correction.

The menu option is unavailable or nothing changes. You may have view-only access, or the sheet may be protected. Check whether you can edit another cell; if not, request access from the owner. If you can edit but the formatting does not appear to update, select the cells again and reapply Wrap, then wait briefly for Sheets to finish saving. Reloading the browser tab can help with a display issue, but first make sure any other edits have finished syncing.

Only some cells in a range look different. Individual cells may already have different wrapping settings, or some may not contain enough text to show a difference. Select the entire intended range again and choose Wrap once more. Then review the longest entries and adjust row height or column width where necessary.

Frequently Asked Questions

Does wrapping change the text in a cell?
No. It changes how the existing text is displayed. The content remains in the cell, and you can still edit or copy it normally.

Will wrapping make the column wider?
Usually not. Wrap keeps the column width and increases row height as needed. Change the column width separately by dragging the divider between column headings.

Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. This applies the display setting to cells in that column, including cells you fill later.

Can I wrap text in several non-adjacent cells?
You can format separate ranges one at a time. Select a range, apply Wrap, then repeat for the other range. If the cells are scattered, avoid applying formatting to a large area unless you want the blank and unrelated cells included too.

How do I stop wrapping?
Select the relevant cells and choose Format > Wrapping > Overflow or Clip. Overflow displays text in neighboring empty cells when possible; Clip keeps it within the cell boundary. Pick the display you prefer.

Is the process different in Excel?
Yes. This guide uses Google Sheets in a browser, where the menu path is Format > Wrapping > Wrap. In Excel for Microsoft 365 on Windows, select the cells and use Home > Wrap Text on the ribbon.

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.