I have excel 2010. When I create a 'list' in data validation to choose from, choosing from the drop down box gets a little tedious. Is there a way that Excel will autofill the cell as I start to type? Imagine you have 7 columns, and each column has about 10 different things to choose from in the data validation list...how can I start typing and have 1 of the 10 pop up and then I just hit enter to complete it? THANKS!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Fill with Data Validation
- Thread starter jim5309
- Start date
bjurney
Active Member
- Joined
- Aug 24, 2009
- Messages
- 320
One thing you can try is typing the list right above the validation list and then hiding those rows. When you start to type it in, it will Autofill based on the cell you typed your value in
Example:
AA
1 Bread
2 Cheese
3 Milk
4 Meat
5 Validation List containing the values above
Hide Rows 1-4
This doesnt work though if you have blank cells between your lists though, but this may do what you need it to.
Hope that helps.
Example:
AA
1 Bread
2 Cheese
3 Milk
4 Meat
5 Validation List containing the values above
Hide Rows 1-4
This doesnt work though if you have blank cells between your lists though, but this may do what you need it to.
Hope that helps.
Upvote
0
Similar threads
- Question
