Wrap Text in Excel and Google Sheets: Step-by-Step

To wrap text, select the cell or range, then turn on wrapping: in Excel for Microsoft 365 on Windows, choose Home > Wrap Text; in Google Sheets, choose Format > Wrapping > Wrap. The cell keeps its column width while its contents display on multiple lines, making long labels and notes easier to read. Have your spreadsheet open and select the cells you want to change before you begin.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows, or a spreadsheet open in Google Sheets in a web browser.
Permission to edit the cells. In a protected workbook or view-only Google Sheet, you may need the owner to grant editing access.
A little room to check the row height after wrapping. Wrapped content usually makes rows taller, which can change the visible layout of nearby data.

Step-by-Step

Choose the spreadsheet app and locate the text. Open the worksheet or Google Sheet, then find the cells containing long text, such as column headings, addresses, descriptions, or notes. Wrapping is a formatting change: it does not alter the cell’s underlying text or split it into separate cells. If the sheet has many columns, zoom out or scroll horizontally to locate the right area.
Select the cells to format. Click one cell to wrap only that cell. To format several neighboring cells, drag across them, or click the first cell and Shift-click the last. To select a whole column, click its letter at the top; to select a whole row, click its number. You can also select a range by dragging over its cells. Limit the selection when practical, because wrapping an entire sheet can increase row heights and make scanning more difficult.
Turn on wrapping in Excel for Windows. With the cells selected, open the Home tab and click Wrap Text in the Alignment group. Excel displays the cell contents on additional lines when they do not fit the column width. If the button is already active, clicking it turns wrapping off. Check the selected cells after clicking: alignment controls can be crowded on a narrow ribbon, so confirm you clicked Wrap Text rather than a nearby horizontal or vertical alignment option.
Turn on wrapping in Google Sheets. Keep the cells selected, then choose Format > Wrapping > Wrap. Alternatively, use the text-wrapping control in the toolbar if it is visible, and choose Wrap from its options. Google Sheets also offers Overflow and Clip. Overflow lets text extend into an empty cell beside it, while Clip hides the part that does not fit. Choose Wrap when you want the full cell contents to appear on multiple lines within the cell’s column.
Let the row height show the extra lines. After wrapping, look for the row to expand so each line is visible. If it does not, adjust the row height: in Excel, double-click the lower edge of the row number, or use Home > Format > AutoFit Row Height. In Google Sheets, right-click the row number and choose Resize row, then select Fit to data where that option appears. You can also drag the row boundary downward to set a height manually. AutoFit or Fit to data is usually the best first choice.
Keep the column width readable. Wrapping uses the current column width, so a very narrow column produces many short lines and a very tall row. Drag the column boundary to widen it slightly if the text becomes difficult to scan. To fit a column to its contents, double-click its right boundary in Excel or choose Resize column and Fit to data in Google Sheets. Autofitting a column to a long paragraph can make it extremely wide, so for notes it is often better to set a moderate width and allow the row to grow.
Check vertical alignment and neighboring rows. Wrapped text may sit at the bottom or middle of a tall cell depending on its vertical alignment. In Excel, use Home > Alignment and select Top Align if you want the first line to start at the top. In Google Sheets, use the vertical-align control in the toolbar and choose Top. Review adjacent rows, borders, and frozen sections afterward. A taller wrapped row is normal, but it can make a table look uneven if only some cells in that row contain multiple lines.
Test the result with a longer entry. Click a wrapped cell and confirm that the visible lines contain the full text. If you are formatting a template, try a realistic long entry rather than relying on a short sample. Wrapping is controlled by the cell’s format, so text entered later into the same formatted cell should wrap too. If new data is pasted into cells outside the formatted range, select those cells and apply wrapping separately.

Common Mistakes

Confusing wrapping with resizing the column. Wrap Text does not automatically make a column wider. It keeps the width and shows extra lines by increasing row height. If you wanted one long line, widen the column instead.

Selecting the wrong range. Applying the setting to a heading but not to its data cells, or to only one cell in a table, can make the formatting look inconsistent. Check the highlighted selection before using the command. When selecting a whole column, remember that wrapping may affect blank cells too, especially when they later receive data.

Assuming text has disappeared. A row with a fixed or insufficient height can hide some wrapped lines. The contents may still be intact. Use AutoFit or increase the row height before editing or deleting text. Also make sure the text color is not blending into the cell background.

Using manual line breaks as a substitute for wrapping. A line break forces text onto a new line at a particular point, even if the column width changes. That can be useful for a deliberate label layout, but it is less flexible for ordinary paragraphs. Use wrapping for natural line breaks that adapt to the available width.

Expecting wrapped content to spill into neighboring cells. Wrapping keeps text within its own cell. In Sheets, Overflow is a separate display option and works only when the adjacent cell is empty. In Excel, unwrapped text can appear across empty cells, but wrapping it keeps it within the original cell.

