AutoFilter column w/merged cells

[ajsiko]

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?

 

[Gord Dibben]

Merged cells do not have rows.

Merging A1:A3 creates one single cell............one single row.


Gord Dibben MS Excel MVP

 

[uturnabout]

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