---
title: "How to wrap text in Google Sheets: menu, toolbar and fixes"
canonical: "https://www.owox.com/blog/articles/how-to-wrap-text-google-sheets"
updated: "2026-10-05"
---

# How to wrap text in Google Sheets: menu, toolbar, line breaks and fixes

To wrap text in Google Sheets, select the cells and choose Format > Wrapping > Wrap, or use the wrapping button in the toolbar. This guide explains the three options, wrap, overflow and clip, manual line breaks inside a cell, column width and row height, and the reasons wrapped text stays cut off.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 7 min read

![How to wrap text in Google Sheets: menu, toolbar, line breaks and fixes](https://cdn.owox.ai/www/webflow/6a1498619f6164bdce04f783_WRAP-TEXT-IN-GOOGLE-SHEET.png/public)

To wrap text in Google Sheets, select the cells and choose **Format > Wrapping > Wrap**. Text that is longer than the column is wide then continues on the next line inside the same cell, and the row grows taller to show all of it.

The same setting is on the toolbar, behind the text wrapping button. It has three options:

| Option | What long text does | Use it for |
| --- | --- | --- |
| **Overflow** (the default) | Runs over the next cells as long as they are empty; if the next cell has content, the text is cut off at the cell border | Short labels with empty cells beside them |
| **Wrap** | Continues on new lines inside the cell; the row gets taller | Notes, descriptions, addresses |
| **Clip** | Is cut off at the cell border, whatever is in the next cell | Tables where every row should keep the same height |

None of the options changes the content of the cell. The full text is always there and shows in the formula bar.

## Wrap text from the format menu

**Step 1:** Select the cells, rows or columns to format. To select a whole column, click its letter; for the whole sheet, press Ctrl + A (Cmd + A on a Mac).

![Google Sheets with the Notes column selected, its long text running over the neighbouring empty cells](https://cdn.owox.ai/www/webflow/67f4023baa60ee60cb2ad666_AD_4nXc6Ylvq2bu4s6KJmzXv2to2q6uQ-fySmgV4da-GeVL5FNDfwakubEoZOA5EUrctmFoKfNpGpTJ8m4AOMp7k1qbIEt723vexqnlvRdq64QEkLZpMpdgLDHYi3djMHMzdEb9cvsUkVQ.png/public)

**Step 2:** Open the **Format** menu.

![The Format menu of Google Sheets with Number, Text, Alignment, Wrapping and Rotation among the items](https://cdn.owox.ai/www/webflow/67f4023ba176afefd475ceea_AD_4nXfm7nX4ddE_eQphL9iBBL8ziHRxLGBP8iSEv1XiWBw__k6GNWm56HvWh-9GguQ9u3C8UEQiZvKZ1t9JoTghucxp4w0KQVz39vydEatSK9QWceOTVOPlw5J2Bj-CWjq9suRC2Df7RA.png/public)

**Step 3:** Point to **Wrapping** and choose **Wrap**.

![The Format menu of Google Sheets open on Wrapping, with the options Overflow, Wrap and Clip](https://cdn.owox.ai/www/webflow/67f4023b5a43df2830c5c691_AD_4nXdLIzwgukQ2j4k7U9uHjrHKxMOIC4hGts4W3JE_BJzBiR6Ds_qPGzSEOnYuo-Pv336DreNlJ_gCJjb1-faVMquo8vJIp2qAWGgUuRnaIZMhUjjtVb7RT7Gb2xUWXY2WNCQDoLMG.png/public)

The text now breaks into lines inside each selected cell, and the rows are tall enough to show it.

![Google Sheets with the Notes column wrapped: each note is shown on several lines inside its cell and the rows are taller](https://cdn.owox.ai/www/webflow/67f4023bf11be53d958cdb73_AD_4nXeIqrUaJOvNF63Uj0ts4n8zYQ6kN7Ntz1QqKqSsuHc54cULbtpWsLXM1oMAh17t6MsHSIlXGUWB4_aP14fv6q1IMzikfTv5s2SUoTceL54a24z30TtRX6ETlQ4eljcDxH3SflzaLg.png/public)

To undo it, choose **Overflow** or **Clip** in the same menu.

## Wrap text from the toolbar

**Step 1:** Select the cells and click the text wrapping button in the toolbar. On a narrow window it is under the three-dot menu at the right end of the toolbar.

![The toolbar of Google Sheets with the text wrapping button open, showing icons for Overflow, Wrap and Clip](https://cdn.owox.ai/www/webflow/67f4023b3441c1fce3ebbf2c_AD_4nXdon_pUzGPepUfIMIZK1QabRQIiEr9iM9WcdL2rulS4pmbYVubUB_UTSYHgNO8ro78Y9nRRNJ5342WT00b19mglmCfodyF-WMTzxkF5GnImoMKkZJzYVgQx2KouwinMn_olwsQJ.png/public)

**Step 2:** Click the middle icon, **Wrap**.

![Google Sheets with the Wrap icon selected in the toolbar and the Notes column wrapped inside its cells](https://cdn.owox.ai/www/webflow/67f4023b4300c29088a5e761_AD_4nXdC3FIqRIdb4588EOYRRPEzihxtLk6D7nVqexpAiEVrpLR1plCY2yFLqvuynuwQ_e6KFWTlO2XgyHyCyurJb6ayAKc2Qz3NMoWuUgqXNQEuRAzvqi9OC6Pixen49JKWLd1kvWPw3Q.png/public)

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Break a line where you want

Wrapping breaks the text wherever the column ends. To decide yourself where a new line starts, insert a line break inside the cell.

**Step 1:** Double-click the cell, or select it and press F2, to edit it.

![Google Sheets with cell D3 selected, holding the text Handles campaigns and team strategies](https://cdn.owox.ai/www/webflow/67f4023b1c0eaa6d046df0ca_AD_4nXcWEl2ETYDIV7mddt9sciN5nqeii2xfJBlfvQzwA08EtwsdK9didj6waaTf3m1MbfCD7XJcmstffRDL66di2vd_117xOfyDdWjKG-qJqbtniQjb5i5e1RGC6dR38BEjx-UDlHi-rQ.png/public)

**Step 2:** Put the cursor where the line should break and press **Alt + Enter** (Ctrl + Enter also works) on Windows, or **Option + Enter** (Cmd + Enter) on a Mac.

![Google Sheets with cell D3 in edit mode and the cursor placed after the first word](https://cdn.owox.ai/www/webflow/67f4023b3073c9089c6a6650_AD_4nXcvtdcC-EFQMca06fCguhLrG6oe3l8EVpWFGOnyEkcL9LK7pk4kK1CwQ8mPLnnvzCWvys-GLA8XDgtujwcQO4EmAeoFiVi8JZSl9-5nU4R6DX-K8AVo76_GHvsboVXe8M1-3ksq2A.png/public)

**Step 3:** Repeat for every break you need and press Enter to finish.

![Google Sheets with cell D3 in edit mode showing the text on three lines after two line breaks were inserted](https://cdn.owox.ai/www/webflow/67f4023b3a53cce8fffdda4d_AD_4nXfoEYf4NUWYTM-wURInBFeZN-rlvJl5JqExDkxR7lf3iOFLK9zsyrBCq4KGUg8DZWLl1dhI5Mqg8QwaezhQXYTEw7CR8du4palOhi3ff9tQIyW_LaKPKQgp24bG2fYW2kfl-hyg.png/public)

A line break is part of the content, not formatting: it stays where it is when the column gets wider. In a formula, CHAR(10) is the line break: `=B3 & CHAR(10) & C3` puts two values on two lines of one cell. Turn wrapping on for that cell, otherwise the result shows on one line.

## Column width and row height

Wrapped text follows the width of its column. Drag the border between two column letters to make the column wider or narrower, and the text rearranges itself.

![Google Sheets with the cursor on the border between the column letters D and E, ready to drag](https://cdn.owox.ai/www/webflow/67f4023bfae5c309518f4a3d_AD_4nXfdjuMDfHgGzQvcdN_iVOooHczp1JsK0Vv5d_Bo7jIIATklMm_ZTOi_qL9eilQtEzRYEZ95Y2cEZ4xmJgcziIf5SL34jQm2rtnmm0bbR1sL6WNf3eqrGOc9TGzxouPdID5F9fP29g.png/public)

![Google Sheets with column D resized by dragging the border of its column letter](https://cdn.owox.ai/www/webflow/67f4023a7cd64c720dac63e5_AD_4nXdoFeBmWnSlqEgKfjJJH1RPo-DX-rEVYoIdGnWD5eLVXZu-E8aIC_oiCfTQSmj0tlWni9DtwbYfm0tCpjstsc6uvDhg5CfEvW6I6TJ72gQFKihApA6yG-Wu1230FBUqG7seKi8ZSA.png/public)

Two shortcuts with the mouse:

*   **Double-click the border of a column letter** to fit the column to its longest entry.
*   **Right-click a row number, choose Resize row and select Fit to data** to let the row height follow the wrapped text again after it has been set by hand.

## Why wrapping does not work

**⚠️ Issue:** Wrap is on, but the text is still cut off at the bottom.

✅ **Solution:** The row has a fixed height. Once a row has been resized by hand, it no longer grows with its content. Right-click the row number, choose **Resize row** and select **Fit to data**.

**⚠️ Issue:** The text does not break although Wrap is selected.

✅ **Solution:** Check that the format was applied to this cell: select it and look at the wrapping button in the toolbar. Text copied from another file can bring its own setting, and pasting with Ctrl + Shift + V (values only) keeps the formatting of the destination cell.

**⚠️ Issue:** A long URL or code breaks in the middle of a word.

✅ **Solution:** Text without spaces has no natural place to break, so it is cut where the column ends. Make the column wider, or use Clip for such columns.

**⚠️ Issue:** Wrapped text in merged cells is cut off.

✅ **Solution:** A row does not adjust its height to merged cells. Set the row height by hand, or avoid merging the cells that hold long text.

**⚠️ Issue:** Text spills over the next column.

✅ **Solution:** The cell is set to Overflow and the next cell is empty. Choose Wrap or Clip.

## Tips for sheets with long text

*   **Set wrapping per column, not per sheet.** Wrap the columns with notes and descriptions, clip the ones with URLs and IDs, and rows stay at a readable height.
*   **Align wrapped rows to the top.** With rows of different heights, **Format > Alignment > Top** keeps the short entries on the first line.
*   **Go easy on merged cells.** They get in the way of sorting, [filters](/blog/articles/google-sheets-filter-function) and automatic row heights.
*   **Split instead of wrapping when one cell holds several values.** A list of values in one cell is easier to work with in separate columns; see the guide to [splitting cells](/blog/articles/how-to-split-cells-in-google-sheets).

## Related Google Sheets functions

Functions that help with long text, each with its own guide:

*   [CHAR](/blog/articles/char-function-google-sheets): Returns the character for a Unicode number, CHAR(10) for a line break.
*   [TRIM, CLEAN and T](/blog/articles/trim-clean-t-functions-google-sheets): Remove extra spaces and non-printing characters from text.
*   [CONCATENATE and the ampersand](/blog/articles/concatenate-and-ampersand-google-sheets): Join text from several cells.
*   [LEFT/RIGHT/MID](/blog/articles/left-right-mid-functions-google-sheets): Extract part of a text.
*   [LEN](/blog/articles/len-function-google-sheets): Counts the characters in a cell.
*   [REPLACE](/blog/articles/replace-function-google-sheets): Swaps part of a text string for new text, based on position and length.
*   [UPPER/LOWER/PROPER](/blog/articles/upper-lower-proper-functions-google-sheets): Changes text to upper case, lower case or title case.
*   [Find and replace](/blog/articles/how-to-find-and-replace-google-sheets): Changes text across a sheet in one step.

## Formatting survives only if the data underneath stays put

Wrapping, column widths and row heights are set on cells, not on the data in them. In a report that is rebuilt from a fresh export every week, the careful formatting is redone every week too, or lost when the new rows are pasted over the old ones.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.ai/www/content-marketing-article/how-to-wrap-text-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. With a refresh in place of a weekly paste, the report keeps its place in the file, and the sheet does not have to be rebuilt around a new export each time. The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

How do I undo text wrapping in Google Sheets?

Select the cells, open Format > Wrapping and choose Overflow or Clip. Overflow lets long text run over empty neighbouring cells; Clip cuts it off at the cell border.

Can I wrap text in merged cells in Google Sheets?

Yes. Select the merged cell and choose Format > Wrapping > Wrap. The row does not adjust its height to merged cells, so set the row height by hand to show all the lines.

How do I wrap text for multiple cells at once?

Select the range, or click a column letter to select the whole column, then choose Format > Wrapping > Wrap. The setting is applied to every selected cell at once.

Is there a shortcut to wrap text in Google Sheets?

The menu can be opened from the keyboard, but there is no single key for the Wrap setting. To break a line at a chosen place inside a cell, edit the cell and press Alt + Enter on Windows or Option + Enter on a Mac.

Why is text wrapping not working in Google Sheets?

The usual cause is a row with a fixed height: after a row is resized by hand it no longer grows with its text. Right-click the row number, choose Resize row and select Fit to data. Merged cells and long strings without spaces, such as URLs, also do not wrap the way ordinary text does.

Can I wrap text automatically in Google Sheets?

Yes. With Format > Wrapping > Wrap applied, the text breaks at the column border by itself and re-flows when the column width changes. No manual line breaks are needed.

How can I enable text wrapping in Google Sheets?

Select the cell or range and choose Format > Wrapping > Wrap, or click the text wrapping button in the toolbar and pick the Wrap icon. The text continues on new lines inside the cell and the row becomes taller.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.ai/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · UNIQUE function in Google Sheets: syntax, examples and errors · October 2, 2026](/blog/articles/unique-function-google-sheets)

[Google Sheets Tips · How to link cells, tabs and sheets in Google Sheets · October 2, 2026](/blog/articles/linking-data-across-multiple-google-sheets)

[Google Sheets Tips · How to sum in Google Sheets: SUM, SUMIF and SUMIFS formulas · October 2, 2026](/blog/articles/sum-functions-google-sheets)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [filters](https://www.owox.com/blog/articles/google-sheets-filter-function) — /blog/articles/google-sheets-filter-function.md
- [splitting cells](https://www.owox.com/blog/articles/how-to-split-cells-in-google-sheets) — /blog/articles/how-to-split-cells-in-google-sheets.md
- [CHAR](https://www.owox.com/blog/articles/char-function-google-sheets) — /blog/articles/char-function-google-sheets.md
- [TRIM, CLEAN and T](https://www.owox.com/blog/articles/trim-clean-t-functions-google-sheets) — /blog/articles/trim-clean-t-functions-google-sheets.md
- [CONCATENATE and the ampersand](https://www.owox.com/blog/articles/concatenate-and-ampersand-google-sheets) — /blog/articles/concatenate-and-ampersand-google-sheets.md
- [LEFT/RIGHT/MID](https://www.owox.com/blog/articles/left-right-mid-functions-google-sheets) — /blog/articles/left-right-mid-functions-google-sheets.md
- [LEN](https://www.owox.com/blog/articles/len-function-google-sheets) — /blog/articles/len-function-google-sheets.md
- [REPLACE](https://www.owox.com/blog/articles/replace-function-google-sheets) — /blog/articles/replace-function-google-sheets.md
- [UPPER/LOWER/PROPER](https://www.owox.com/blog/articles/upper-lower-proper-functions-google-sheets) — /blog/articles/upper-lower-proper-functions-google-sheets.md
- [Find and replace](https://www.owox.com/blog/articles/how-to-find-and-replace-google-sheets) — /blog/articles/how-to-find-and-replace-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · UNIQUE function in Google Sheets: syntax, examples and errors · October 2, 2026](https://www.owox.com/blog/articles/unique-function-google-sheets) — /blog/articles/unique-function-google-sheets.md
- [Google Sheets Tips · How to link cells, tabs and sheets in Google Sheets · October 2, 2026](https://www.owox.com/blog/articles/linking-data-across-multiple-google-sheets) — /blog/articles/linking-data-across-multiple-google-sheets.md
- [Google Sheets Tips · How to sum in Google Sheets: SUM, SUMIF and SUMIFS formulas · October 2, 2026](https://www.owox.com/blog/articles/sum-functions-google-sheets) — /blog/articles/sum-functions-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md