When you type a long sentence into a Google Sheets cell, the default behaviour is for the text to overflow and bleed into the adjacent cells on the right. If those adjacent cells contain their own data, the overflowing text gets visually cut off. While you can manually widen the column, this quickly makes the entire spreadsheet difficult to read on smaller screens. The most professional solution is to enable text wrapping, forcing the text to drop down to a new line within the same cell, automatically increasing the row height.
How to Enable Text Wrapping
Text wrapping can be applied to a single cell, an entire column, or the entire spreadsheet at once.
- Select the Data: First, highlight the cell or range of cells where your text is overflowing. If you want an entire column to always wrap text, click the column letter at the top (e.g., ‘C’).
- Locate the Toolbar Icon: Look at the main toolbar above the spreadsheet grid (where the font and alignment options are). Locate the Text wrapping icon. It looks like an arrow pointing to the right, bouncing back off a vertical line, and curving downwards.
- Apply the Wrap: Click the Text wrapping icon to open a small drop-down menu with three options:
- Overflow: The default setting (straight arrow). Text bleeds into the next cell.
- Wrap: The middle option (curved arrow). Text breaks onto a new line within the cell.
- Clip: The third option (arrow hitting a wall). Text is cut off exactly at the cell border, regardless of what is in the next cell.
- Select Wrap.
The highlighted cells will instantly adjust. The row height will expand vertically to accommodate all the text, ensuring every word is visible without needing to scroll horizontally or click into the formula bar.
Pro-Tip: Manual Line Breaks
Sometimes, automatic wrapping splits sentences at awkward points. If you want to force a line break at a specific word (for example, creating a bulleted list within a single cell), you do not need to rely on the automatic wrap setting.
Double-click the cell to enter edit mode, place your cursor exactly where you want the line break to occur, and press Alt + Enter (on Windows) or Option + Return (on Mac). This creates a hard return within the cell, giving you complete formatting control.