Excel allows you to wrap text in a cell so that it becomes presentable and easy to read. If the length of the string in your cell is long enough to fit into the cell, it overlaps the content of another cell while writing and is partially visible when we move on from that cell.
The wrap text option of Excel allows the string of a cell to appear in multiple lines within the cell. While wrapping the string in the cell it doesn’t change the format of the text. In this section, we will discuss four different ways to wrap a lengthy string in the Excel cell.
Steps to Wrap Text in Excel:
Using Wrap Text Option in Excel
Write a long string in a cell as you can see in the image below.
Now click on the cell with the lengthy string and from the Home tab, in the Alignment group click on the Wrap Text option.
By default, the text is aligned at the bottom you can align it to the middle of the cell. And you can even adjust the cell size by dragging the borders of the cell.
By Manually Breaking Lengthy Text in a Cell
Double click on the cell with the lengthy string. Now click on the location at the string where you want to break the line.
And then press Alt+Enter, this will break the line from the location where you have clicked.
Using Format Cell Option
Select the cell with the long string that you want to wrap. Right-click on the cell and from the displayed menu you have to click on the Format Cells… option.
In the ‘Format Cells’ window, go to the Alignment tab, and in the ‘Text control’ section you have to check ‘Wrap text’ option. And click on OK.
Using Keyboard Shortcut
Though excel does not have any dedicated shortcut to wrap the long string in the Excel cell. Select the cell with lengthy string and press:
Alt + H + W
So with these methods, you can wrap the long string in the Excel cell to make it properly visible.
Leave a Reply