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

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

🔑 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: ★

🚩Let’s connect on social:

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

[HamayonKhan-gm]

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!

[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. 🥰

[serch]

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

[sharjeelmazhar-ye]

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

[keyahmedibrahim]

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

[LifeofBangladesh]

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

[harishpaldhir]

Again a new eye opening video on sort 😇😇😇

[aminanwar]

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

[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.

[sirirvasist]

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

[lillyniki]

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).

[thorstenherborn]

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

[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.

[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?

[mattnyman]

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.

[venkatiyer]

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

[vinayazzie]

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

[nicenicenicenicee]

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

[thairtalib]

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

[ismailismaili]

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