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?

Merged cells do not have rows.

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


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 08:34:03 -0700, ajsiko <(E-Mail Removed)>
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?

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?