Microsoft Excel 2016 doesn’tby default, no matter how much text you enter in one cell. This could lead to the content of cells beside being covered, and finally affect the layout of the entire Excel spreadsheet. So how can you wrap text in Excel 2016?
In general, you can use the Wrap Text feature in Home tab of Excel so that the contents will be self-adapting, which means it will fit theand be wrapped automatically. But if you only want to make changes to a few cells, or have some specific requirements, you can also use the [Alt+Enter] to wrap text in Excel manually. It won’t fit the column width automatically but enables you to customize the location to wrap lines.
How to Wrap Text in Excel 2016 Automatically
1. Select all the cells you want to make changes, and go to Home tab.
2. Click Wrap Text in Alignment section.
3. Thus the text in selected cells will be wrapped automatically.
How to Wrap Text in Excel 2016 Manually
1. Place the cursor at the place you want to wrap the text and press [Alt+Enter].
2. The text after the cursor will be assigned to the next line in the cell.
Using Find and Replace to Wrap Text in Batch
1. In addition to above methods, you can also wrap text using Find and Replace. But before that you must add some symbols as the separator between the text of two lines, such as commas. Then select all the cells you want to wrap text.
2. Press [Ctrl+H] to open the Find and Replace window. Enter “,” in Find what, and press [Ctrl+J] in Replace with.
3. Hit Replace All and all the selected cells will be wrapped automatically. If you can’t see the text in the second line, just double click the cells to display the full content.