Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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
0
mlagrange
Asked:
mlagrange
  • 2
1 Solution
 
NBVCCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now