Tips

Format before entering repeated content. Apply wrapping to the whole data-entry range in advance if users will enter descriptions or notes later. This avoids having to fix each new row individually.
Use a sensible width-height balance. For a table, modestly widening the description column can make a big difference without making the sheet unwieldy. Aim for readable phrases per line rather than a single very narrow column of words.
Pair wrapping with top alignment. In rows of different heights, top-aligned text is easier to compare because every cell begins at the same vertical position. This is especially helpful in tables containing both short labels and long descriptions.
Consider a manual line break only when placement matters. For example, a compact heading may look better with a break between two phrases. In Excel for Windows, press Alt+Enter while editing a cell to insert a line break. Wrapping can still be enabled as well, so the text adjusts if the column width changes.
Use Format Painter or copy formatting for consistency. When you need the same appearance in another area, copy a correctly wrapped cell and use Paste Special to paste formatting, or use Excel’s Format Painter. In Google Sheets, paste formatting with Paste special > Format only. Check that the destination range is appropriate so you do not overwrite its values.
Remember that wrapping is a display choice. It does not change the value, remove spaces, or divide the text among cells. You can still edit, search, copy, and use the cell contents as before. The formula bar in Excel or the cell edit area in Sheets may show the contents on one line even when the grid displays multiple lines.

Troubleshooting

The text still looks cut off: First select the row and run AutoFit Row Height in Excel or Fit to data in Google Sheets. If the row has a manually specified height, increase it by dragging its lower boundary. Check whether the text is actually in the selected cell, and whether the row is hidden or filtered. In Excel, merged cells are a special case: AutoFit may not calculate the required height reliably for a merged range. Unmerge the cells if practical, or set the row height manually.

The row grows, but the line breaks look awkward: Widen the column a little, shorten the wording, or use a manual line break for a heading that needs a deliberate split. Check for long unbroken strings, such as URLs or codes, which may not wrap as expected. If a code must remain intact, consider widening the cell or placing it in a separate column instead of forcing a break.

Wrapping affects more cells than intended: Undo immediately with Ctrl+Z in Excel for Windows or Ctrl+Z in Google Sheets on Windows and ChromeOS. On Mac, use Command+Z. If you have made other changes since, reselect only the unwanted cells and toggle Wrap Text off in Excel, or choose Format > Wrapping > Overflow in Sheets. Overflow is useful when you prefer the contents to show across empty neighboring cells; choose Clip if you want the display constrained to the cell without extra lines.

The setting seems unavailable or has no effect: Confirm that you can edit the file and that you selected cells rather than a chart or an image. If the sheet is protected, request permission or use an editable copy. In a browser, reload the sheet if the toolbar is unresponsive, then check the selected cells again. In Excel for the web, the Home tab also includes a Wrap Text control, though the ribbon layout may differ from the desktop app. On Excel for Mac, select the cells and use Home > Wrap Text; the ribbon arrangement can vary with window size.

Rows become too tall to work with: Widen the column, reduce unnecessary text, or use a consistent manual row height if showing every line is not essential. Keep the full description in the cell and use Clip only when hiding part of it in the grid is acceptable. For important instructions, it is usually better to show the complete text or make the row easy to expand rather than leave readers unaware that content is hidden.

Frequently Asked Questions

Does wrapping change the text in a cell?

No. Wrapping changes how the cell displays its contents, not the stored text. The complete value remains in one cell and can still be edited, copied, searched, or referenced.

How do I wrap text in every cell of a column?

Click the column letter to select the column, then choose Home > Wrap Text in Excel or Format > Wrapping > Wrap in Google Sheets. If only part of the column needs wrapping, select that range instead to avoid changing other rows.

Why does wrapping make a row taller?

The spreadsheet needs enough vertical space to display the additional lines. That is expected behavior. If the row does not grow enough, use AutoFit Row Height in Excel or Fit to data in Google Sheets, or increase the height manually.

Can I wrap text and center it?

Yes. Wrapping and alignment are separate formatting settings. Apply wrapping first, then choose horizontal center alignment if desired. You can also set vertical alignment to Top or Middle; top alignment is often easier to read in tall table rows.

What is the difference between Wrap, Overflow, and Clip in Google Sheets?

Wrap displays text on multiple lines inside the cell. Overflow lets it continue visually into empty cells to the right. Clip hides the part that does not fit within the cell. Choose based on whether you need the whole text visible and whether neighboring cells contain data.

Can I make only one phrase in a cell wrap?

Wrapping applies to the cell’s contents, not an individual phrase. To control the split, insert a manual line break while editing the cell, or move the phrases into separate cells. A manual break is useful for a fixed label, while ordinary wrapping adapts more naturally when column widths change.

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.