How Excel typesetting Excel typesetting skills

Excel tables are no doubt artifacts of processing data, but when you enter too long text in a cell, typography looks pretty ugly. This is a problem that has to be dealt with in this age of visual effects. So how does Excel compose? The following small series to share an Excel typesetting skills.

1, with Excel to open a long text worksheet, as shown in the figure, we now want to A1 cell text content in typesetting. Move the mouse over the right edge of the column a cell, and when the pointer turns into a double-headed arrow, press the mouse and drag to the right to give a column of cells a proper width.

2. We now select A1 and A2 cells, then switch to the Start tab, and click the Center button in the Alignment group to align the text horizontally.

3. Now, we click the Wrap button in the alignment group to let us see all of the contents of the A1 cell.

4, OK, what we need to do now is to adjust the vertical alignment of the A1 cell so that the line spacing between the text can be increased and it looks more comfortable. Select A1 cell, and then press the "ctrl+1" key combination.

5, a "Format Cells" dialog box appears, select the Alignment tab, and then click the button on the right side of the vertical Align Drop-down box, select the Distribute alignment option, and finally click the OK button.

6, return to the worksheet, we will be the mouse to navigate to a column of the bottom line, when the cursor into a double-headed arrow when the mouse down and drag down, you can see, we increase the row height of the cell line will automatically adjust, the effect is as follows.

Through the above tips can be perfect to solve the problem of Excel typesetting, there is a need for friends can refer to.

This article is the network teaching base original, reprint please specify: http://www.studynb1.com/excel/254.html