If you’re dealing with a rather large database, then the filter function onExcel can come in handy. This function allows you to sort the dataset according to your set conditions. As a result, it makes analyzing and summarising data much easier.
However, there might be instances where the filter function might not be working properly. Usually, such an error pops up when there are blank cells within the dataset. So, a quick fix to the issue is to delete these cells.
But, what if the issue persists? In this article, let’s learn more about the potential causes and the fixes for the filter function not working on Excel.
Why is My Excel Filter Not Working?
Here is a list of the potential causes of why the filter function might not be working in your Excel application.
How to Fix Excel Filter Not Working?
Now that we know have listed out the causes, let’s jump right in with applying the troubleshooting methods for this issue.
Select All Data From Sheet
If your dataset has blank rows or columns, it might not select the area (row or column) below or past these cells. As a result, Excel will fail to filter out all the data in your dataset.
To be on the safe end, we suggest that you manually select the data. Now, select the Filter ribbon and choose how you would like to arrange it. This method should be able to include all the datasets.
Remove Blank Rows/Columns
Alternatively, you may also remove the blank rows by configuring the data on your Filter area. Here is how you can do so.
you may also manually delete these cells. To do so, right-select the row adjacent to the blank cell. Select theDeleteoption to remove these blank rows/columns.
Unhide Rows or Columns
If you have hidden rows or columns on your dataset, then Excel won’t apply the Filter function on these data cells. You will have to unhide any hidden rows or columns from your sheet.
