When entering long descriptions, customer feedback, URLs, or notes into Google Sheets, text strings often exceed the default width of standard columns. By default, Google Sheets allows uncontained text to spill into neighbouring cells if they are empty, creating messy visual overlaps, or abruptly truncates text if adjacent cells contain data.
To keep tables structured, clean, and legible, Google Sheets provides three native text wrapping strategies: Overflow, Wrap, and Clip. Here is how to configure automatic text wrapping, automatically adjust row heights, and insert manual line breaks inside individual cells.
Understanding the Three Text Wrapping Modes in Google Sheets
Google Sheets offers three distinct text handling behaviours accessible via the main toolbar and application menu:
| Wrapping Mode | Visual Behaviour | Recommended Use Case |
|---|---|---|
| Overflow (Default) | Text extends into adjacent empty cells to the right. If the adjacent cell contains data, the trailing text is hidden behind that cell. | Wide header labels or standalone title rows with no adjoining values. |
| Wrap | Automatically expands the row’s height and wraps text onto multiple vertical lines within the confines of the column width. | Multi-sentence comments, customer reviews, survey responses, and detailed item descriptions. |
| Clip | Truncates the visible text strictly at the column border without overflowing into empty adjacent cells. | Long technical IDs, tracking hashes, serial numbers, and raw URLs where maintaining uniform single-line row heights is essential. |
How to Enable Text Wrapping Using the Toolbar
The fastest way to wrap text across individual cells, entire columns, or full sheets is via the toolbar icon.
- Open your spreadsheet in Google Sheets.
- Highlight the cells, rows, or columns you wish to format (click a column letter header, such as
B, to select the entire vertical column). - Click the Text wrapping button on the toolbar (depicted as an arrow curving around a vertical line).
- In the dropdown menu, click the middle icon: Wrap.
Google Sheets immediately recalculates cell boundaries, wrapping long text strings onto new lines and automatically expanding row heights to accommodate all lines.
How to Enable Text Wrapping from the Format Menu
If the toolbar is collapsed or you prefer using keyboard-navigable menus:
- Select your target cell range.
- Click Format in the top menu bar.
- Hover your cursor over Wrapping.
- Select Wrap (or choose Clip if you prefer clean single-line truncation).
Inserting Manual Line Breaks Inside a Cell
While automatic wrapping breaks lines wherever words meet the right-hand column border, you may want to force a line break at an exact word—such as creating bulleted lists or separating address lines within a single cell.
To insert a manual line break while typing or editing in Google Sheets:
- Windows and Chrome OS: Press Alt + Enter (or Ctrl + Enter).
- macOS: Press Option + Return (or Control + Return).
When you commit the cell with Enter, Google Sheets automatically switches that cell to Wrap mode to display your custom paragraph structure.
Adjusting Row Heights and Resetting Uniformity
When multiple rows contain wrapped text with variable line lengths, row heights can become irregular across your worksheet. You can standardise row dimensions easily:
Auto-Fitting Row Heights to Fit Content Exactly
- Highlight the affected row number headers on the left (or press Ctrl + A to select the entire sheet).
- Double-click the subtle dividing line between any two selected row numbers.
- Google Sheets instantly auto-fits every row’s height to the exact vertical space required by its wrapped contents.
Enforcing Uniform Fixed Row Heights with Clip
If you prefer a compact, scannable table where every row remains exactly one line tall regardless of text length, select the columns and choose Clip wrapping. To read the complete text of any clipped cell, simply click on it to inspect the full contents inside the Formula Bar above the sheet.
Combining clean text wrapping with other data preparation techniques—such as using the GETPIVOTDATA function or learning how to compare two columns and highlight differences in Google Sheets—ensures your reports remain readable, professional, and audit-ready.