This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Change Cell Vertical Alignment

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



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Change Cell Vertical Alignment.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.