How to Wrap Text in Cells and Adjust Row Heights in Google Sheets

When entering descriptions, customer addresses, notes, or web URLs into Google Sheets, long text entries frequently overflow into neighbouring blank cells or get abruptly cut off if the adjacent cell contains data. While widening the column is a common first reaction, doing so for lengthy paragraphs stretches the column across your entire screen, ruining the balance and readability of your spreadsheet. Google Sheets solves this problem with text wrapping, which automatically expands row heights to fit complete sentences within fixed column boundaries.

Understanding Text Wrapping Options in Google Sheets

Google Sheets offers three distinct text wrapping behaviours depending on how you want your data displayed:

• Overflow: The default setting. Text continues horizontally into adjacent cells if they are empty, but gets truncated visually if neighbouring cells contain values.
• Wrap: Automatically breaks lines at word boundaries, increasing the row height so that all text remains visible within the designated column width.
• Clip: Cuts off any text that exceeds the cell width without spilling over, regardless of whether adjacent cells are empty.

How to Enable Text Wrapping on Selected Cells

You can apply text wrapping to individual cells, entire rows, specific columns, or the entire spreadsheet:

1. Open your spreadsheet in Google Sheets.
2. Select the cells, columns, or rows you want to format. To wrap the entire worksheet, click the empty rectangle in the upper-left corner between column header A and row header 1 (or press Ctrl + A / Cmd + A).
3. Locate the Text wrapping icon on the top formatting toolbar (an arrow looping under a vertical line).
4. Click the icon to open the dropdown menu and select Wrap (the middle icon showing lines bent around an arrow).
5. Google Sheets will immediately adjust the row height to display all text neatly across multiple lines.

Alternative: Using the Format Menu

If you prefer keyboard navigation or menus over toolbar buttons:

1. Highlight your target cell range.
2. Click on the Format menu at the top of the window.
3. Hover your cursor over Wrapping.
4. Click on Wrap from the submenu.

How to Insert Manual Line Breaks Inside a Wrapped Cell

Sometimes you need a line break at an exact point—such as separating lines of a physical mailing address—rather than relying on automatic word wrapping:

• On Windows or ChromeOS, press Alt + Enter while typing or editing within a cell.
• On macOS, press Option + Return or Cmd + Return.
• Each keystroke creates an intentional hard line break that remains intact even if you change column widths later.

How to Fix Uneven or Excessively Tall Rows

If wrapping extensive paragraphs makes certain rows disproportionately tall, you can set a maximum row height. Right-click the row numbers on the left margin, select Resize row, choose Specify row height, and enter a fixed pixel value (such as 40 or 60). Any text exceeding this height will be contained cleanly without distorting your spreadsheet view.