The letters PP are entered in the cell and the drop-down list shows only the items containing PP.Ī normal drop-down list would not allow you to do this. The image above shows a searchable drop-down list. This post will tell you how to create a searchable drop-down list in Excel.Īfter my earlier series of posts on Data Validation and drop-down lists, I received requests for further help and how to create a searchable drop-down list in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |