How to Wrap Text in Excel 2016 Automatically or Manually

Date:2019-9-10 Author:Cordelia

Microsoft Excel 2016 doesn’t wrap text by 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 the column width and 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 shortcuts [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.

How to Wrap Text in Excel 2016 Automatically or Manually

2. Click Wrap Text in Alignment section.

How to Wrap Text in Excel 2016 Automatically or Manually

3. Thus the text in selected cells will be wrapped automatically.

How to Wrap Text in Excel 2016 Automatically or Manually

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].

How to Wrap Text in Excel 2016 Automatically or Manually

2. The text after the cursor will be assigned to the next line in the cell.

How to Wrap Text in Excel 2016 Automatically or Manually

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.

How to Wrap Text in Excel 2016 Automatically or Manually

2. Press [Ctrl+H] to open the Find and Replace window. Enter “,” in Find what, and press [Ctrl+J] in Replace with.

How to Wrap Text in Excel 2016 Automatically or Manually

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.

How to Wrap Text in Excel 2016 Automatically or Manually
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *