[Solved:] Excel Not Filtering Entire Column (3 Quick Fixes)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we stumble in the case of Excel not filtering entire column. In this article, I will explain 3 easy solutions to this problem.


Download Practice Workbook

Download this workbook and practice while going through the article.


3 Possible Solutions for Excel Not Filtering Entire Column

This is the dataset for today’s article. We have some salespersons along with the zone, order date, and amount.

Dataset for excel not filtering entire column

I will use this dataset to explain the solutions for Excel not filtering entire column.


Solution 1: Select Entire Dataset

  • Suppose there are empty rows in a dataset.

In such cases, when you apply a filter without selecting the entire table, Excel will not filter the entire column. For example, suppose you want to get all the data for the North zone. To do so,

  • Go to the Data.
  • Activate the Filter.

Select Entire dataset excel not filtering entire column

  • Then, click the drop-down.

  • After that, select North from the list.
  • Then, press OK.

Select Entire dataset excel not filtering entire column

  • You will see that Excel has not filtered the entire column.

Let’s see the solution step by step.

Steps:

  • First of all, select the entire dataset.
  • Then, go to the Data
  • After that, select Filter.

Select Entire dataset excel not filtering entire column

  • Then, select the drop-down near the Zone
  • After that, select North.
  • Then, click OK.

  • Now, Excel will filter the entire column.

Select Entire dataset excel not filtering entire column

Read More: Excel Data Validation Greyed Out (4 Reasons with Solutions)


Solution 2: Rearrange Dataset by Unmerging Cells

If you have merged cells in your dataset, Excel will not filter the entire column. For example, Dover, Samuel, and Smith have the same order date.

Unmerge cells excel not filtering entire column

But, when you filter for 12/18/2021 (see the image),

Excel will show only the first one (Dover) in the dataset.

Unmerge cells excel not filtering entire column

Let’s see the solution step by step.

Steps:

  • First of all, unmerge the cells.
  • Then, copy the date and paste them.

  • Now, apply a filter.

Unmerge cells excel not filtering entire column

  • Excel will filter the entire column.

Read More: [Fixed!] Merge Cells Button Is Greyed Out in Excel


Similar Readings


Solution 3: Unhide Rows

In the case of hidden rows, filtering will not occur to the entire column. For example, the 8th row is hidden in this workbook.

Unhide rows excel not filtering entire column

  • Samuel from the South zone was in the 8th.
  • When you apply a filter to the Salesperson column, you will not find Samuel.

The solution is to unhide the row.

Steps:

  • First of all, select the 7th to 9th
  • Then, right-click your mouse to get the context menu.
  • After that, select Unhide.

Unhide rows excel not filtering entire column

  • Excel will unhide the row.
  • Now, if you apply a filter, you will get Samuel.

Unhide rows excel not filtering entire column

Read More: [Fixed!] Excel Filter Stops at Blank Row (4 Possible Solutions)


Things to Remember

  • Remember to select the entire dataset.
  • Unhide all the rows.

Conclusion

In this article, I have explained 3 solutions for Excel not filtering entire column. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.


Related Articles

Tags:

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo