Sorting in Excel - Basics and Beyond

Learn everything you need to know about sorting in Microsoft Excel. This video is perfect for Excel beginners, but it also will extend your knowledge of sorting beyond the basics. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's the practice file for this video: bit.ly/sortexcel #excel #exceltutorials #microsoft365

[@DemetriPanici]

Sometimes I find that something as basic as this can really set you apart from other people in the work place! Great video

[@JoAnnGooding-ct8bt]

Thanks! Thank you so much this was more than helpful!

[@techteachersandstudents]

Glad it helped! Thanks so much for your kind gift.

[@taharizwan3538]

dude you are lifesaver.

[@bobbiehennessy4636]

Excellent video and it was exactly what it says it is; all about sorting! Clear, concise and right on point! Thanks so much!

[@bskak1940]

Very nice presentatio. I have learnt a new thing.Thanks

[@BenderArts]

Thanks!

[@techteachersandstudents]

Welcome! Thank YOU for your support! Sorry for my delay in saying thanks.

[@BenderArts]

@@techteachersandstudents Wish I had more to support your work! Maybe someday:) TY

[@spec24]

Well, I guess we see what it takes for this guy to reply to his followers.

[@dutjgarang23]

Great video. Basics raise curiosity.

[@simoiyahector-morales3781]

Always appreciate your tutorials

[@peaceandquiet]

Thanks a lot, this helped me very much, so many years I never used excel until now, my mistake and now I am learning.

[@yvonneasomanidansowaa2370]

TOO GOOD, Thank you

[@Gikkou]

Really simple explanation, thank you

[@SARTHAKTHEMAN]

Your tutorials are sick..😁😁😁

[@johnnyandigisi3258]

You are a Legend.

[@e4ezzat]

Amazing info direct to the point👍

[@oleksandrmoskalov3222]

Man, that's the perfect tutorial I've been needed. Great thanks from me to you!

[@penelopebarby5987]

Just that simple step of inserting blank row or column to protect other data CHANGE EVERYTHING - THANKS 🙂

[@markeggenberger4984]

This is very informative. We'll done. Thank you!

[@rumanijain9305]

you are amazinggggg...thank you ....support from India

[@bencrossley4085]

Very clear and helpful. Thank you.

[@srijitm8760]

Really, a great video, I understood the things very easily after seeing your video.

[@dariowirth7956]

Thank you, you helped me out.

[@justbbee]

Extremely helpful! Thanks

[@JustinW007]

Sorting was exactly the key I needed to transform my ability to use Excel.

[@tizmehere492]

This is so simply awesome! Thank you!!!!

[@HTCGT1963]

EXCELLENT VIDEO THANK YOU 👍

[@islamshawqi3823]

Excellent job 😊

[@Alexandra-hy8bp]

Thank you heaps, super clean and helpful video.

[@vincentaldagcuta9283]

The CTRL + A = solved my issues. Damn those small issues/mistakes sometimes complicate things. TY Bro!

[@almoezsaadabi5599]

Really I can't thank you enough. Do you have any videos of how to make charts please

[@Life_is_very_Beautiful]

As splendid as in your other briefs. Thank You. 🙏

[@WezmehGamer]

Appreciate the directness

[@XDShami]

I want to abuse you bro. You are the best solution provider one of the best creators on KZbin

[@elita.23]

Love this!!

[@markpodesta4605]

Thank you.

[@BeksiVlog]

❤❤❤ Thanks for sharing thanks thanks thanks

[@kylegeddis2666]

thank you, this worked

[@MazyHadz]

Thank you so much

[@SinemSimonaTurkish]

thank you. it helped.

[@Dream-ft5ct]

Awesome! easy to understand. Thanks, alto.

[@danabee3775]

Very helpful, thank you! :-)

[@jogindersingh-prem7793]

It would have been excellent video, if he talk slowely, sort pause after one method before proceeding to another. Allowing novice and old learner to catch up and make notes. Very good command of knowledge. Thanks. Joginder

[@techteachersandstudents]

Thank you for your feedback. I will try to do better. In the meantime, you can click the gear symbol in the lower-right corner of the KZbin window and choose Playback Speed to slow down the video a bit.

[@shuaibopeyemi7137]

Thank youuuuuu😊

[@ndelpurg]

always great Many thanks

[@themixchannel1816]

Thanks very much !!!!

[@foxybrown2k11]

Thank you :)

[@laurenbrown667]

Thank you!!

[@markschmid6463]

Always enjoy your videos.

[@neerajallamseti4582]

