How to SORT Data in Excel | 7 Tips

Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes and even custom sorting configurations. In this video, I walk you through 7 major SORT function tips and procedures. We look at how to ensure the data is ready to sort, selecting the appropriate sorting range, and making sure there are no blank rows or columns.
Then we sort in Excel by one column, multiple columns, by color, by date, custom sorting, and also sorting mixed data, ensuring that if we have numbers and numbers stored as text, we can correct that and still sort the data properly.
Chapters:
00:00 Introduction
00:46 Check your data
02:05 Sort by one column
04:31 Sort by multiple columns
06:47 Sort by color
09:03 Sort by month
09:59 Custom sort
12:24 Sort mixed data
16:11 Closing remarks
Identify Numbers stored as Text in Excel:
• Excel - 5 easy ways to...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZbin keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@paulpiscopo9671]

Best instructor Very explainfull in short time. Clear speech. Love to learn from you.

[@ChrisMenardTraining]

Thank you! I appreciate the positive feedback.

[@manarlabidi6448]

thank you ! Smooth, practical clear, and straight to the point

[@ChrisMenardTraining]

You are welcome.

[@user-kw7gv4fj8x]

this is awesome thank you so much clear speech, concise explanation, assumes that the audience is smart enough to understand and gets to the point, knows what level people are at in general, not condescending but super up to date information and very easy to listen to. I'm watching this to get warmed up for employment. Thank you very very much for the help

[@danielle7397]

Thank you so very much for this. I could not figure out why sorting was not working as it should and low and behold I have spacing columns that were blank, deleted then and PRESTO !! Big thumbs up

[@cathychoi6959]

simply amazing! easy to follow!, thanks Chris!

[@ChrisMenardTraining]

My pleasure!

[@SoonThieu]

a wonderful tips. Your explain is easy to follow. Others go to fast and make people get lost and get confused. Thanks Master

[@tutsecret499]

Thank you Mr. "Tips"

[@caroleo5020]

Thank you for this sorting video. It is helpful.

[@liraazelleinalisan6714]

I didn’t skip ads. You deserve more followers!

[@ChrisMenardTraining]

LOL. Thanks, Lira.

[@lephuong7443]

thank you this is super helpful

[@kristen7339]

This solved exactly the issue I was having! Thank you!

[@ChrisMenardTraining]

Glad to help.

[@ana-mariamehedinti6850]

Thank you! absolutely amazing

[@ChrisMenardTraining]

Thanks, Ana-Maria.

[@Will.Tru8]

Thank you so much for this! Your Chanel deserves more subs for sure! Liked, subscribed and rang the bell.

[@ChrisMenardTraining]

Awesome. I appreciate it.

[@ritadinapli2451]

Brilliant!!! Super helpful!!

[@ChrisMenardTraining]

Thank you!

[@antoniogiliberti6351]

Thank you!! Awesome

[@ChrisMenardTraining]

You're welcome!

[@barrywalker1288]

Brilliant

[@ChrisMenardTraining]

Thank you.

[@rambaile8398]

Thanks for these tips

[@ChrisMenardTraining]

You bet!

[@leojablonski2309]

Just the guy I was looking for....

[@ChrisMenardTraining]

Thank you!

[@tutsecret499]

Mee too!!!

[@lynelljansen8057]

thank you!!!

[@ChrisMenardTraining]

You're welcome!

[@Mackandal-]

Thank you💯 just Subscribed!

[@ChrisMenardTraining]

Awesome, thank you!

[@OwenDawson]

great video thank you. when i hit ctrl/a it doesn't select the entire data below a certain point. how can i grab the rest of the data? thanks

[@OwenDawson]

figured it out thanks

[@edinfific2576]

I was trying to sort my rows by the values of the resistors in them. The values contained prefixes and decimal points, like 1.5kΩ, 2.2MΩ, 1.5Ω and so on. I still haven't found a way to do it. This was a list generated by an electronic components distributor, containing the list of components I had ordered, but I needed to get more of them and wanted to easily see which values did I skip so far.

[@tutsecret499]

So if I format the mixed number and text into number from ribbon panel isn't the same as multiply by 1 method?

[@tutsecret499]

I wonder if you could provide the data file, if possible. Thank you again.

[@IsItTrueThat]

In the past it seems like if there was, for instance, the number 1 in a cell and I drug the fill handle downward the cells below would fill with sequential numbers. I could while still holding the mouse button hit the Shift key (or maybe it was Control) and it would toggle between copying the #1 all the way down or filling 1,2,3,4 etc. Am I remembering wrong? It's frustrating not having that feature.

[@ChrisMenardTraining]

Hello, Jeff. If you type 1 in A1, and autofill down, it will keep doing the number 1. If you want the 2 in A2, and 3 in A3, you can either hold down CTRL and Autofill or use the tip I show around 2:30 in this video on AutoFill kzbin.info/www/bejne/hpeXfqejbpaEqck I hope this helps.

[@IsItTrueThat]

@@ChrisMenardTraining Thanks, Chris. Such good information so succinctly.

[@Robert_512]

I'm using this formula on a project right now =Sortby($B$5:$C$9,Row(B5:B9),-1) because the Exec Team decided they wanted the 72 individual graphs to be ranked from 5 to 1 instead of 1 to 5 🤯

[@ChrisMenardTraining]

Love it. That is a GREAT function! Thanks, Robert.

[@Rickycam111]

Is there a way to sort "word" data by how many times it's repeated. i.e Texas Texas Texas Arkansas. Can I sort it by how many times Texas is repeated

[@ChrisMenardTraining]

I would create a Pivottable and Count State. Sort largest to smallest. That would work.

[@debbierichards3227]

Help! Working on a budget. Sorting by date works perfectly UNTIL I choose it as the 2nd sort field. If I sort first by type of payment (text) and date SECOND, suddenly 9/4/23 comes AFTER 9/30/23. If I sort only by the date column, they sort as they should. Why?

[@ChrisMenardTraining]

send me the file. Nothing sensitive or confidential. Just make a test file if needed. Any chance when you do date as the 2nd field, you are sorting Newest to Oldest? That would explain what is happening.

[@debbierichards3227]

@@ChrisMenardTraining Thanks Chris. I am sorting newest to oldest or oldest to newest in the 2nd field and A-Z in the first field. I created a test field, but I don't know how to send it to you.

[@gregsdoodles4547]

I just wish we could sort on a protected sheet. There's an option to allow sorting, but it still won't allow it...that needs to be fixed

[@agustinacorreaarcecox1477]

it doesn't work... if i want to sort the date ( i have a lot of date( mm/dd/yyy) that i have all mixed up from different years) i cannot sort in the way that you are showing. it keeps almost all the date mixed it .

[@LeonardPaasch]

Make sure your face is on every screen you possibly can, lol

[@ChrisMenardTraining]

I do. :-)