Friday, September 14, 2012

How Do I Vertically Center in Excel?


Instructions
1. Type some text into a cell. Keep the cursor on this cell.
2. Select 'Format' from the top menu bar. The top menu bar includes all the commands.
3. Select 'Cells' from the drop-down menu.
4. Select the 'Alignment' tab from the 'Format Cells' menu that pops up. The alignment tab sits between the 'Number' and 'Font options
5. Select 'Vertical' from the 'Text Alignment' menu. Look for the 'vertical' option right below the 'horizontal' option.
6. Select the vertical alignment position you want for your text. For instance, when you click the 'vertical' option, a drop-down list will show four options: Top, Center, Bottom and Justify. If you want your text to rest along the top of the cell, click 'top. If you want the text to align in the very center of the cell and have a slight margin around all the edges, select 'center.' If you want the text to vertically along the bottom of the cell, select 'bottom.' If you want to distribute the text evenly throughout the cell, select 'justify.
7. Click the 'OK' button and save your preferences.

Blogger news