How-To Geek
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.

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.

|
Subscribe |
Daily Email Updates |
|
You can get our how-to articles in your inbox each day for free. Just enter your email below: |
- By Mysticgeek on 06/20/07
Comments (2)
Comments are closed on this post.
If you'd like to continue the discussion on this topic, you can do so at our forum.
Go to the Forum
Excel 2007…….. How do I change the column width from the standard to 95 pixels? Help! NJPrayerroom@yahoo.com
How do i Insert the column heading for each up and down column?