Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
HTML-код
- Опубликовано: 7 авг 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Sorting is super easy in Excel! You'll learn how to sort by values (ascending, descending), how to sort alphabetically & much more:
1. Sort multiple columns in Excel
2. Sort based on custom lists (including user defined sort order)
3. Exclude ranges from the sorted list
4. Sort by cell color
5. Sort by cell icon (conditional formatting result)
6. How to UN-Sort your data to get back to the original sort order
⬇️ Download the workbook here: pages.xelplus.com/sort-unsort...
🔑 What You'll Learn:
- Basic Sorting Techniques: Understand how to sort data numerically and alphabetically.
- Custom List Sorting: Create and apply your own sorting preferences to reflect specific organizational needs.
- Color and Icon Sorting: Dive into advanced sorting options based on cell colors and conditional formatting icons.
- Multi-Level Sorting: Implement multiple sorting criteria for detailed and organized data analysis.
- Preserving Original Data Order: Learn the trick to maintain your original row order using a simple helper column.
00:00 How to Sort and Un-sort Data in Excel
00:45 Sort basics
03:38 Sorting by custom lists
04:44 Multiple-Level sorting
05:52 Sorting by color
07:42 Sorting by icon
09:12 Un-sort data
★ Links to related videos: ★
Check out the Excel Basics playlist: • Excel Introduction - L...
How to use Excel Filter: • Excel Filter Basics (f...
★★ My Online Excel Courses ★★ www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/sort-unsort-file
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.
As always bringing Light to my excel darkness, thank you Leila .
Let there be light :)
Me too. Thank you Leila 🤗
Conditional formatting and sorting data by cell icon was a great lesson. Thanks Leila!
Great. Simple but still something new. More of that please.
Many thanks Leila! It's always worth viewing your tutorials.
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. 🥰
I love it. The more we can dream to make things easier. I am all for it. Thank you
This will help on a project I am working on now. Thanks for sharing your knowledge with us.
great work leila specially your brief, clear, concise speaking english makes possible to understand quickly.
Thank you!
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).
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.
Glad it helped, Alexander!
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?
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.
Watching your video was successful after trying for a long time.
Thank you for the video
thank you very much Leila for your clear and concise teaching videos
Again a new eye opening video on sort 😇😇😇
Thought I knew Everyone needed to know about sort... thanks Leila!
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.
thank you so much Ms. Leila the color sort i didn't know before
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!
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.
Always being so clear and making it look so simple. Thank you leila. Hooked onto your channel
You’re welcome 😊
Leila, you are a genius in Excel.
Using sort since years without knowing these possibilities, thanks for sharing ur knowledge. Your videos are helpful, pls keep them coming
You're very welcome. Glad you picked up something new.
I wanted to thank you so much for all these wonderful videos ❤️❤️❤️
this video is very helpful for me. this save my 3 to 4 hours of daily work.
You're always my favorite RUclipsr 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 👍🏼
Thank you for the kind words Michael! I'm glad you enjoy the tutorials.
Thanks Mam ! I was finding this tutorial, thanks a lot !
this is one of the best tutorials eveeeeeer
That is a great video about Sort! It is Sort-erific : )
Sort-erific :)))) Love that!
Great illustration for the functionality of a basic feature in Excel!
Thank you Excel Bonanza!
Many thanks for your support and help
Thanks Leila it was useful but it was better to explain some of problem when we are sorting.
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.
Dear Leila, this is amazing, thanks
Hi!!! Your videos are really helpful for students starting out their journey in corporate offices. Love from INDIA
I'm glad to hear that!
THANK YOU SO MUCH THIS IS REALLY WHAT I NEED RIGHT NOW.
Every one of video is a learning experience
Honestly first time I came to know these many things in sort .... thanks a lot ...
Simple , clear and smoothy , you are great , thanks alot.
You're very welcome. I'm glad you like the tutorial.
Very useful this sorting function. Thanks 😊
Though these are the simple tricks it can save me hours. Thanks for this great valuable tips.
You're very welcome. Sometimes simple does the trick!
Yes, I'm also using last one trick for unsort data
Also learn trick for sort data
Thanks 😊
Thanks Ms. This video is very useful for me.
i love ur voice! soooo soothing
Amazing...many many thanks for sharing!
Awesome as usual!!! Super useful. 😇😇☺️
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..
Those are GREAT tips! Thank you Sachin.
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
Custom sorting is amazing its new for me🙏🙏🙏
Great Video, you taught it well.
Yup very interesting vid LG thanks to share with us💕
Thanks Leila love your videos you always give helpful information.
You're very welcome. I'm glad you find them helpful!
Brilliant idea for unsort!!
Great !
I always grip the concept when i watch your video
Thanks! 😃
very valuable of course
Thank for video, awesome
Loved the explanation! Thanks.
Glad you enjoyed it!
yep, nice video, helped me a lot.
Good, high quality video.
Veryyyyy nice Ms. Leila 💐💐💐💕💕💕
Wow!!
Beautifuuul!!
Go ahead Leila Gharani :)
Thanks from Barcelona
Thank youuuuuu!!!
Great. Very useful
Thank you leila i have learned new thing
Thank you
I liked that trick of unsorting
Very informative and constructive
Excellent!
Excel excellent Leila!
Excellent Tutorial.
Glad you think so!
nice tutorial, thanks
i learned a lot from you
Thank you. Wish you all the best and best ever,
Same to you.
Great as usual👍👍👍👍👍
Thank you very much
Très content d'être le premier. Merci Leila !
Thank you for first comment/like :)
Thank you 😌
Fantastic ! Thanks!
thank you leila you always Creative
very clear. thank you
Wow. Of Great help.
Many Many Thanks
Thank you for that video on sorting.
You're very welcome Giuseppe. Thank you for your support.
Thanks Mam !
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?
another great video .thumbs up
Thanks for the thumbs up :)
Fantastic job,
Thank youu!!
Thanks! This sorted me out ;)
Glad I could help!
GOLD!
U basicly saved me lol tmrrw i have an exam and basicly i suck at IT but this video helped me a lot
Yay! I finally got it. Thank you.
You're very welcome :)
Thanks to youuu sooo much madam 🔥
thank you
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.
You're amazing
Thanks from Banglades
LOVE YOU
Thank you so much for your videos. How do you sort numbers with hyphens in between 2 numbers?
Problem solved. Thank you