excel filter not working for merged cells

In the following dataset under the Product column the cells are all merged. Now you will see there should drop-down.

Excel Filter Not Working Properly Fixed

Thus we need a VBA script to.

. Select the column that you want to filter the specific merged cell and then click Kutools Plus Special Filter Special Filter see screenshot. It then will only create a filter for that column. Many of the cells in each column are merged.

Another common reason why an Excel filter doesnt work is the presence of merged cells. Then click the Filter option. Head over to the column that showcases the filter list.

If you need to filter multiple. Use the Sort Filer icon. Why is Excels data filter not working.

Click anywhere in the data range and in the Ribbon go to Home Sort Filter Filter. Select a column a row or a cell and then click the Sort Filter icon. Check for merged cells.

Click on the filter icon for Column B the arrow in cell B1. First turn on the filter. Then you can Copy the merged cells and Paste.

When I select a column to filter and select the value I want filtered it only gives me the top row instead of all the rows that the. Scroll further down and check the option for Blanks. Click on the drop-down arrow and uncheck the box for Select All.

You will need to unmerge Excel cells in order to. In the Special Filter dialog box select. So instead either select the all the data of column AJ in your case AJ2AJ310 and then press autofilter.

To fix this you first need to start by creating your Merged Cells somewhere else unmerge your filter-cells and fill the values into all cells. Remove any merged cells so that each row and column has its own unique. Another reason your Excel filter may not work is due to merged cells.

Formatting the cell using Wrap Text also works. Another reason why your Excel filter may not be working may be due to merged cells. Check for merged cells.

Applying the AutoFit Row Height command doesnt work here.

Ms Excel 2016 Wrap Text In Merged Cells