Sir Ji, I need ur guidance in solving this.. In a sheet, A1, B1, C1 are the three cells. C column will be given by me as input (positive no). B1 = A1 - C1 and so on for B Column A2 = B1 and so on for A column Now, A1 is to be automatically derived, such that "0" comes in A column. Thanks in Advance 😊🙏

[@michaelcourter5432]

Fantastic

[@allisonshimonski9399]

Hi I’m new to your channel and am finding it extremely helpful as I’m working to brush up on my excel skills. I was wondering if you might be willing to do a video on extracting data from reports or other docs/applications. I also believe that data could be then turned into charts/pie charts? Thank you for sharing your knowledge!

[@eng.ashrafemara2294]

Thanks

[@vistron888]

If you only select one cell in the column and select sort a to z. it simply sorts that column and all the other columns stay in the same place. So data gets mixed up.

[@ihsanulkamil1999]

awesome

[@jarjar621]

do we need a specific setup to make sure we dont accidentally sort the column names as well? i kept screwing that up.

[@igors1234]

If I have a 20x10 chart with 200 unrelated to each other numbers and want to sort them from smallest to largest, how do I do that? It would be easy if they were written in one row or one column, but there are 10 rows and 20 columns.

[@Jhallidaybell]

V helpful

[@joshswenson8390]

You mentioned to add a blank row or column to separate the data into another section that doesn't get sorted along with the rest. Well, I have done that accidentally, and now my data won't sort along with the rest -- but I can't find the blank row. How do I group the data together again?

[@Shruti-r1j]

sir plz attach the file for practise in description it's helps a lot

[@techteachersandstudents]

bit.ly/sortexcel

[@moshemaor1731]

Hello, An old simple problem I have in Excel. I have the following Column in Excel: R101, R10, R11, R1, R20, R2 And after sorting, I expect to Get: R1, R10, R101, R11, R2, R20 But I do not. Instead, I get: R1, R10, R101, R11, R2, R20 How can I do it? Thanks. Moshe.

[@rajwvilla]

Hi How to i keep my sort order ? eg i have a table of names and points and copy to another area to sort. I highlight, and choose sort function, and sort per points. Now, the following week i will update this table, and copy to the area mentioned, i go to sort and my sort order has gone. I want to keep that sort order, Any ideas?

[@gokulakannanh2158]

Sir, I worked on file and sorted the data and Saved, Now, How to undo the sorted filter, or how to go back to original position ,

[@tracybuford9243]

I know this has been a minute but I'm just not seeing it. What am I doing wrong if when I click on the name column and A to Z and it puts one of the names above the labels. Like the column labels I have set up.

[@gabecajamarca]

When I try it it says I can’t change part of an array. What does that mean?

[@RuneHansen4300]

What if my sorting is about letters and not numbers? I am using excel 365 and it allows me to sort but only by colors, numbers and that I cant get it to sort alphabethically

[@Sam-oq3ll]

Love Seth Curry

[@andrewlwin9407]

Hello, How to automatically count sorted items?

[@phumzilemanyathi9538]

"To do this, all the merged cells need to be the same size

[@patrycjaw8323]

Did i notice the names of the players not be in alphabetical order when the team was in the harder part of the sort?

[@ZakirK]

how to sort alphanumeric data ?

[@harrysolas2802]

Sorting by date doesn't work on Excel. It ALMOST gets it right. It used to get it right back in the old days. Now, I have to correct it every time. Have others run into this problem?

[@bobwoolcock]

Hmm. Mine doesn't work. I have a dozen rows - but it only sorts 2-12 and leaves the top row as is. ??

[@brianinja]

I try to sort and it says "You can't change part of an array."

[@rirox9196]

👍

[@stevenzahorec6009]

MINE SORTS SEPARATELY EVERYTIME

[@abrarsiddiqui9324]

mujhe ye sakht napasand hai ki mehnat krne waley peechhe hai unhe aise hi thaga jata hai aabhi sarkaar unhe thag rahi hai

[@yrot1123]

this is NOT everything about Excel sorting... you have not talking about row sorting.. or option sorting..

[@abrarsiddiqui9324]

galat hai 55000 khud le rahi ho aur mehnat krne wale ko kewal 5000 kamse kam kuch to sahi karo jisko dekho dhoka dhoka, kam se kam khud 60 per lo aur usey 40 per to do because uski hi to mehnat hai aapka kya hai free me

[@Marlslifeadventures88]

Unclear video

[@stevenzahorec6009]

nothing changes this, and this videos blantant lie that its one click is frustrating

[@pfikurum]

Set the playback speed to 1.15. Thank me later.

[@spec24]

And when Excel is STUPID, and DOES sort your title row with the rest, what then? I'm not sure saying that Excel is smart quite covers it.