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)

Thanks
mlagrangeAsked:
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.
0
 
mlagrangeAuthor Commented:
I did that, but the "funnel" is still disabled when I select the column headers row
0
 
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
0
All Courses

From novice to tech pro — start learning today.