AutoFilter column w/merged cells

  • Thread starter Thread starter ajsiko
  • Start date Start date
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?
 
Merged cells do not have rows.

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


Gord Dibben MS Excel MVP
 
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

Merging multiple columns into one column (dynamically) 1
Sharing workbooks limitations - Merged Cells 12
sorting two columns of merged cells 1
Automatically color merged cells 1
Help with merged cells 1
Formula from a single cell to a merged cell 4
Merge the same group of cells down a column quickly 9
Autofilter on blanks pulls merged cells 1

Back
Top