Symbol to Show the Sort by Drop-Down Column

In this video, we add a sort icon to the column headers of a table to make it easy to recognise the column the table is sorted by.

This video follows two videos where I demonstrated how to sort by a drop-down list in Excel.

Sort by drop-down (all versions) - https://youtu.be/p9LjxjwNBzk
Sort by drop-down (Excel 365 & Online) - https://youtu.be/Hj_mkYdin7k

Download the workbook used in the tutorial.
https://www.computergaga.com/_excel/files/formulas/dropdown-sort.xlsx

When sorting an Excel table by a drop-down value, it is not immediately clear which column the table is sorted by. Especially, if the drop-down is a few rows away from the table.

In Power BI, a neat arrow icon is shown to indicate the column sorted by. In this video, we create the same symbol using Excel formulas.

Here are the timings of the video.
00:00 - Introduction to the task
01:11 - Sort icons in Power BI
01:53 - Excel formula to show sort icon
08:41 - Sort icon underneath the header text

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

The Ultimate Excel Course & Advanced Excel Tricks Bundle ► https://bit.ly/2YibpiM

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

sort icon in excelicon for sorted columnsort by drop down list in excel