To wrap text in Google Sheets, select the cell or range, then choose Wrap from the toolbar’s Wrap text control or from Format > Wrapping > Wrap. A long address in B2, for example, will display across multiple lines inside the cell instead of extending into adjacent empty cells.
Wrapping controls text display, not every aspect of the layout. After applying it, inspect the row. If the content is still difficult to read, use Fit to data or manual row resizing.
The same setting works for a single cell, a selected range, or a whole column. Select the full target first when you want consistent formatting, such as B2:B20.
Choose Wrap, Overflow, or Clip
Google Sheets provides three text display modes. Choose based on the result you need rather than treating Wrap as the best option for every sheet.
| Mode | What it does | Use it when |
|---|---|---|
| Wrap | Displays text on multiple lines inside the cell. | All or nearly all content should remain visible within the cell. |
| Overflow | Allows text to continue into adjacent empty cells. | You want compact rows and the neighboring cells are empty. |
| Clip | Keeps text within the cell boundary and hides the excess. | The column width is fixed and hidden overflow is acceptable. |
Use Wrap for complete visibility, Overflow when compact rows matter and adjacent cells are empty, and Clip when excess text may remain hidden. The neighboring data and the required row height should decide the setting.
For Google’s definitions and desktop menu route, see its text-wrapping instructions.
Wrap text on desktop
Select the cells before choosing either route:
- Toolbar: Open the Wrap text control and choose Wrap. Google’s spreadsheet formatting help documents the toolbar control.
- Format menu: Choose Format > Wrapping > Wrap.
If the toolbar control is difficult to locate, use the Format menu instead. Selecting the whole range or column first prevents a partial formatting change.
Wrap text in the Google Sheets Android app
In the Android app, select the cell or range, tap Format, open the Cell tab, and choose Wrap text. Then check the result at the current zoom and column width. If the text is awkward to read, adjust the row or column rather than repeatedly applying the same setting.
These steps are Android-specific. The panel layout or icon placement may differ across app versions. Google’s Android formatting instructions provide the current mobile route.
Why wrapped text may still be cut off
When Wrap is active but content is not fully visible, diagnose the layout in this order:
- Display mode: Confirm that the affected cells use Wrap rather than Clip.
- Row height: Use Fit to data or resize the row when its visible area is too short.
- Merged cells: Test merged cells separately because fitting and resizing can behave differently from ordinary cells.
- Changed content: After formula results change, inspect the rendered row and fit or resize it if needed. Also confirm that the intended range was selected and copied formatting did not apply another mode.
Wrap generally expands cells to show their content, but constrained layouts can still need a manual adjustment. Do not treat formula-generated text or merged cells as universal failures. Check the specific cells and correct the condition you find.
Record a macro to apply wrapping repeatedly
A macro is useful when you perform the same formatting action repeatedly in one spreadsheet. For an occasional change, selecting the cells and choosing Wrap is simpler. Macros are spreadsheet-specific, not account-wide Google Sheets shortcuts.
- On desktop, select Extensions > Macros > Record macro.
- Choose Use relative references when the action should apply to the currently selected cells instead of fixed coordinates.
- Apply Wrap through the toolbar or Format menu.
- Save and name the macro. Assign a keyboard shortcut if useful.
Test the macro on a small range such as A2:A5 or on a duplicate sheet. The expected result is that the selected cells use Wrap while cells outside the target remain unchanged. Use Undo or revise the macro if the test changes unintended cells. Google documents that macros are bound to their spreadsheet and that a sheet can have no more than ten macros with keyboard shortcuts. See the macro recording instructions and the Apps Script macro reference.
Keep formatting separate from workflow design
Google Sheets remains a sensible choice when the main job is cell-based calculation, ad hoc analysis, or collaborative tabular editing. A task-management system may fit better when each row represents owned work that needs statuses, comments, attachments, or dependencies. That is a workflow and accountability decision, not a fix for clipped text.
If you are assessing a task workflow, ClickUp setup and automation is one option to review. Choose the system based on what each row represents, and keep spreadsheet formatting decisions separate from task-management design.
A practical decision rule
- Stay in Sheets when formulas, calculations, analysis, and flexible cell editing are the priority.
- Evaluate a task workflow when rows need owners, statuses, dependencies, or an auditable progression from one state to another.
- If you connect systems later, define the source record, destination record, permissions, and duplicate-prevention rule before enabling automation.
A spreadsheet macro can handle repeated formatting inside its bound file. It does not replace a cross-system integration, and moving data into a task tool does not automatically resolve row-height or cell-layout issues.