Select Page

The Search Box is another way to filter your data in Excel Video 385. The Search Box lets you look for text anywhere inside your data. That’s helpful, but the Add current selection to filter check box is even more helpful because it allows you to do an “or” filter. You can always manually check a and b in a list for Excel to return a or b, but if you search for all of the Smiths, the Search Box lets you get all of the Joneses as well. That can be much faster than manually checking all of the Smiths and then checking all of the Joneses. Just remember to click Add current selection to filter. If you just click OK, Excel will change and only filter for the last selection in the Search Box instead of retaining all of your filters.
Believe it or not, there’s still plenty more to say about filtering in Tables. We’ll keep going by discussing Slicers next time. I look forward to seeing you then.