View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DocBrown DocBrown is offline
external usenet poster
 
Posts: 119
Default 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