Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have products sheet in excel workbook but when i add new order line in order sheet in same workbook, i want to filter products when i press keys to write product name.

Is there any way to show filtered product names in order sheet?

For example: When I write "Chee", it should filter the column and show relevant cells under it:

Cheese Dutch
Cheese French
share|improve this question
Looks like you're in need of a database! ;) – BloodPhilia Aug 19 '10 at 22:30
I'm not Catholic, but St. Isidore protect us from another "Excel Database" ... I strongly suggest adopting a philosophy of "the right tool for the job." – Adrien Aug 19 '10 at 23:35
Do you think this is difficult thing and can't be in excel ? Do you know excel row limit? it is always increasing, why? Why do people need to have more line than 64000? Why has it 1,048,576 row limit now? Do you still think it isn't like db? It is searching in other workbook(databases)'s sheet(Table). It is returning a vector or scalar value. And you can bind excel file as a db. Think again, it is trying to be db something like more functional classical db and more compact isn't it? – uzay95 Aug 20 '10 at 18:54

I suggest you download AutoCompleteDataValidation(SortOf)2.xls from change an entry in Column A of Sheet Lists to 'Chee', overwrite some entries in Column B of the same Sheet with Cheese Dutch, Cheese French, Cheeseburger, Cheetos and then see how you get on with entering data in Sheet Single B2. You might want to turn off Autocomplete. You should be able to enter 'Chee' or click the down arrow to find 'Chee' and either way then click again to pick the right detail.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.