How to wrap text in Google Sheets
Select the cells, then go to Format → Wrapping → Wrap (or use the Text wrapping toolbar icon and choose Wrap). Sheets expands the row height so the full text stays visible inside the cell. Choose Overflow to let text spill into empty neighbors, or Clip to hide overflow. Wrap is best for notes, addresses, and multi-line labels.
Steps
-
1
Select one cell, a range, or entire columns.
-
2
Choose Format → Wrapping → Wrap.
-
3
Widen the column or let row height auto-expand so wrapped lines show.
-
4
Use Overflow or Clip if you do not want wrapping.
Related tutorials
These videos might help you go deeper on this topic.
Anika Asks: How To Set Text Overflow All The Time
How to Turn Background Color to Text
How to Replace Text with a Blank Cell in Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Wrap text
Wrap text displays cell content on multiple lines within the same cell instead of spilling into neighbors. Format > T...
Open →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →#SPILL! error
#SPILL! means a dynamic array formula tried to fill multiple cells but something blocked the spill range. Another val...
Open →Cell overflow
Cell overflow is the default behavior where long text visually extends into empty neighboring cells to the right with...
Open →Clip mode
Clip mode is a text wrapping option under Format > Text wrapping > Clip. Content that does not fit the column width i...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →Related questions
Can you wrap text in Google Sheets
For can you wrap text in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “wrap text” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →How to text wrap in Google Sheets
For text wrap in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “text wrap” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →How to wrap text on Google Sheets
For wrap text in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “wrap text” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →How to wrap text Google Sheets
For wrap text google sheets in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “wrap text” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →Google Sheets how to wrap text
For how to wrap text in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “wrap text” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →Google Sheets how to combine cells
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.