Learn how to wrap text in Google Sheets in 3 simple steps + the different wrapping options you can use.
If you’ve entered more data into a cell than space allows, you should learn how to wrap text in Google Sheet to avoid it looking messy and/or cutting off your data.
This option will automatically change the height of the cell and reveal all of its contents. That way you won’t have to change the width of the column.
How to Wrap Text in Google Sheets
1. First, you’ll have to select the cells that you want to wrap.
2. Then, you should left click on the Format tab and choose Text wrapping from the drop-down menu,
You can also click on the Text wrapping button in your toolbar:
3. There you’ll see three different options you can use to wrap text:
- Overflow – Your data will display in the current cell and the cells next to it if they are empty.
- Wrap – Your data will be displayed within the boundaries of the cell by automatically adjusting the height of the cell.
- Clip – Your data will be visible only within the current boundaries of the cell.
Here’s what each of those wrapping options looks like in action:
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.