Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/sort-unsort-file

[@GrahamandKarenStewart]

I love you so much! I have been developing in Excel for 20 years. But I always learn something new when I watch your videos. 🥰

[@lillyniki5480]

Sorting by color - this is what I need but didn't know that it exists. Thank you! I will impress my boss next week, when checking our datas (only the red once need a closer look).

[@AnisurRahman-h9k]

Leila, your tutorials are very helpful and teaching method is special. Thanks a lot

[@AndrewFroude]

Thank you, Leila. I was not aware that you could sort a data set by selecting sort on a cell within an unselected data set so that your data records stay together and not sort one column in isolation of the other columns in the data set (which is a nightmare!). Thanks again. Keep up the great work.

[@serch7352]

As always bringing Light to my excel darkness, thank you Leila .

[@LeilaGharani]

Let there be light :)

[@Mr.Brahim-AB]

Me too. Thank you Leila 🤗

[@HamayonKhan-g3m]

Thank you so much. You have been outstanding. In fact, I want you to upload many excel files for each lecture you give. It will help learners practice using different data and that would be much helpful and we will learn a lot and will be able to practice all you explained during each lecture. Once again thanks a lot!

[@alexandrkrav]

Dear Leila. Thank you VERY much, this video helped me to find "SORTING" solution which I search 2 days. Please continue your Video Lessons. Your Explanation helps a lot to find "END of TONES" in deep Sea of EXCEL World. Thanks one more time. Alexander K.

[@LeilaGharani]

Glad it helped, Alexander!

[@sharjeelmazhar-y9e]

great work leila specially your brief, clear, concise speaking english makes possible to understand quickly.

[@LeilaGharani]

Thank you!

[@sirirvasist4853]

Hi!!! Your videos are really helpful for students starting out their journey in corporate offices. Love from INDIA

[@LeilaGharani]

I'm glad to hear that!

[@aminanwar9537]

this video is very helpful for me. this save my 3 to 4 hours of daily work.

[@SalmanAhmedoIbrahim]

thank you very much Leila for your clear and concise teaching videos

[@TanzeelRehmanrehman]

You are doing very good for all users. My prayers are with you. Please make a video on whether we can search sheet name in excel or not?

[@LifeofBangladesh]

Watching your video was successful after trying for a long time. Thank you for the video

[@harishpaldhir5915]

Again a new eye opening video on sort 😇😇😇

[@vinayazzie4409]

I love it. The more we can dream to make things easier. I am all for it. Thank you

[@wayneedmondson1065]

Hi Leila.. thanks for the excellent video on sorting. I've always used the helper column trick to get back to my original order. All it takes is to forget that once and you'll never forget it again in the future.. haha!! I have not used Custom Sort or Custom List much.. but can see by your examples what I have been missing. Thanks. I never miss your videos, as they always teach me something new. Thumbs up!

[@LeilaGharani]

I‘ve made the same mistake too in the past :) agree custom sort has a lot of powerful features which can come in really handy.

[@thorstenherborn2473]

Great. Simple but still something new. More of that please.

[@nicenicenicenicee]

Using sort since years without knowing these possibilities, thanks for sharing ur knowledge. Your videos are helpful, pls keep them coming

[@LeilaGharani]

You're very welcome. Glad you picked up something new.

[@cricball6460]

Amazing and concise explanation!

[@purbitajannat]

Hi Leila, thanks for all your effort. It worths watching your excel tutorials. Please share such tutorials on word and ppt. No one made a good video worth watching yet. Hope you can do.

[@mattnyman9933]

More often than sorting by anything other than sorting by values, I sort left to right. This helps a lot when the data is retrieved in a different column order than the workbook where I am working has.

[@mdtaylor2274]

You're always my favorite KZbinr for Excel. No silliness and educational as always. Once I get back to work next week, I'll start purchasing some of your courses on Udemy. Big hugs lovely 👍🏼

[@LeilaGharani]

Thank you for the kind words Michael! I'm glad you enjoy the tutorials.

[@yulinliu850]

Many thanks Leila! It's always worth viewing your tutorials.

[@kreshunram]

Leila, you are a genius in Excel.

[@venkatiyer7459]

Honestly first time I came to know these many things in sort .... thanks a lot ...

[@excelisfun]

That is a great video about Sort! It is Sort-erific : )

[@LeilaGharani]

Sort-erific :)))) Love that!

[@amyhuang1532]

Is there a way to automatically sort the data while I'm entering them instead of having to do the manually sort again evertyime I add new data?

[@Lethesys]

kzbin.info/www/bejne/jJDdlWtnncRnnrs

[@padmavathi.b926]

Use sort Formula

[@ishankshah]

Liela, can you please demonstrate how to use Custom sort order using Sort or Sort by formula?

[@devenderpratap7987]

Thanks a lot Leila for your nice tips many a time to save my life. It happened in custom sorting this time, and Advance Filter earlier and.

