Do you sigh internally when you open a cluttered and chaotic spreadsheet?
Same. Spreadsheets can be complex to navigate — even for experienced pros — and an unformatted one just worsens things.
But there’s an easy way to spruce things up a bit — wrapping text. And we’ve got you covered with simple step-by-step instructions on how to wrap text in Google Sheets. This blog will look at the following:
- The Benefits of Wrapping Text in Google Sheets
- How to Wrap Text in Google Sheets from the Format Menu
- How to Wrap Text in Google Sheets from the Toolbar
- How to Wrap Text in Google Sheets on Mobile
The Benefits of Wrapping Text in Google Sheets
Let’s illustrate the advantages of wrapping text with the help of an example. Imagine you’re tasked with creating social media posts using a content calendar spreadsheet.
Would you prefer to receive this spreadsheet (look closely and try to make sense of everything):
Or this one:
You likely chose the second option — where the wrap text feature is enabled for all cells.
But why’s that? Let’s break down the reasons why many probably prefer the second option, or in other words, the pros of wrapping text in Google Sheets:
- It provides a neat, tidy, and uncluttered appearance and formatting.
- Wrapping text offers much-needed whitespace, an important design element.
- There's no hidden or run-off text where the next column partially covers content or spills into other cells.
- Wrapping text keeps information more streamlined, making it easier for the eye to navigate and read, thus allowing you to run smoothly through the spreadsheet without visual disruptions.
Next, we’ll dive deep into three text-wrapping approaches in Google Sheets. Before we do that, here’s a quick overview of one of the methods, in case you don’t want to scroll further to find the answer:
How to Wrap Text in Google Sheets from the Format Menu
Step 1: Choose the cells you’d like to wrap text in.
Here’s a quick trick to select all cells in a spreadsheet, which is especially useful when you have dozens of rows or columns — click on the outlined gray box in the extreme left, just above the row numbers (look at the image below).
Step 2: Click the “Format” tab from the menu bar. Then, pick the “Wrapping” option from the drop-down menu.
Step 3: Finally, click on “Wrap.”
Step 4: You’re all set! There’s nothing else to do. The wrap text feature will be applied to all the chosen cells, providing a more organized view of the content.
How to Wrap Text in Google Sheets from the Toolbar
Step 1: The first step is similar to the previous section. Simply pick the cells you want to format.
Step 2: Next, select the “text wrapping” icon in the toolbar, which can be found to the right of the alignment buttons.
Step 3: Choose the middle icon that looks like an upside-down undo button from the three options that pop up, and you’re good to go.
Quick hint: If you hover over the icon in the center, a small-pop up will appear with the word “Wrap.” This will help you identify the right option to click on.
How to Wrap Text in Google Sheets on Mobile
Step 1: First, install the Google Sheets mobile application. Next, open the file you want to work on from the mobile app and select the cells that require text wrapping.
Then, click the “Format” icon near the top of the page to the right of the redo button (see the arrow below).
Step 2: A box will pop up. Click on the “Cell” option, which will allow you to edit different elements of the selected cells (note: the default is the “text” option).
Step 3: Scroll down until you find the “Wrap text” option. Slide the switch to the on position, and you’re done. So, there it is — a simple tutorial on how to make the text fit on Google Sheets from your mobile device.
Does wrapping text make a difference?
Direct answer: Yes, it does.
Remember the 5 Cs: clean, clear, consistent, clutter-free, and no cut-off text. Your Google Sheet will be much more organized and easily read with wrapped text. So get rapping (err, I mean wrapping).