AutoFilter column w/merged cells

A

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?
 
G

Gord Dibben

Merged cells do not have rows.

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


Gord Dibben MS Excel MVP
 
U

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically color merged cells 1
Sharing workbooks limitations - Merged Cells 12
Help with merged cells 1
sorting two columns of merged cells 1
Complex Question on Filtering on a merged column 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Linking Merged Cells in Different Workbooks 7
How do I filter columns of merged cells to show all related rows? 2

Top