[@MrOsama22]

this is one of the best tutorials eveeeeeer

[@hughrobinson4147]

This will help on a project I am working on now. Thanks for sharing your knowledge with us.

[@jamaludin-vb3fy]

Conditional formatting and sorting data by cell icon was a great lesson. Thanks Leila!

[@ismailismaili0071]

thank you so much Ms. Leila the color sort i didn't know before

[@ARIFSAIFIFARHAN]

Great ! I always grip the concept when i watch your video

[@LeilaGharani]

Thanks! 😃

[@JJ_TheGreat]

9:42 That is why you should always add a primary key to your data before sorting it (and making a copy to work on helps, as well).

[@LeilaGharani]

👍

[@ExcelBonanza]

Great illustration for the functionality of a basic feature in Excel!

[@LeilaGharani]

Thank you Excel Bonanza!

[@cyankeemn1]

I'm just discovering your videos and really glad on how much they have helped me. But I have a question about sorting. Do we ask them here or send them to you?

[@tha2irtalib343]

Simple , clear and smoothy , you are great , thanks alot.

[@LeilaGharani]

You're very welcome. I'm glad you like the tutorial.

[@sachinrv1]

Very useful video. I recommend ALT+D+S key board short cut for sorting as its quick. Further excel has one more very excellent feature of sorting from left to right or right to left (horizontal sort / column sort); which I myself started using very recently due to some specific business needs. And believe me, it has saved me lots of efforts. Thanks Leila for upload :) Cheers..

[@LeilaGharani]

Those are GREAT tips! Thank you Sachin.

[@asmar8685]

Please can you help me in this? How can I maintain a sorted arrangement after introducing other data, for example, if I sort particular data, I want to to sort subsequent data automatically without me sorting it again, thanks in anticipation of your help

[@aimmahmood8912]

@@asmar8685 That might be a task for PowerQuery!

[@nononsense129]

Though these are the simple tricks it can save me hours. Thanks for this great valuable tips.

[@LeilaGharani]

You're very welcome. Sometimes simple does the trick!

[@keishrich]

Thought I knew Everyone needed to know about sort... thanks Leila!

[@khaledali4560]

Many thanks for your support and help

[@janithfernando619]

Thanks Ms. This video is very useful for me.

[@mahamohan1]

Every one of video is a learning experience

[@lalala5471]

U basicly saved me lol tmrrw i have an exam and basicly i suck at IT but this video helped me a lot

[@agboolamatthew]

Great Video, you taught it well.

[@qismatali4073]

Custom sorting is amazing its new for me🙏🙏🙏

[@xobpkiss936]

i love ur voice! soooo soothing

[@francinegolden9199]

Thank you so much for your videos. How do you sort numbers with hyphens in between 2 numbers?

[@Softwaretrain]

Thanks Leila it was useful but it was better to explain some of problem when we are sorting.

[@salifdiallo4627]

Très content d'être le premier. Merci Leila !

[@LeilaGharani]

Thank you for first comment/like :)

[@alice2009wj]

Brilliant idea for unsort!!

[@mo3azbarqawi]

I wanted to thank you so much for all these wonderful videos ❤️❤️❤️

[@09shirish]

Thanks Mam ! I was finding this tutorial, thanks a lot !

[@j.fabricioelias227]

Loved the explanation! Thanks.

[@LeilaGharani]

Glad you enjoyed it!

[@adanabdullahi5117]

Excellent Tutorial.

[@LeilaGharani]

Glad you think so!

[@juliusbiliran]

Awesome as usual!!! Super useful. 😇😇☺️

[@AdeKaryadi]

nice tutorial, thanks

[@nurmoahmmad8516]

Thank you. Wish you all the best and best ever,

[@LeilaGharani]

Same to you.

[@edwardmacairan7834]

THANK YOU SO MUCH THIS IS REALLY WHAT I NEED RIGHT NOW.

[@angelokimi]

Custom sort is awesome!

[@LeilaGharani]

Fully agree!

[@ibrahimmridul1484]

Wow!! Beautifuuul!! Go ahead Leila Gharani :)

[@syairol]

Great as usual👍👍👍👍👍

[@arunark274]

Veryyyyy nice Ms. Leila 💐💐💐💕💕💕

[@EPaulofficiel]

Hi Leila, Thanks a lot for this video on how to sort data in excel, and I do have question for you pls. What if I have a column with calculations based on my table, what can I do to avoid that my cell references shifting while sorting? Please let me know if my question is clear. Thank you

[@arunkumar-zt7ks]

Very useful this sorting function. Thanks 😊

[@RJ-dz1hu]

Thanks Leila love your videos you always give helpful information.

[@LeilaGharani]

You're very welcome. I'm glad you find them helpful!

[@michalroesler]

yep, nice video, helped me a lot.

[@debbielaubscher4983]

Excel excellent Leila!

[@smileyface702]

Good, high quality video.

