The cells in an Excel sheet come with a particular size of rows and columns. The cells come with row height of 15 points (20 pixels) and column width of 8.43 points (64 pixels). So when you have a long text data in a cell, it overflows out of the cell into other cells. But you can make the texts fit nicely into one single cell if you do what is called wrap text in excel.
The cell rows or columns can be dragged to increase the height or width to fit the length of the text data or you can simply wrap the text.
In this post, you’ll learn five different ways to wrap text data to fit in only one cell.
What is ‘Wrap Text’ in Excel?
Wrap text is a feature in Excel that allows texts to appear in multiple lines in just one cell. It adjusts the size of the cell’s row height to enable the user to view all the text in that cell.
Here is a simple illustration below:
Here, the text is in cell A1 and it extends down to cell F1. If you select cell B1, it will display an empty cell. This means that you can enter any text data into cell B1.
And if you enter another text data in cell B1, all the text in cell A1 will no longer be visible. See below:
To fix this, you do what is called ‘Wrap Text’ in Excel. You can wrap text automatically from the ribbon or it can be done manually.
#1. Wrapping Text from the Ribbon in Excel
The Wrap Text command is available in the Home tab of the ribbon and it automatically wraps the text once you click on the command.
To wrap text automatically,
1. Select the cell or range of cells with the text in the worksheet.
2. Go to Home tab and click on ‘Wrap Text’ command in the Alignment group.
Now you will see all the text data in the cell. Excel automatically expands the row height to fit the text data.
You will need to adjust the column width to the desired size.
#2. Using the Format Cells Dialog Box
In the Format Cells dialog box, you will find all the formatting options that can be applied to a cell in an excel worksheet.
This method is very useful when you have to apply various formats to the cells.
To do this,
1. Select the cell and right-click on it
2. Click on ‘Format Cells’ to open the dialog box
3. Click on ‘Alignment’ tab and check the ‘Wrap Text’ checkbox below
4. Click Ok
#3. Using Keyboard Shortcut
You can also wrap texts using keyboard shortcuts in Excel. All you have to do is to select the cells you wish to apply wrap text and press:
Alt + H + W
#4. By Adjusting Row Height or Column width
The row height or column width of the cell can be increased or decreased to enable all the wrapped text data be visible in the cell. You can either drag the border separator manually or auto-adjust to specify the size of the row height or column width that you want.
To do this,
1. Select the cell that you want to wrap text
2. Go to Home tab and click on the ‘Format’ command dropdown arrow under the Cells group. You can also right-click on the cell and select ‘Format Cells‘.
3. Select ‘AutoFit Row Height’ from the dropdown menu. This will automatically adjust the row height to fit all the text in the cell.
Select ‘Row Height’ to specify the exact row height needed by typing the row height into the box.
#5. Wrap Text in Excel Manually Using Line Breaks
When you wrap a text, Excel will automatically format the text with line breaks based on the length of the text data and the width of the cell. However, you can start a new line break from any specific point in the cell.
To apply line breaks,
1. Select the cell and double-click on it.
Select the cell and press F2
2. Then click on the point where you want the line break to be in the cell and press Alt + Enter. This will move the text down to the next line.
It should be noted that,
- The Wrap Text button is a toggle button. This means that once you click on the button, it will wrap the text immediately and if you click on it again, it will unwrap the text.
- When you wrap the text, it fits into the size of the row height or column width. If you adjust the row height or column width, Excel will adjust the wrapped text automatically.
- If the wrapped text is not visible, it may be because the size of the row height is too small to accommodate the wrapped text, or the text is in a cell range that has been merged.
Which of these methods do you find most convenient and why? I would love to hear your thoughts in the comment section.