In this tutorial, you will learn how to wrap text in cell in Google Sheets
How To Wrap Text In Cell in Google Sheets
When working with spreadsheets, you may find yourself dealing with lengthy strings of text. These values can be difficult to read for the user, as they may take up too much space or get cut off in the cell.
If this is an issue for you, Google Sheets has an option that allows you to wrap text in a cell. Wrapping text will format a cell such that the values automatically fit within the confines of the cell.
Do note that wrapping text does not affect the actual value of the cell. Text wrapping is purely a formatting option and can be reversed at any time.
In this guide, we will show you how to wrap text in a cell in Google Sheets. We’ll cover how to manually wrap text.
How to Apply Text Wrapping in Google Sheets
Here’s how to apply text wrapping in Google Sheets.
Select the cell or cell range you want to apply the Wrap format to.
In this example, the text values in column A are cut off in the current format of the table. This makes it difficult for the user to skim through the data.
Users will have to click on each cell to read the full text in the formula bar.
Click on the Text Wrapping icon in the toolbar to reveal the dropdown menu.
Select the Wrap option under the dropdown menu.
Your text should now appear as multiple lines. The cell height will be adjusted to make sure that all text is shown.
You may also find the Wrap option under Format > Wrapping > Wrap.
If the text wrapping format makes the cell too narrow, users can drag the edge of the cell to the right to expand the width.
This guide should be everything you need to wrap text in a cell in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.