We type a letter and the choices that begin with that letter appear: When we click OK, we can see that the input cell now has a little icon that indicates it contains a dropdown list: The resulting Data Validation dialog looks like this: Then, in the Source field, we select the range of cells that contains our list items (our departments in B10:B20). ![]() In the resulting Data Validation dialog, we set the Allow option to List. At the time of this writing, the data validation command icon looks like this: So, we select the input cell and click Data > Data Validation. Next, we would create a dropdown list in the desired input cell. We would begin by creating a list of the departments in a range, like this: Let’s say we want to allow our user to select a department from a dropdown list. ![]() Depending on your update channel, you may have access to it immediately or over time as the update is deployed through the various update channels. ![]() ![]() However, at the time of this writing, it is available on the desktop in O365 licenses only. Note: this feature is available in both Excel online and desktop. Microsoft just announced an enhancement in Excel desktop that enables autocomplete for data validation dropdown lists … YES! I have been waiting for this capability for literally decades … and it is finally here □
0 Comments
Leave a Reply. |