Also, I forgot to mention that even with AutoComplete on, this is still
happening to me. She is working in 2003 and I'm working in 2007 with the
Compatibility Mode on.

"Oriana" wrote:

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!