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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells disturb autofilter indicator
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merged cells disturb autofilter indicator
I'm using Excel 2002 SP3. It's part of the Office XP version. I'll need to
try this on 2003 or newer and see if it still fails. I have found a solution though. I did a Google search and found a solution where I disable the dropdown on selected columns that I was merging. So, instead of merging the header, I disable the dropdown on all those columns: With ActiveSheet.AutoFilter.Range ..AutoFilter Field:=6, VisibleDropDown:=False ..AutoFilter Field:=7, VisibleDropDown:=False ..AutoFilter Field:=8, VisibleDropDown:=False ..AutoFilter Field:=9, VisibleDropDown:=False End With That wide field is a description field that the user shouldn't need to filter on. Now I wonder if there's away to do this outside of VBA. John "Shane Devenshire" wrote: 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 |
Reply |
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) |