By using a filter, we can make out the data which we want to see or on which we need to work.

How Do I Custom Filter In Excel How To Filter A

Lets understand the working of how to filter a column in Excel with an example.

Below is the screenshot of a data set, which has multiple columns and multiple rows with a variety of data set.

Sometimes when we work for a large set of data and select the filter directly, the current look of the sheet can be applied.

These drop down are those things, by which we can filter the data as per our need.

And whatever the data is there in w.r.t.

Desktop in rest of the columns will also get filtered, as the screenshot below.

Also, the line numbers which are circled in the above screenshot, are also showing the random numbers.

Which means that the filter which we have applied was in a random format, so the line numbers are also been scattered when we applied the filter.

For that, go to any of the columns, and click on the drop-down button to see the filter options.

Once we click on Custom Filter, we will get a box of Custom AutoFilter as shown in below screenshot.

And the other two boxes provided at the left side, are for filling the criteria values.

For some cases, if the data is going beyond 50,000 lines, then it becomes slow and sometimes it does not show data available in any column.

By doing this, data will be frozen from the middle portion of the sheet.

It will take a lot more time to get applied and sometimes the file also gets crashed.

How Do I Custom Filter In Excel For Mac