Subscribe to 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.

| More
This article was originally written on 06/20/07 Tagged with: Microsoft Excel, Microsoft Office

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:


Name:
Email:

Comments (1)

  1. janet

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


Leave a Comment




Leave your friendly comment here.

If you have a computer help question, click here to leave it on the forums instead.

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

Our Friends
Getting Started


About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
mDNSResponder.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
conhost.exe
Dpupdchk.exe Adobe_Updater.exe

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