Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2007

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 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.

Print this tip.

- Subscribe!

Search the Site: