How to Wrap Text in Google Sheets Manually: Cell Guide

To wrap text manually in Google Sheets, select the cell or range, then choose Format > Wrapping > Wrap. Sheets will display long cell contents on multiple lines within the existing column width. You can also insert line breaks at specific points while editing a cell, or adjust row height and column width if the result is hard to read. These steps are for Google Sheets in a web browser.

What You’ll Need

A Google account with access to a spreadsheet in Google Sheets.
A web browser and the spreadsheet you want to edit.
Permission to change the sheet. If you only have view access, ask the owner for editing permission or make an editable copy if that option is available.

You do not need an add-on, formula, or special setting. Wrapping changes how cell content is displayed; it does not rewrite or remove the text. Before applying it to a large range, it can help to try the setting on one sample cell so you can see how the row height and layout respond.

Step-by-Step

Open the spreadsheet and locate the text. Click the tab at the bottom if the content is on a different sheet. Find a cell that contains text extending past its boundary. If you are working with several related cells, decide whether to wrap one cell, a whole column, or a specific range.
Select the cells to format. Click a single cell to wrap only that cell. To select a range, click the first cell, hold the mouse button, and drag to the last cell. You can also click a column letter to select the entire column, or click the blank square in the upper-left corner of the grid to select the entire sheet. Select only what needs the change when practical; applying wrapping to a whole sheet can make many rows taller.
Open the wrapping command. In the menu bar, click Format, point to Wrapping, then click Wrap. The setting applies to all selected cells. The other options are Overflow, which lets text display into an empty neighboring cell, and Clip, which hides the part that does not fit in the cell. Choose Wrap when the full contents should remain visible inside the cell.
Check how the cell looks. Long text should now appear on two or more lines. Sheets generally increases the row height to show wrapped content, while keeping the column width unchanged. Check the whole row, not just the selected cell: a wrapped value in one cell can make the row taller for every cell in that row. If the text still appears on one line, confirm that Wrap is selected and that the cell actually contains enough text to exceed its width.
Adjust the column width if needed. If wrapping creates too many short lines, make the column wider. Drag the boundary between its lettered column headers to set a width by eye. To fit a column to its contents, double-click the boundary on the right side of the column letter. Auto-fitting can make a column very wide when one cell contains a long paragraph, so use it carefully. You can also set a more controlled width by right-clicking the column letter and choosing Resize column, then entering a width.
Adjust the row height if the text is cut off. Move the pointer over the boundary below the row number until the resize cursor appears, then drag the boundary downward. To fit the row to its content, double-click the lower boundary of the row number. If you selected several rows, select them together before resizing when you want a consistent height. Avoid dragging the height smaller than the wrapped text needs, or some lines may no longer be visible.
Add a line break where you want a deliberate split. Automatic wrapping breaks lines according to the cell width, so the break point may change when the column is resized. For a fixed break, double-click the cell or select it and press Enter to edit. Place the insertion point where the next line should begin, then press Ctrl+Enter on Windows or Command+Enter on Mac. Press Enter again or click another cell to finish editing. The cell still needs Wrap enabled to show the separate lines neatly.
Apply the same wrapping to other cells, if needed. Select additional cells or ranges and repeat Format > Wrapping > Wrap. To copy formatting from a cell that is already set up, copy it, select the destination cells, and use Edit > Paste special > Format only. This copies formatting without replacing the destination text. Check the selection before pasting so you do not change more cells than intended.
Review the sheet at its normal viewing size. Look for rows that have become unusually tall and columns that have become too narrow. If the spreadsheet will be shared or printed, check it in the relevant view as well. Wrapping may make a sheet easier to read on screen but can increase the number of printed pages, especially when many rows contain long notes.

Common Mistakes

Choosing Clip instead of Wrap. Clip can make a cell look as if text has disappeared because it hides the portion that does not fit. The text is usually still stored in the cell. Re-select the cell and choose Format > Wrapping > Wrap to display it on multiple lines.
Expecting wrapping to insert permanent line breaks. Wrap changes the display based on available width; it does not put a line-break character at every visible line. If the column becomes wider, the same text may reflow onto fewer lines. Insert a line break during cell editing only when a particular split should stay in place.
Resizing the wrong boundary. The line between column letters changes column width, and the line between row numbers changes row height. Dragging a neighboring boundary by mistake can make the sheet seem inconsistent. Use the headers and row numbers as guides, and undo promptly with Edit > Undo if you resize the wrong one.
Formatting an unnecessarily large selection. Selecting the whole sheet and turning on wrapping can produce a much taller, harder-to-scan sheet. Select the relevant column, rows, or range instead. If you did apply wrapping broadly, select the affected area and choose Format > Wrapping > Overflow or Clip to change it back.
Using manual line breaks for every cell. Line breaks take more effort to maintain and can look awkward if column widths change. For ordinary descriptions, addresses, or notes, use automatic Wrap first. Add a break only when the intended line arrangement matters, such as separating a heading from a short note.

Tips

Set the column width before fine-tuning row heights. Changing width can change where wrapped lines break, which changes the height needed. Choose a practical width first, apply Wrap, and then adjust any unusually tall rows.
Use wrapping selectively for a tidy table. Labels and short values often read better without wrapping, while description or comments columns benefit from it. A common layout is to keep date and quantity columns compact and wrap only the notes column.
Use the toolbar when you prefer a visual control. The toolbar includes a text-wrapping control with options for Overflow, Wrap, and Clip. Select the cells, open that control, and choose Wrap. If you cannot identify the icon, use the menu path Format > Wrapping > Wrap, which is explicit.
Keep manual line breaks purposeful. A line break can separate parts of an address or put a short label above a value in one cell. It is less suitable for data that needs to be sorted, filtered, or analyzed as separate fields. In those cases, put each piece of information in its own column or row instead.
Consider merged cells separately. Merging cells can make automatic row sizing less predictable, and a row may not expand to show all wrapped text as expected. If a merged cell is clipped, try unmerging it, applying Wrap, and resizing the row. If the layout requires the merge, set the row height manually and check the full contents.
Think about collaborators and print layout. Formatting is part of the spreadsheet, so other editors generally see the wrapped display too. For a printed sheet, open File > Print and review the preview. Adjust page orientation, scale, or margins there if wrapping has made the document longer than expected.

Troubleshooting

The text still runs into the next cell. Make sure the intended cell is selected and apply Format > Wrapping > Wrap again. If the neighboring cell is empty, Overflow may allow text to spill visually across it. If the neighboring cell contains data, the overflow may stop at that cell, which can make it look as if only part of the text is present.

The text looks cut off after choosing Wrap. Check whether the row height is fixed or manually shortened. Drag the row boundary down or double-click it to fit the visible content. Also check for merged cells, since they can prevent the row from resizing as expected. If the cell contains a manual line break, make sure you are editing the intended cell and have not placed the break in an unexpected position.

The row is too tall or the lines break awkwardly. Widen the column slightly, then let the row height update. A very narrow column can turn a short sentence into many lines. If one unusually long cell is making the whole row huge, consider moving that note to a separate column or row instead of making the entire table difficult to scan.

The wrapping option is unavailable or changes nothing. Confirm that you are in Google Sheets in a browser and that you have edit access. A view-only spreadsheet will not let you change formatting. Also check that you selected the cell containing the text, not just a nearby cell. If the content already fits within the column, Wrap may be enabled without producing a visible difference.

A line break shortcut does not work. First enter cell-editing mode by double-clicking the cell or placing the cursor in the formula bar. Then place the insertion point inside the text and use Ctrl+Enter on Windows or Command+Enter on Mac. A shortcut pressed while the cell is only selected may perform a different action. If keyboard behavior differs in your browser or operating system, use the cell editor and consult the Google Sheets keyboard shortcuts menu for the current shortcut.

The change is missing when you reopen the file. Google Sheets normally saves edits automatically, but check the connection and wait for the save indicator to finish. If the file is being edited by someone else, verify that you are working in the correct tab and file. Reopen the spreadsheet or refresh only after pending changes have saved.

Frequently Asked Questions

Does wrapping change the text in a Google Sheets cell?
No. Wrap changes how the existing content is displayed. It does not delete text or insert line breaks at every visual line. To create a deliberate break within the cell, edit the text and insert a line break.

Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Format > Wrapping > Wrap. Every cell in that column receives the setting, including cells you fill in later. If only some rows need wrapping, select those cells or a specific range instead.

Can I wrap text in multiple cells at once?
Yes. Select a continuous range by dragging across it, or select a whole column or row, then use the wrapping menu. Sheets applies the setting to every selected cell. For non-adjacent ranges, apply it to each selection separately if you cannot select them together conveniently.

Why does the row get taller when I wrap text?
Sheets increases the row height so more lines can be displayed while the column width stays the same. Because row height applies across the row, other cells in that row also appear within the taller space. You can reduce the height manually, but doing so may hide part of the wrapped text.

What is the difference between Wrap and a manual line break?
Wrap lets Sheets choose line positions according to the cell width, so the displayed layout can change when you resize the column. A manual line break puts a break at a chosen point in the cell’s contents. You can use both together: automatic wrapping handles the remaining text, while the inserted break marks a preferred split.

Does wrapping work the same way in Excel?
The general idea is similar, but the menus and controls differ. These instructions use Google Sheets in a web browser; do not follow the Google Sheets menu path in Excel. In Excel for Microsoft 365 on Windows, the corresponding command is on Home > Wrap Text.

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.