Summary: Move cell data to the top, middle, or bottom.
For visual reasons, it may prove useful to manually vertically align certain cells in a Microsoft 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.
Sample Excel 2007 spreadsheet with column headers vertically aligned to the top
Add: Del.icio.us | Digg | Furl | My Yahoo!
Last Modified on: July 22, 2008, at 9:05 A.M. EDT
Return to the Microsoft Excel 2007 page.
Search the Site: