How to Wrap Text in Google Sheets

  • MORE

While working in a spreadsheet, you may enter more data into a cell than space allows. That's when the wrapped text option is your friend, as it will set cells to automatically change height to reveal all the cell's contents.

screenshot 2016 05 06 11.42.19The other benefit of wrapped text is that you don't need to change the horizontal size of a column, something you may not want to do if you've laid your spreadsheet out to fit on a printed page. Here are our step-by-step instructions for how to wrap text in Google Sheets.

MORE: Best Chromebooks Available Now

1. Select the cells you want to set to wrap.


2. Click Format.textwrap02

3. Select Text wrapping.textwrap03

4. Select Wrap.textwrap04

You've successfully formatted cells to wrap in Google Sheets.


Author Bio
Henry T. Casey
Henry T. Casey,
After graduating from Bard College a B.A. in Literature, Henry T. Casey worked in publishing and product development at Rizzoli and The Metropolitan Museum of Art, respectively. Henry joined Tom's Guide and LAPTOP having written for The Content Strategist, Tech Radar and Patek Philippe International Magazine. He divides his free time between going to live concerts, listening to too many podcasts, and mastering his cold brew coffee process. Content rules everything around him.
Henry T. Casey, on