How to create a Data Validation List that can be typed into

Question

Hello all,

I am looking for some support with creating Data Validation (combi Box).

I am looking to understand how I can create a Drop Down List that allows me to type in and Auto-Fill.

Then have the ability to select Enter or Tab and move to the corresponding cell / combi box.

Below is a example template for reference:

If I wanted the Drop down List on Cell D2 and downwards using the info from Cells B2 >B17

Answer 1

Hello @Chris Murray, 

Good day! Thank you for posting your valuable question on the Microsoft Q&A forum. 

Based on your description, you want to create an Excel drop-down list in column D (starting at D2) using values from B2:B17. You need the drop-down to behave like a ComboBox with autocomplete functionality and allow navigation to the next cell using Enter or Tab after selection.

Please let me know if I misunderstood any part of your idea or you have any additional information to share. 

Excel’s built-in Data Validation lists allow typing and auto-complete if the cell already contains a drop-down list. 

• Select the range where you want the drop-down (e.g., D2:D100). 
• Go to Data > Data Validation. 

• In the Allow box, choose List. 
• In Source, enter:=$B$2:$B$17 (or select the range directly). 

• Click OK. 

Behavior: 

• You’ll get a drop-down arrow in each cell. 
• You can type, and Excel suggests matches from the list. 
• Use the Up and Down arrow keys to navigate to your desired option.
• Press Enter or Tab to move to the next cell.

Please confirm if this meets your request or let me know if you need anything further. Thank you again for reaching out!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.