Subscribe to How-To Geek

Recommended: Click Here to Run a Free Scan for Common PC Errors   [Sponsored Link]

Quick Tip: Align Cells in Excel 2007

When you import data into an Excel Spreadsheet it is not always aligned in good proportion to the rest of the document. Here is the quick and easy way to line it up.

After you have imported your data select all columns and rows; choose A hold down your shift key and go over to the end of your data so everything is highlighted.

image

Now right-click on the highlighted fields and from the sub menu choose Format Cells.

 In the Format Cells window click the Alignment tab, choose Center from the drop down box under Horizontal and click OK. 

Now all of the data will align in the center of each cell to make the data more presentable.  This is especially handy when you are printing out the reports.

Mysticgeek is the resident IT expert at How-To Geek and a huge rock music fan. When he's not writing about Microsoft Office, he's probably writing at his personal blog. This article was written on 06/20/07 and tagged with: Microsoft Office

Leave a Comment




Leave your friendly comment here. If you have a computer help question, leave it on the forums instead.

Note: Your comment may not show up immediately on the site.

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.