After you select the cell or cells whose contents you want to vertically align, open the Format menu and select Cells to open the Format Cells dialog box.
On the Format Cells dialog box Alignment tab, click the Vertical field down arrow and scroll through the options: Top, Center, Bottom, Justify, and Distributed.
After you make your selection, click OK.
The data is vertically aligned within the cell.
INTRODUCTION
In addition to aligning the data in your cells horizontally, you can align your cell data in a vertical format. Perhaps you want the data in your cells to align to the top of the cell, bottom of the cell, or center of the cell, or maybe you want to justify it within the cell. Cell data defaults to the bottom of the cell, but you can change this according to the look you want.
TIP
Justifying Cell Text
If you selected the Justify option in step 3, you must have enough text in the cell to fill from the top to the bottom of the cell, for example, a sentence. The text will automatically wrap to fit the cell.
