Go to the Home tab > Alignment group, and click the Wrap Text button: To force a lengthy text string to appear on multiple lines, select the cell(s) that you want to format, and turn on the Excel text wrap feature by using one of the following methods. The following screenshot shows how wrapped text looks like in Excel: In addition, it will help you keep the column width consistent throughout the entire worksheet. This will allow you to avoid the "truncated column" effect, make the text easier to read and better fit for printing. "Wrapping text" means displaying the cell contents on multiple lines, rather than one long line. The Excel wrap text feature can help you fully display longer text in a cell without it overflowing to other cells. If an adjacent cell to the right contains any data, a text string is cut off at the cell border.If columns to the right are empty, a long text string extends over the cell border into those columns.
When the data input in a cell is too large fit in it, one of the following two things happens: Excel wrap text not working - reasons and solutions.
Primarily, Microsoft Excel is designed to calculate and manipulate numbers. You will also learn the most common reasons for Excel wrap text not working and how to fix it. This tutorial shows how to wrap text in a cell automatically and how to insert a line break manually.