Each cell has 8.11 (80 pixels) in width in a normal Excel sheet and 14.40 (24 pixels) in height. If you want to enter the long text data in the cell, you can easily increase the width of a cell so it can fit the data length.
Wrap the text will be a better option to increase the height of the row so that the data fits within the cell easily! In this post, we will walk you through THREE ways as to how to wrap text in Excel, to fit the data inside the cell.
What is Wrap Text?
If your text is too long and does not fit within the cell, Wrap Text will automatically adjust the entire text within a single cell.
The data inside the cell will not change and no line break characters will be inserted. It will only appear to be formatted on multiple lines. The below example shows that the text enters in B3 cell and it will extend further and the width of the cell well past to the right.
Once you applied wrap text on the above example, it will appear as per the below image. You will notice that the entire text adjusted within a single cell, however, the height of the cell automatically changed.
Wrap Text from Ribbon
This is the simplest and one of the quickest ways to wrap the text in Excel. You need to follow the below instructions to perform it.
Step 1: Go to the Home Ribbon
Step 2: Select the cell that you want to format (in our case: B3)
Step 3: Just click on “Wrap Text” found in the alignment section of the ribbon.
That’s it! You will be able to wrap the extra-long text into multiple lines so you can easily see it.
- Text within the cell wraps to fit the column width. Though, if you change the column width, wrapping text will adjust automatically.
- If all wrapped text is not visible to you, it may be because the row is set to a specific height or the text is in a range of cells that has been merged.
Wrap Text by applying Keyboard Shortcut
Keyboard shortcuts are certainly a quicker way and always helpful to perform the action instantly. You can apply the below shortcut to wrap the text in Excel.
Shortcut: Alt + H + W
Wrap Text through the dialog box
You can also wrap the text through the dialog box. To open the dialog box, right-click on the cells and then choose “Format Cells,” alternatively you can use the “Ctrl + 1” keyboard shortcut.
The format cells dialog box contains all formatting options that you can apply to a cell in your worksheet, including the wrap text option.
Step 1: Go to the Alignment tab in the menu
Step 2: Check the Wrap text option in the Text control section
Step 3: Press the OK button.
Adjust the row height to make all wrapped text visible
If the row height does not properly adjust to fit all the text within the cell, then you need to adjust it manually. Just click and drag the row. There is an easy option as well to auto-adjust the row height. Just follow these below steps:
- Select the cell or range for which you want to adjust the row height.
- On the Home tab, in the Cells group, click Format.
- Under Cell Size, do one of the following:
If you want to set the height on auto mode, click AutoFit Row Height.
If you want to specify a row height, click Row Height, and then type the row height that you want in the Row height box.
Enter a line break to Wrap Text
You can also add a line break to wrap the text, manually. Just place the cursor at the point within the text where you want to add a line break, and then hold the Alt key and press Enter.
Alternatively, you can double click the cell in which you want to enter a line break and point the cursor from where you want the line break and then press enter.
This will add a line break into your text and the data will appear on multiple lines within the sheet.
Note: You can press F2 to select the cell, and then move the cursor to the specific point to press enter.
Wrapping text is a great tool to style your worksheet and to make it more readable to the user.
You can perform any of the above options at ease. Let me know in the comment section below, which is your favorite method.