Excel : Formatting Cells | Text Alignment and Rotation

Formatting Cells: Text Alignment and Rotation

Type of Alignment in Cell :
Horizontal Alignment :
To change horizontal text alignment:
Select the cell(s) you want to modify. Selecting a cell.
Select one of the three horizontal alignment commands on the Home tab. In our example, we'll choose Center Align. Choosing Center Align.
The text will realign. The realigned cell text.

Vertical Alignment :
To change vertical alignment using the Format Cells dialog box:

Select a cell or range of cells.
Choose Format Cells from the menu bar.

(You could also right-click and choose Format Cells from the shortcut menu.)

The Format Cells dialog box opens.
Click the Alignment tab.
Click the Vertical drop-down menu and select a vertical alignment treatment.
Click OK to apply the vertical alignment to the selected cell(s). (0:10 - 7:38)

Click on the link for more Excel Videos :

All Rights Reserved.