Filter Data with Header Drop-Down Filters in Excel - AdvantEdge Training & Consulting

Filter Data with Header Drop-Down Filters in Excel

drop down filters in excel

All too often, when we are sent data from someone, it is not presented in the view we would like. Changing the way our data looks, and being able to do it quickly, can save us some time, when we use the right tools.

In some cases, using a table has some advantages, while using just the drop-down filtering has different advantages. For example, some functions do best when contained in a table; so using regular drop-down filters allows for more complex functionality. Tables, on the other hand, have added functionality to add colors, totals (sum, average, etc.) at the bottom of the data, slicers, and other items not included with drop-down filters.

In our video, we are going to add drop-down filters, and walk through some of the functionality for filtering. Remember, the drop-down filters we use in the video are also available when the table functionality is used for data.

Want to learn more ways to make Excel work for you? Check out AdvantEdge Training’s live training courses.
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top