AutoFilter column w/merged cells
 

The column that I'm filtering has vertically merged cells. For example,
A1:A3 are a single cell serving as a description for rows 1-3.

I want to filter for specific values in column A, showing all the associated
rows. However, since Excel treats the merged cell as A1, only row 1 is
visible when the filter is active.

Is there any way to set up my sheet so that Excel will show all the rows
contained in the merged cells?

AutoFilter column w/merged cells
 

you can insert a helper column

say you insert it at column A
in cell A1 type =B1
in cell A2 type =B1
in cell A3 type =B1

then select the cells and drag them down
then autofilter by the new column A


"ajsiko" wrote:

The column that I'm filtering has vertically merged cells. For example,
A1:A3 are a single cell serving as a description for rows 1-3.

I want to filter for specific values in column A, showing all the associated
rows. However, since Excel treats the merged cell as A1, only row 1 is
visible when the filter is active.

Is there any way to set up my sheet so that Excel will show all the rows
contained in the merged cells?