Last Updated on October 31, 2023 by Jake Sheridan
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.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize