Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

....when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!