How to Wrap Texts on Google Sheets: 2 Easy-to-follow Methods
If you’re newly coming onto Google Docs, many things on the web-based program will come off as different. As such, you might need help navigating through the UI and using some of its features, especially if you’re coming from its evergreen Microsoft alternative, Excel.
Thankfully, Google Sheets is just as intuitive as the competitions out there (if not better), with all the features you need to optimize your spreadsheets accessible with just a few clicks. Speaking of optimization, wrapping your texts will refit texts that have gone out of a cell, making your spreadsheet cleaner and easy on the eyes.
Read on below to find out how to go about it.
How to Wrap Texts Into Their Cells on Google Sheets
As suggested earlier, nobody wants to be saddled with reading a spreadsheet with clustered information. Using the Wrap feature on your texts on Google Sheets will rearrange your texts and automatically adjust the cells in which they are to fit just about rightly.
You can employ two methods to wrap your texts on Google Sheets, any of which you can choose depending on its convenience for you. The steps below will guide you in that regard.
Method 1: Wrap Texts Via the Format Menu
This method is straightforward and will keep texts that overflow out of their cells back within, giving your spreadsheet the much-needed, optimal presentability. To use this method,
- Select or highlight the cells in which you want to wrap your texts.
- Highlight the cells by holding and dragging your mouse cursor over them or select the cells individually with CTRL + mouse right-click.
- Navigate to the top menu of Sheets and select Format > Text Wrapping > Wrap
That should change the Text Wrapping option for your cells from Overflow to Wrap and, as a result, make your texts fit inside the target cells. However, it’s worth noting that this will increase the height of the selected cells, which might not sit well with some people based on how they want the sheet to appear.
You might want to use the Clip option under Text Wrapping instead when that’s the case. This one tucks away the remaining characters of a group of texts while maintaining the original height of the cell, making it the perfect option for URLs.
Method 2: Wrap Texts Via the Toolbar
This method offers no level of convenience that blows the former out of the water, but it’s always nice to have an extra option present. To use this method,
- Highlight the cells in which you want to wrap a group of texts (Use commands from the previous method)
- Navigate to the toolbar below the top menu and click the text-wrapping icon
- Next, click on the icon with a reverse arrow between two vertical bars from the options therein
And that’s it! Your texts are wrapped inside their cells as you want them to.
Final Notes
That’s basically all there is to wrapping your texts in Google Sheets. However, if the texts don’t appear to align as you’d want them after using this option, simply navigate to the top menu again and click Format > Alignment. Then, adjust the cells horizontally or vertically to fit your texts.