Wrap Text in Google Sheets: All Devices Guide

Wrapping text in Google Sheets keeps long entries fully visible within a cell instead of spilling over or getting cut off. This guide shows you how to enable text wrapping on desktop, Android, and iOS, plus how to adjust row heights so nothing stays hidden.

What You’ll Need

• A Google account and access to Google Sheets (web browser or mobile app)
• The spreadsheet containing the text you want to wrap
• No special extensions or add-ons are required

Step-by-Step

On Desktop (Web Browser)

1. Open your spreadsheet in Google Sheets using Chrome, Firefox, Safari, or Edge.
2. Select the cell, range of cells, entire row, or entire column you want to format. To select multiple non-adjacent cells, hold Ctrl (Windows) or Cmd (Mac) while clicking.
3. Click Format in the top menu bar.
4. Hover over Text wrapping in the dropdown menu.
5. Choose Wrap from the submenu. Your text will now stay inside its cell and expand the row height automatically.
6. If the row height doesn’t adjust automatically, click and drag the boundary line between row numbers at the left edge of the sheet, or go to Format > Row height and select Fit to data.

On Android (Mobile App)

1. Open the Google Sheets app on your Android phone or tablet.
2. Open the spreadsheet you want to edit.
3. Tap once on a cell to select it, or drag the blue handles to select multiple cells.
4. Tap the Format icon (it looks like the letter “A” with horizontal lines) at the top of the screen.
5. In the panel that slides up, tap the Cell tab if it isn’t already selected.
6. Scroll down and tap Wrap text. The toggle will turn blue when enabled.
7. Tap anywhere outside the panel to close it. The selected cells will now wrap their text.

On iPhone and iPad (iOS App)

1. Open the Google Sheets app on your iPhone or iPad.
2. Open the spreadsheet you want to modify.
3. Tap a cell to select it, or drag the blue dots to select a range.
4. Tap the Format icon (the “A” with lines) in the top toolbar.
5. In the formatting panel, tap the Cell tab at the top.
6. Find the Wrap text option and tap the toggle to turn it on.
7. Tap the checkmark or simply tap outside the panel to apply the change.

Common Mistakes

• Selecting the wrong cells: Wrapping only affects the cells you selected. If text still spills over, double-check your selection includes all cells with long content.
• Confusing wrap with overflow: The default setting is “Overflow,” which lets text spill into empty adjacent cells. Wrap is a separate option, not a toggle of overflow.
• Forgetting row height: Sometimes wrap works but the row stays short, making text appear cut off. Manually adjust the row height or use “Fit to data” after wrapping.
• Applying to merged cells: Wrapping text in merged cells can behave unpredictably. Unmerge the cells first, wrap, then re-merge if needed.
• Not applying to new data: Wrapping doesn’t automatically apply to cells you add later. Select new cells and wrap them individually, or set a default for the whole column.

Tips

• Wrap an entire column: Click the column letter at the top to select the whole column, then apply wrap. New entries in that column will automatically wrap.
• Use keyboard shortcuts: On desktop, select cells and press Ctrl+Shift+W (Windows) or Cmd+Shift+W (Mac) to toggle wrapping quickly.
• Combine with row height: After wrapping, set a comfortable row height so all lines are visible without excessive whitespace.
• Adjust column width: If wrapped text creates very tall rows, widen the column so fewer lines are needed.
• Use for headers: Wrap header cells to keep them readable without making the column excessively wide.
• Check print layout: Wrapped text may affect how your sheet prints. Use File > Print > Print preview to verify everything fits.

Troubleshooting

Text Still Overflows After Wrapping

If you selected “Wrap” but text still spills into adjacent cells, the adjacent cells may contain data. Wrapping only contains text within its own cell; if the next cell is empty, overflow may still appear visually. Re-select the cells and confirm the wrap option is active (the menu should show a checkmark next to “Wrap”). Also ensure you didn’t accidentally select “Overflow” instead.

Row Height Doesn’t Expand

Occasionally, wrapped text doesn’t automatically increase row height. Manually adjust it by dragging the bottom edge of the row number down, or right-click the row number and choose Resize row > Fit to data. If that fails, set a custom row height that accommodates the text.

Wrap Option Grayed Out on Mobile

On Android or iOS, the wrap toggle may appear grayed out if you have a merged cell selected or if the sheet is in a protected range. Unmerge the cells or check with the sheet owner about editing permissions.

Wrap Works but Text Is Cut Off

This usually means the row height is too small. Increase the row height manually, or check that the row isn’t set to a fixed height that overrides the auto-fit. On desktop, go to Format > Row height and select Fit to data.

Changes Not Saving

Google Sheets autosaves, but if you’re offline, changes may not sync. Check your internet connection and look for the “Offline” indicator in the top bar. Reconnect and the changes should upload.

Wrap Not Applying to New Rows

Formatting applies to selected cells only. To make wrapping permanent for future entries, select the entire column (click the column letter) before applying the wrap. New rows added to that column will inherit the formatting.

Frequently Asked Questions

Can I wrap text in just one cell without affecting others?

Yes. Select only that single cell, then apply the wrap format. Other cells remain unchanged.

Does wrapping affect how my sheet prints?

Yes. Wrapped text increases row heights, which can change pagination. Use Print preview (File > Print) to check the layout and adjust column widths or scaling if needed.

Can I set wrap as the default for all new spreadsheets?

No. Google Sheets doesn’t have a global default for text wrapping. You need to apply it per sheet or per column. However, you can create a template spreadsheet with wrapping pre-applied and use that for new projects.

Why does my text disappear when I wrap it?

If text disappears after wrapping, the row height is probably too small, hiding the lower lines. Increase the row height or select “Fit to data” to reveal all wrapped lines.

Is there a way to wrap text automatically as I type?

If you pre-format a column with wrapping, any text you type in that column will wrap automatically. Select the column, apply wrap, and all new entries will follow the format.

Can I wrap text in cells that contain formulas?

Yes. Wrapping affects how the displayed result of a formula appears, not the formula itself. If the formula returns a long text string, wrapping will show it in multiple lines within the cell.

Related

• Fix Windows Sandbox Copy Paste Not Working
• Transfer Programs & Apps to a New PC Without Disks
• How to Add Shapes in Google Docs