How to get Excel to wrap lines

Excel processing data is easy to know, you can change lines within its cell is slightly inconvenient, I wonder if you have also encountered such problems? By groping, the following four methods can be easily implemented within the cell of the automatic line wrapping.

Enter data at any time to wrap

The user will be able to change lines when entering data, as long as it is easily implemented by Alt+enter key combinations. This method also causes the cells that you have entered to wrap at the cursor.

Line wrap within a range of cells

Converts a long line into a paragraph and wraps the line within the specified range. For example: A10 content is very long, want to show it in column A to C column, step is: Select the area a10:c12 (first select A10), select "edit → fill → content rearrange", A10 content will be distributed in the A10:C12 area. This method is particularly suitable for annotations in tables.

Adjust cell formatting for line wrapping

Select the cells, choose format → cells, click Align in the pop-up dialog box, select the Wrap check box, and then click the OK button.

The skillful use of text box

Click the View menu, and in the Toolbars command, select the Drawing toolbar, click Text Box on the toolbar, and, to ensure that the bounds of the text box coincide with the worksheet gridlines, hold down the ALT key while you insert the text box, and then you can enter the text box.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/