table with Excel for processing, to form a cell to wrap text in operation, using conventional methods of pressing the Enter key, the focus will shift to the next cell, then how to implement automatic text for them? The following describes three common methods for everyone.

Skills 1: Set the cell wrap

first select the required text for the cell lines, right-click and select "Format Cells" Open "Format Cells" window (Figure 1), switch to the "Alignment" tab page, the "text control "under the" Wrap "check box before. Back to Excel using the mouse to adjust the cell size, the text will automatically wrap at the same time.

Figure 1 Excel set to automatically wrap

In addition, the cell can also be manually entered text wrap, just press Alt + Enter key combination can be. Cells that have entered the text, we can also use this method to change the cursor line.

Skills II: within the range of cells wrap

to turn into a long line of the paragraph and line breaks within the designated areas, such as the contents of cell A1 is very long, it needs to be displayed in A1: D4 between, you can first select the region A1: D4 (due to text in A1, so A1 started constituency should start operation), were selected to implement the menu "Edit ¡ú Fill ¡ú content rearrangement" command is the contents of cell A1 on the distribution in the A1: D4 region ( Figure 2). This method is particularly suitable for multiple cells form in the comments.

Figure 2 Excel Fill command

Skills 3: Magical text box to achieve wrap

right-click the Excel toolbar, select "Drawing" bring up the Drawing toolbar, click the Drawing toolbar "text box" button, in order to form the text box border and grid lines overlap, press and hold Alt key while dragging a region worksheet mouse into the text box, insert a text box so that any input text, and indirectly for text wrapping (Figure 3).

Figure 3 Excel text box