<div>
I did that, but the &quot;funnel&quot; is still disabled when I select the column headers row
</div>


I did that, but the "funnel" is still disabled when I select the column headers row

<div>
Ok, I think I stumbled on to it... <br />
<br />
I had all the rows &amp;&nbsp;columns in a table, then added some notes and other miscellany which got included in the table<br />
<br />
So when I re-sized the table back to just the raw data, and selected only those column heads, the funnel is enabled now.<br />
<br />
Thanks for your response
</div>


Ok, I think I stumbled on to it...

I had all the rows & columns in a table, then added some notes and other miscellany which got included in the table

So when I re-sized the table back to just the raw data, and selected only those column heads, the funnel is enabled now.

Thanks for your response

<div>
<div class="content wysiwyg-content">
Hello - I set up data validation lists on all the columns of a worksheet (by selecting each column), and now I can't use the column heads for AutoFiltering.<br />
<br />
Can you have these features together? If so, how?<br />
<br />
(Excel 2010)<br />
<br />
Thanks
</div>
</div>


Hello - I set up data validation lists on all the columns of a worksheet (by selecting each column), and now I can't use the column heads for AutoFiltering.

Can you have these features together? If so, how?

(Excel 2010)

Thanks

How to set up data validation on a given column and still use the filter on the column head?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.