Drop-down list in Excel Workbook

ibrahimaa

New member
Joined
May 22, 2011
Messages
16
Reaction score
0
Points
0
I have a drop-down list in Excel Workbook where the list range is from A1:A100 including 100 department names.

To find a department name start with “S”, I will have to open the list and scroll down until I reach all Dpets names that start with “S” and then try to find the required name.

There is a way where you select the first option (the top of the list) and press “S” and it will take you directly to the first Dept name started with “S”.
Also, you can keep entering “S” and it will scroll down through all names start with “S”.
I appreciate your help. Thank you.
 
Top