It is quite easy to create a data validation drop down list among worksheets within a workbook. This tutorial provides the method to solve the problem.Ĭreate drop down list from another workbook in Excel If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. If you have a data validation drop down list with large values, you need to scroll down in the list just for finding the proper one, or type the whole word into the list box directly. If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.ĭemo: Drop down list auto populate without remembering formulasĪutocomplete when typing in Excel drop down list
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |