Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

MS Excel Cell Alignment

Friday, November 19th, 2004 by | Filed Under: MS Excel

MS Excel Cell Alignment

Ok, so now that we all know what cell alignment is and why we should all know how to control it, let’s get to the actual aligning.

The first thing you need to do is to select the cell(s) that you want to format. You can select a single cell, highlight a group of cells, select entire row(s) / column(s) or the entire worksheet. It’s all about meeting your needs.

Once you have your cell(s) selected you’re ready to choose your cell alignment.

In Excel 97 or 2000 you should right click and find the Format Cells choice from the menu.

Now go to the Alignment tab.


In the Text Alignment section you’re looking for two different things.

The first is the Horizontal alignment list. This is your everyday text alignment (left, centered, right, justified… you get the idea).

Below that is the Vertical alignment list. This is the placement of the text at the top, bottom, middle or justified between the top and bottom of the cell.

Make your choices and click OK.

If you’re using Excel XP (2002) then you’ll find cell alignment to be slightly different.

The first step is the same. Highlight the cell(s) that need the alignment changed.

Next you should right click over the selected cell(s).

The menu that comes up will contain Cell Alignment as a choice.

When you move your mouse pointer to it you should see something like this:


This submenu let’s you choose alignment both directions at the same time via the pictures.

Find the alignment that you’re looking for and choose it.

The menu will close and the cells will be aligned as you chose.

That’s all there is to it!

You too can have beautiful, well set up Excel worksheets!

~ April

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive