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: Sort Direction Choices

Sunday, August 28th, 2011 by | Filed Under: MS Excel, MS Office Help

Excel users know the advantages of the sort feature when it comes to taking large amounts of data and putting it in some sort of order.

By default, when you run a sort it works from top to bottom. For example here’s a set of data that we would sort top to bottom.


Sets of data are put in rows and we then sort we have it use the data in a particular column to decide what goes where.

However… is your data always set up this way?

Mostly mine is but not always. I’ve even worked with a few people who just by the way they think will put things the other way like this:


A “set” of data will be placed in a single column making our default sort useless.

The logical question pertains to how exactly we’re going to sort the data when things are arranged this way.

You could transpose your data, but wouldn’t it be better to just be able to sort it the way it is?

If this is your data, then I’m sure that you’d like the second option better, so let’s take a look at how to make Excel sort from left to right.

You’ll begin the same as always by selecting your data.

At this point we’re off to the Data tab / Sort button.

When the Sort dialog box opens click the Option button.


When the Sort Options dialog opens simply choose the sort direction of left to right.


Click OK.

Now that you’re back in the Sort dialog box you can make all the usual choices about which fields to sort and in what direction.

That’s all there is to it.

Set up your data in whatever manner makes most sense to you because Excel can sort it in either direction.

~ April

Tags: ,

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