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

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)

Who is Participating?
NBVCConnect With a Mentor Commented:
I don't see why not.  Did you also apply data validation to the top row?  Maybe you should remove them from there if you have.
mlagrangeAuthor Commented:
I did that, but the "funnel" is still disabled when I select the column headers row
mlagrangeAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.