Create a column filter cell at the top of columns in Excel


I use simple or basic filtering frequently in Excel. However, I rarely use advanced filtering—mainly because I have not forced myself to go through the learning curve re how to use it.

One thing I have started using more and more frequently in basic filtering is the search box which appears just above the list of column contents whenever a filtering drop-down menu is opened. The reason I like this is because as you type the search criteria, the list of possible matches shrinks rapidly enabling you to find what you are after more quickly.

Is there any way to get the same function in the top cell of a data column in a regular spreadsheet? I don't know if that is possible or not using advanced search but it would sure be nice to have the ability to filter data that quickly and with that few steps.

I suppose one of the reasons I've been hesitant to dive into advanced filtering, is that each time I have watched a video demonstrating how to use it, it's seemed to require several steps (entering criteria, defining criteria range, defining list range, etc.) And even the basic filter requires a few steps (turning filters on, clicking the drop-down arrow, type in the entry, etc.). Also, basic filtering does not allow you to type your search criteria in one column and then type other search criteria in other columns while still seeing the initial search criteria.

Many thanks for comments & suggestions.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
You would need code to do that - there's no built-in facility that I can think of.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Zack BarresseCEOCommented:
Ditto to Rory. The steps you described are about the easiest it gets when it comes to filtering. It's easy-ish, but there are steps you must take to initiate it. For me, Advanced Filter should be used when you have either a complex set of filter criteria, more criteria than the standard autofilter can handle, or want to move (read: copy) the data to another location. But you could use code to make use of this functionality if you wanted to.

Zack Barresse
Steve_BradyAuthor Commented:
Thanks for the responses.

I'm fine with a solution using code if that's what's needed. I will begin new thread to obtain the code since I have very little experience with VBA.
Steve_BradyAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.