[@nikhilchowdhary8919]

Always being so clear and making it look so simple. Thank you leila. Hooked onto your channel

[@LeilaGharani]

You’re welcome 😊

[@michaeldiamond2726]

Hi Leila Great video, as always. Are you going to do a follow up which shows how you can sort by columns instead of using the sort feature? I think it's cool that you can sort by the actual column and that the main sort is the last column that is sorted. Michael

[@LeilaGharani]

Thanks Michael. Yes - I have sorting columns and sorting dates on my list :) Will get to them eventually.

[@michaeldiamond2726]

Let me know if you need any help in getting them ready for publication.Always glad to help where I can

[@jianlingzhao5501]

@@LeilaGharaniYou’re video so good.Unsort 29~38 cells look at.

[@subashsd635]

Hi, Great Video. Reflecting on un-sort. When doing multiple sort functions, I usually make a copy of the original sheet in the workbook, just in case I end up in a state of not being able to "un-sort". Sharing a thought... Keep up the great work. Regards.

[@mazarata73]

Thank you for that video on sorting.

[@LeilaGharani]

You're very welcome Giuseppe. Thank you for your support.

[@JUHILLAPSIWALA007]

Yes, I'm also using last one trick for unsort data Also learn trick for sort data Thanks 😊

[@justengineer6276]

Thanks for the video. I wonder if there is a technique to extract data from Column in some Table e.g: Col A with multiple rows (1000,550,1250, 680, etc ) Col B identify the repeated name for each value in Col A ( Cat, Sat, Sat, Cat, Hat, Fat, Cat, etc ) How to fill in Cols C,D,E,etc within the same sheet in another the matches of Col A &Col B?.

[@sabbasachisaha]

Mam after a long time. Thanks for your tutorial. What about the VBA series

[@LeilaGharani]

long time? it's been just a week :) Last week was VBA. Make sure you check out the full VBA playlist.

[@hwarang76]

Thanks! This sorted me out ;)

[@LeilaGharani]

Glad I could help!

[@CarmenGonzalez-oh9pt]

Thanks from Barcelona

[@macky2green]

*If there are gaps or blank spaces inside your data range, will the sorting be affected?* Or do you suggest to put any value like an "x" or "?" or "NA", etc. just to fill the gaps? Thank you so much.

[@israelcruz7932]

Dear Leila, this is amazing, thanks

[@Beautifulasever]

i learned a lot from you

[@Benjamin-wu1fs]

Thank you 😌

[@joshuaisimel8369]

hi Leila, are you able to count the number of traffic lights in a range of cells?

[@stevennye5075]

Excellent!

[@kameshsubramanian2553]

Great. Very useful

[@nickbell6311]

Thank for video, awesome

[@daarkthunderr]

another great video .thumbs up

[@LeilaGharani]

Thanks for the thumbs up :)

[@alpeshdoshi7827]

Nice one ....! Madam And congratulations for MVP ... Madam pls make tutorial on power queries....if possible...how can I combine multiple workbook..... worksheet in single sheet.. Thanks... Keep smiling

[@LeilaGharani]

Thank you Alpesh. Have you seen Mike's (ExcelisFun) and Oz's (Excel on Fire) videos on their channels? This (kzbin.info/www/bejne/nmfZomyEpNScfqc) is a favorite one of mine and it shows you how to combine multiple workbooks in one place.

[@robione0550]

Hope you’re still checking: I’ve been trying to do a custom sort on a list of 5 characters, most are numbers but some have letters. I’ll never calculate these so I could call the cells text but either way it won’t sort based on my list. Thoughts?

[@1Uchiha_Madara]

Thank youuuuuu!!!

[@harrouzmedallal8058]

very clear. thank you

[@imranmushtaq7445]

Very informative and constructive

[@alinaqvi6203]

Fantastic job,

[@ahmadcheragh4769]

Dear Leila Salam After we have done the sorting if we change the data, we have to do the sorting again, is there a way that the table automatically re-sort the table after a change? please advise Thank you

[@LeilaGharani]

Salam :) It's only automatic if you use the sort function but for that you need to have Excel 365. An alternative is to use pivot tables, but you have to press refresh for the sort to happen. My video on pivot table is here: kzbin.info/www/bejne/i6THlpd8pLl0bJo

[@felixemnas307]

Hi Leila, thanks for your great tutorials. Concerning sorting, when I sorted a field with Z to A or Hi to Lo, the data displayed on the filter pull down menu is always A to Z or Lo to Hi regardless how the field is sorted. Would it be possible to show the display according how it was sorted? Than means if the field is sorted Z to A or Hi to Lo, the list will be shown the highest value first when the filter pull down menu is clicked.

[@rashikkenn8798]

GOLD!

[@Dev_Bartwal]

Yup very interesting vid LG thanks to share with us💕

[@raguljayakumar1177]

Thanks to youuu sooo much madam 🔥