• Home

  • Productivity

  • App tips

App tips

2 min read

How to wrap text in Google Sheets

By Jessica Lau · January 30, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

You can fit a lot of data into a Google Sheets spreadsheet. But that data would be impossible to parse if it wasn't neatly formatted. 

Take something as simple as a string of text. If your cell isn't wide enough to fit the text, it'll automatically flow into the neighboring cell. (This is a default Google Sheets setting.) This isn't really a problem so long as the neighboring cell is empty. But once you enter data into it, some of your original text will disappear.

Here, I'll show you how to wrap text in Google Sheets to prevent that from happening.

How to wrap text in Google Sheets

  1. Open your Google Sheets spreadsheet. 

  2. Use your keyboard shortcut to select all your cells: command+A on Mac or Ctrl+A on Windows. Or, if you want to wrap the text only in specific cells, highlight those cells.  

  3. Click the Text wrapping icon in the toolbar, and then select the Wrap icon. If these aren't visible to you, first click the More icon, which looks like three dots stacked vertically (⋮). 

How to wrap text in Google Sheets using the text wrapping tool.

That's it—no more overflow into adjacent cells. Instead, Google Sheets takes any text that reaches the end of the cell width and drops it to the next line. 

Example of wrapped text in Google Sheets.

If the wrapped text looks squished or the wrap breaks the text at an awkward spot, simply expand the width of your cell. The easiest way to do this is to hover your cursor over the gray bar on either side of your column's letter header. (If you want to expand column A, you can only expand from the right side.) Your cursor will automatically turn into a vertical bar with arrows pointing left and right. Click and drag the bar to expand your cell. 

Demo of how to widen a cell in Google Sheets.

Automate Google Sheets 

If you use Google Sheets as a source of truth for your data—whether that's customer information or project management—you can use Zapier to connect Google Sheets with your other apps. This way, you can automatically keep all your spreadsheets organized and ensure that your data is consistent across all apps. Learn more about how to automate Google Sheets, or get started with one of these workflow templates.   

Create Trello cards from new or updated Google Sheets rows

Create Trello cards from new or updated Google Sheets rows
  • Google Sheets logo
  • Trello logo
Google Sheets + Trello

Create Asana tasks from updated Google Sheets rows

Create Asana tasks from updated Google Sheets rows
  • Google Sheets logo
  • Asana logo
Google Sheets + Asana

Add new labeled Gmail emails to rows in Google Sheets

Add new labeled Gmail emails to rows in Google Sheets
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Related reading: 

  • How to split text in Excel and Google Sheets

  • How to use VLOOKUP in Google Sheets

  • How to freeze columns in Google Sheets

  • How to create and use pivot tables in Google Sheets

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'