Hi,

I can't duplicate your problem, as I understand it, in 2003. what version
of Excel are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DocBrown" wrote:

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