But you might wonder how to limit the number of columns in a filtered result set. You can’t using a simple Excel filter, because the feature filters the source data in place.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.