It’s relatively easy to wrap text on a given cell in Google Sheets. The command or button for it is right on the menu. Let’s nonetheless guide you through the whole thing.
While the original unformatted text should look fine on the simplest of spreadsheets, some spreadsheets like those found on Google Sheets might look rather drab or unpolished without having the text wrapped around a given cell or a given series of cells.
Therefore, let’s discuss how to wrap text in google sheets. Knowing how to do so results in cleaner presentations and data sheets you can glean info from at a glance!
Why Do You Need to Wrap Text?
Maybe you’re transferring data from Microsoft Excel to Google Sheets, thinking they’re compatible enough to work. However—surprise, surprise—they’re not wrapping properly. This is a persistent problem for those who transfer data from one program to another.
Text wrapping keeps the text from overflowing from the cells, resulting in a messy-looking spreadsheet you wouldn’t want to present to your boss and colleagues. It results in a cleaner result with everything in place instead of looking like a collage full of magazine cutouts.
It also allows you to view your data at a glance instead of needing to move columns or rows correctly to see all the text right.
Method 1: Use the Toolbar Method
Step 1: Open your spreadsheet. Usually, the data you need to text wrap come straight from Excel and when they’re pasted on Google Sheets, they come out with the texted unwrapped or, in this case, overflowing from their cells.
Step 2: Fixed the unformatted text by selecting it all (you can click on a cell and use the “Ctrl + A” shortcut to do so) and going to the toolbar to select the “Wrap” option.
Step 3: The “Wrap” option should appear in the middle of the three options. The two other options are “Overflow” (where the text goes out of the cell if the cell is too small) and “Clip” (where the text is clipped if the cell is too small).
Step 4: You should end up with a much cleaner look or the original wrapped formatting of your “imported” Excel sheet once you’ve wrapped the text in a way that the cells conform to the text instead of the other way around.
Method 2: Use the Menu Method
Step 1: Instead of using the toolbar with the wrapping options, you can go to the “Format” menu this time.
Step 2: Let’s go back to the part where you’ve selected all the cells of your spreadsheet in order to format their text as wrapped text. Go to the “Format” menu then select “Wrapping” and click on “Wrap” (also the second option like before).
Step 3: You should end up with the same results, with your unformatted text now cleanly within the lines of the cells, recovering their original formatting that was lost from the Excel file you used to copy and paste them unto your Google Sheets.
In order to wrap any text in Google Sheets, you need to first select an entire column or row you wish to wrap the text with by clicking on the column letter or row number. Go to the “Format” menu and then select “Wrap” and click on the option for “Text Wrapping“. Click on “Wrap” and you’re good to go.
You can also just select all or select the cells you want to format and use the toolbar icons for “Text Wrapping” and select “Wrap” to get the same results.
That’s it. That’s the whole process. It’s rather simple, isn’t it?
- Kevin Kessler, “How To Wrap Text in Google Sheets and Google Docs“, Wordable.io, December 18, 2020
- “How To Wrap Text in Google Sheets With 1 Simple Click“, SpreadsheetPoint.com, Retrieved June 11, 2022