Select Page

Watch Excel Video 286 to see how Excel customizes your filter options based on the type of data in your rows and columns. When we looked at label filters in the last Excel Video, we had a text field in the Row Label field we were filtering, so Excel gave us text based filtering options. Watch what happens when we put a date field in the Row Labels area. Instead of begins with and ends with, Excel gives us options to filter by today, tomorrow, this week, next month, last quarter, and much more. Excel recognizes that the date field we’re filtering is a date and gives us date-based options to filter with. We’ll also walk through an example filtering numbers.
Don’t worry about how to group dates or how to count instead of sum data in the Values area. We’ll talk about those topics and a whole lot more in upcoming Excel Videos. Thanks for watching.