This tutorial shows how to wrap text in a cell automatically and how to insert a line break manually. You will also learn the most common reasons for Excel wrap text not working and how to fix it. Show Primarily, Microsoft Excel is designed to calculate and manipulate numbers. However, you may often find yourself in situations when, in addition to numbers, large amounts of text need to be stored in spreadsheets. In case longer text does not fit neatly in a cell, you can of course proceed with the most obvious way and simply make the column wider. However, it's not really an option when you work with a large worksheet that has a lot of data to display. A much better solution is to wrap text that exceeds a column width, and Microsoft Excel provides a couple of ways to do it. This tutorial will introduce you to the Excel wrap text feature and share a few tips to use it wisely. What is wrap text in Excel?When the data input in a cell is too large fit in it, one of the following two things happens:
The screenshot below shows two cases: The Excel wrap text feature can help you fully display longer text in a cell without it overflowing to other cells. "Wrapping text" means displaying the cell contents on multiple lines, rather than one long line. This will allow you to avoid the "truncated column" effect, make the text easier to read and better fit for printing. In addition, it will help you keep the column width consistent throughout the entire worksheet. The following screenshot shows how wrapped text looks like in Excel: How to wrap text in Excel automaticallyTo 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. Method 1. Go to the Home tab > Alignment group, and click the Wrap Text button: Method 2. Press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and then click Format Cells…), switch to the Alignment tab, select the Wrap Text checkbox, and click OK. Compared to the first method, this one takes a couple of extra clicks, but it may save time in case you wish to make a few changes in cell formatting at a time, wrapping text being one of those changes.
Tip. If the Wrap Text checkbox is filled in solid, it indicates that the selected cells have different text wrap settings, i.e. in some cells the data is wrapped, in other cells it is not wrapped. Result. Whichever method you use, the data in the selected cells wraps to fit the column width. If you change the column width, text wrapping will adjust automatically. The following screenshot shows a possible result:
How to unwrap text in ExcelAs you can easily guess, the two methods described above are also used to unwrap text. The fastest way is to select the cell(s) and click the Wrap Text button (Home tab > Alignment group) to toggle text wrapping off. Alternatively, press the Ctrl + 1 shortcut to open the Format Cells dialog and clear the Wrap text checkbox on the Alignment tab. How to insert a line break manuallySometimes you may want to start a new line at a specific position rather than have lengthy text wrap automatically. To enter a line break manually, just do the following:
Result. Inserting a manual line break turns on the Wrap Text option automatically. However, the line breaks entered manually will stick in place when the column is made wider. If you turn off text wrapping, the data displays in one line in a cell, but the inserted line breaks are visible in the formula bar. The following screenshot demonstrates both scenarios (a line break in entered after the word "owl"):
Excel wrap text not workingAs one of the most often used features in Excel, Warp Text was designed as simple as possible and you will hardly have any problems using it in your worksheets. If text wrapping does not work as expected, check out the following troubleshooting tips. 1. Fixed row height If not all wrapped text is visible in a cell, most likely the row is set to a certain height. To fix this, select the problematic cell, go to the Home tab > Cells group, and click Format > AutoFit Row Height: Or, you can set a specific row height by clicking Row Height… and then typing the desired number in the Row height box. A fixed row height comes in especially handy to control the way the table headers are displayed. 2. Merged cells Excel's Wrap Text does not work for merged cells, so you will have to decide which feature is more important for a particular sheet. If you keep the merged cells, you can display the full text by making the column(s) wider. If you opt for Wrap Text, then unmerge cells by clicking the Merge & Center button on the Home tab, in the Alignment group: 3. The cell is wide enough to display its valueIf you try to wrap a cell(s) that is already wide enough to display its contents, nothing will happen, even if later on the column is resized and becomes too narrow to fit longer entries. To force the text to wrap, toggle the Excel Wrap Text button off and on again. 4. Horizontal alignment is set to FillSometimes, people want to prevent text from spilling over into next cells. This can be done by setting Fill for horizontal alignment. If later on you enable the Wrap Text feature for such cells, nothing will change - text will still be truncated at the cell's boundary. To resolve the issue, remove the Fill alignment:
This is how you wrap text in Excel to display longer text on multiple lines. I thank you for reading and hope to see you on our blog next week! You may also be interested inView Discussion Improve Article Save Article Like Article By default, when you create a new workbook in Excel, the row height and column width for all cells are set to the same value. If the text you enter in a spreadsheet cell is too long and the next column has data, it either spills over into the next blank cell or is truncated by the data in the adjacent cells. Although you can widen the columns, there is a better way to present your data in an easily readable fashion if you have a lot of them. There are many methods to fit the long text. So, in this article, we will discuss these methods one by one in detail. Increase the width of the columnIncreasing the column width will give you more text space, but it will also make every cell in the column wider. The column width is set to 8.43 standard font characters by default, however, it can be increased to 250. So to do this follow the given steps: Step 1: Fill in the column with long text. Step 2: Now place the mouse cursor on the vertical line to the right of the first letter in the top column. If you typed something in cell A4, for example, point to the vertical line between column letters “A” and “B” The cursor will change to a “+” symbol with arrows on both sides. Step 3: When you double-click a line, the column will automatically resize to fit the long content. You can also manually resize the line by dragging it. Note: To modify the height of the row above the border, click on the border and drag it up or down. The changing height is displayed in a popup as you drag the pointer. Here’s a video demonstration of the procedure described above: https://media.geeksforgeeks.org/wp-content/uploads/20220117122949/Book1---Excel-2022-01-17-12-28-15.mp4 If the text in a label cell is too long to fit in the cell, you can use the AutoFit tool in Microsoft Excel to lengthen the cell to fit the contents. However, this may result in an excessive amount of white space in the rest of the row or column. Autofit Column width increases the column width to accommodate the column’s greatest value. So to do this follow the given steps: Step 1: Choose a column or a set of columns to work with. Step 2: Select Format -> AutoFit Column Width from the Cells category on the Home tab. Step 3: Double-click the AutoFit Column Width option. Shortcut: Press Alt + H, then O, and finally I. Here’s a video demonstration of the procedure described above. https://media.geeksforgeeks.org/wp-content/uploads/20220117122551/method-2.mp4 If the text is too long to fit in the column, but you don’t want it to flow into adjacent cells, you can use the Wrap Text to Fit option to accommodate it. The Word Wrap tool in Excel allows you to wrap text across several horizontal lines while also increasing the height of all cells in that row. So to do this follow the given steps: Step 1: Choose the cells where you want to wrap text. Step 2: Check “Wrap Text” under the “Alignment” option. Step 3: Double-click the wrap text symbol. Note: The data in the cell wraps to fit the column width, thus if the column width changes, the data wrapping changes as well. Here’s a video demonstration of the procedure described above: https://media.geeksforgeeks.org/wp-content/uploads/20220117122622/method-3.mp4 Merging cells allows text to span many column widths in a single cell, although this option is only available if the adjacent cells are blank. So to do this follow the given steps: Step 1: Drag your mouse over the text-filled cell and any number of blank cells on the same row. Step 2: Check “Merge Cells” under the “Alignment” tab. Step 3: Double-click the Merge Cells option. Here’s a video demonstration of the procedure described above: https://media.geeksforgeeks.org/wp-content/uploads/20220117122649/method-4.mp4 |