Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in Excel 2007

Quickly sort data Alphabetically and Numerically in Excel 2007. This tutorial shows you how to very quickly sort large lists of data to better view and understand that data. In this example, you will see how to order an employee sick-day list to see who was sick the most and least. This quick tip shows you how to order your data in only a few seconds and is invaluable to those who work with large amounts of data daily.

Have a great day!

[xcherryjonesx]

i'm a visual learner, so i learned it quickly and had a good chuckle at the names you used. love the Office!

[Debelebekele]

Thanks for the advice my friend it helps a lot. No one in YouTube saying the need this much easy and fast! Many thanks

[javtimestwo]

This is awesome. I really think that it is much more efficient to use one cell for the complete name instead of two. Do you agree? Great way to sort and very fast to sort alphabetically.

[ringfinder]

What a BIG help!! I know nothing about Excel. But with videos such as yours, I am learning. Thanks So Much. The first time I tried to rearrange the files some of them moved and some did not and I had already saved the file. I had to re-due the whole darn thing. Thanks Again from a Excel novice!

[TeachExcel]

Glad you like it! If you need anything else, let us know.

[eff]

THIS IS JUST SUPERB! CONGRATULATIONS! i like the fact that it was short and concise!

[ironlyon]

Thank you, I was in a rush and couldn't remember how to do it. You saved the day.

[bigmichael]

Bravo! You just saved me 10 mins of wandering on Excel. Thanks

[ahmadhazmi]

Lol creed with most sick days.. I'm not surprised!

[hemilovexoxo]

Thank you!!! This just made my homework so easy for me.

[Hadleyrb]

Excellent tutorial. Thank you. Great choice of material for the example, too.

[DAVIE]

Thanx bro, ..this has really helped me a lot.. GOD Bless you!

[waltzingmathile]

LOL! you're using people's name from the office. I love it! thanks for the tutorial :)

[enginyilmaz]

Does Dwight know you have him on record? 

[KamalHyman]

Thankn you sir, saved me a lot of time and effort

[milkyrpz]

thnx alot you are helping me much thnx

[crystaleward]

Strait to the point and easy to follow 👌🏽 👍🏽

[kookykrumbs]

Thanks soooo much, this was helpful!

[laxmiupadhyay]

GOOD ..  THANK YOU VERY MUCH
IT SAVED MY TIME

[BigDipLip]

Whats with the office cast being on the table?