Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells disturb autofilter indicator
I'm wondering if anyone has a solution.
Due to the layout of my worksheet, I created an autofilter header row where one of the cells is merged from 4 cells. This causes the blue arrow, which indicates which column is filtering, to be shifted 4 cells from the filtered row. For example, the merged cell is from cols H thru K. If I filter on column M, the blue arrow is on column P. Is this a bug or can I get that blue arrow in the correct place? Or how can I have create an autofilter row with non-contiguous cells? I have chosen this method because the top area above the filter row is a complex layout but I needed a wide column in the table below the filter row that was below a multi column table in the top area. BTW, the cells in wide data area are not merged. Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter indicator change | Excel Worksheet Functions | |||
AutoFilter column w/merged cells | Excel Discussion (Misc queries) | |||
Autofilter on a worksheet with merged cells | Excel Worksheet Functions | |||
Autofilter on blanks pulls merged cells | Excel Discussion (Misc queries) | |||
Autofilter indicator | Excel Discussion (Misc queries) |