MS Excel Drop Downs/DataValidation

Horak, Franz 0 Reputation points
2025-01-10T10:07:52.1766667+00:00

Hi,

for a short period of time we had the luxury in MS Excel that a drop down selection (Data Validation Drop Down and not in a table) would automatically jump to the correct first letter selection when we started typing in the cell with data validation.

We had a few issues with some users experiencing a massive slow down in excel handling speed so our IT dept. decided we move back to an older version of excel to stop the massive slow down.

The version step back did solve the speed issues but the feature that data validation drop downs would jump to the selection based on when we started typing has dissapeared and we do miss it.

Is this a setting we can change somewhere or is this 100% version related?

We currently work on Version 2302 build 16130.21094 on Desktop

Thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,073 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.