Change Cell Vertical Alignment

Summary: Move cell data to the top, middle, or bottom.

For visual reasons, it may prove useful to manually vertically align certain cells in aMicrosoft Excel 2007 spreadsheet. While cell data is usually aligned to the bottom of a cell, this can be changed to align cell data to the middle or top of a cell instead.

1. Click on a cell, or select a group of cells.
2. Click the “Home” tab in the ribbon at the top of Excel 2007.
3. In the “Alignment” group, click one of the three vertical alignment buttons as shown to the right. The button with lines near the top will top align the cell; the other buttons will middle align and bottom align the cell respectively.

For example, note the below spreadsheet where the Quarter names have been vertically aligned towards the top.