How do I wrap an Excel table?

Friends who often use office in the Office may be more concerned about Excel, for some novice officer, in Word editing text, line-wrapping is not a problem! However, when you go to Excel tables and edit some of the longer text in the cell, you are having trouble getting the line wrapped.

When you enter content in a cell, you press ENTER, but you find the focus moves to the next cell, as you would normally need to change rows. You want to display a paragraph of text in several spanned cells, and then you need to merge the cells, and then you have to format the text alignment inside, and it's very tedious. After a few groping and learning, I summed up the following several methods, you can solve the problem of text wrapping in the table.

Batch cell Wrap Line

We can often see some forms of mailing address the mailing address in the column shows only the first half, and the later part is hidden in the cell, you must either drag the right border of the cell or double-click the right border of the header to display the full.

Similar to the above situation, when there is already a large number of data in the table, but because there is no time to automatically change the line, our most common method is to bulk adjust the cell format.

First select all of the range of cells to which you want to apply the wrap (no matter whether the data is already in the range or not entered), select the cell command on the Format menu, and in the dialog box that pops up, click the Align tab, select the Word wrap check box, and click OK. This way, cells that already have data are automatically wrapped, and cells that have no data wrap automatically when you enter data.

Temporary input at any time to change line

Sometimes we add a comment bar to the back of a table where we might want to write more comment text, and one line may not be able to fit. In this case, if only some of the cells temporarily need to wrap, then you do not have to set the cell to implement automatic line wrapping. As long as you need to change lines in the input, temporarily press the Ait+enter key to achieve automatic line wrapping. This method also applies to cells that have been entered, which enables wrapping of the contents of the cell at the cursor.

Implement word wrapping across regions

There are times when the comments on a cell in a table can be very long, if the content is filled in only one cell, whether or not wrapping, the entire table will look very uncoordinated, then we need to take the table across the row across the column annotation.

This approach is actually to display a paragraph of text that wraps across several cells in a range of tables. For example, the contents of a memo cell are very long and we intend to display it in a rectangular area of a few cells, at which point we need to turn a long line into a paragraph and wrap it in a specified range. To do this, we only need to select this rectangular area, and then select the "Fill-content rearrangement" command on the Edit menu, and the contents of the cell will be distributed within the area of the lost macro we delimit.

Free text box in table

The above method is always limited by the table row. In order to enter text more freely, we can also choose how to place a text box in the table. The text box is attached to the table so that if the position is not appropriate, it is also convenient for us to reposition the annotation text box at random. Click the View menu, and in the Toolbars command, select the Drawing toolbar, click the Text Box button 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 text in the text box.