Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset every 27th row in a column that is 2 cells wide (merged cel | Excel Worksheet Functions | |||
Autofilter on a worksheet with merged cells | Excel Worksheet Functions | |||
Count cells in a column that has a autofilter | Excel Worksheet Functions | |||
Autofilter on blanks pulls merged cells | Excel Discussion (Misc queries) | |||
Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) |