Articles | Photoshop blog | Photography blog | about me | e-mail

Helen Bradley - MS Office Tips, Tricks and Tutorials

I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag,, Winplanet and Sydney Morning Herald.

Tuesday, July 17, 2007

Align data in Excel

When you make an Excel row much deeper by dragging on the marker below the cell number you'll often find the cell entry hugs the bottom of the cell. If you'd prefer to have it centered in the cell you won't find the Center button works to do anything more than center the cell entry horizontally.

To center it vertically use the Format, Cell dialog and choose the Alignment tab. From the Vertical list choose Center and the entry will be aligned evenly between the top and bottom cell margins.

Labels: ,

Add to Technorati Favorites