Excel Filter Data with Dropdown Arrows

About this tutorial:

Video duration: 5:32

Being able to filter data in Excel is an important skill. Rather than be overwhelmed with a long list in your worksheet apply a filter so that you can focus on just part of your list. This video shows you how to use dropdown arrows to filter your list in Excel 2010.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “Excel Filter Data with Dropdown Arrows

    Jesper Annika

    (April 18, 2018 - 4:58 am)

    Thank you. I watched 2 out of the 5 minutes, and you solved my problem 🙂 Thank you

    Talar T.

    (April 18, 2018 - 4:58 am)

    What if you wanted only column B and D to have the drop down arrows? I can do it from 1 column or all, but not for multiple/not all.

    Dorothy Lobo

    (April 18, 2018 - 4:58 am)

    Very neatly explained. Thanks.

    Chameleon VinylConcepts

    (April 18, 2018 - 4:58 am)

    Thank you Joe SOOO much for this quick and easy tip!!!! You just answered my question that I've been trying to figure out for the last 2 hours!


    (April 18, 2018 - 4:58 am)

    At work. A user asked me to do this for them. THANK YOU!!


    (April 18, 2018 - 4:58 am)

    i found that , if the data from the table is link from other tab. The formula does not go along with the sorting function. Please advice. Thanks in advance.

    Yolanda Rosado

    (April 18, 2018 - 4:58 am)

    Awesome…thanks…exactly what I wanted and needed to do!!


    (April 18, 2018 - 4:58 am)

    Exactly what I needed!

    Literally Stalin

    (April 18, 2018 - 4:58 am)

    To the point,no umms

    Christopher Lamb

    (April 18, 2018 - 4:58 am)

    Thank you Joe. Straight forward and explained with patience.

    Andrew Mueller

    (April 18, 2018 - 4:58 am)

    Thanks Joe, that was really helpful.

    Keith Jackson

    (April 18, 2018 - 4:58 am)

    Good stuff. Thanks so much.

    Kelsey Waddle

    (April 18, 2018 - 4:58 am)

    Best, most efficient explanation

    Debbie Whitehouse

    (April 18, 2018 - 4:58 am)

    Thanks you. a simple explanation. I have searched every where and couldn't understand any others. .

    Incog Nito

    (April 18, 2018 - 4:58 am)

    Thanks Joe!

Leave a Reply

Your email address will not be published. Required fields are marked *