SEARCH

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.

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.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 06/20/07

Comments (2)

  1. janet

    Excel 2007…….. How do I change the column width from the standard to 95 pixels? Help! NJPrayerroom@yahoo.com

  2. shawn

    How do i Insert the column heading for each up and down column?

Enter Your Email Here to Get Access for Free:

Go check your email!