how to do a drop down menu in excel 2016 youtube

The last point I wanted to make was the ability to type in a letter and have the drop down list auto-complete. It sounds strange but I have done a ton of testing on this. These cells of data can also be in A5:A15 or C5:C15. So in our example, we just need to add in spaces in cells B6 through B14 in order for auto-complete to function properly. Data can be anything filled in these connecting cells, even spaces.

Your list can start in B15, PROVIDED that there is a link of data between row 5 and row 15 either in columns A, B, or C (think of it as a chain that must be connected/continuous.). let's say your drop down box is on field B5. The only necessary thing is that there is a data link between the drop down box and linked list of items below or above. For auto-complete to function, this is not necessary. Sometimes it's not possible to add this list directly above or directly below. This way when your original list is updated, this hidden list will also be updated. When copying and pasting from your original list, use the Paste Special > Paste link option. Although this is an old post, I would like to improve upon it since there is not a lot of great information regarding this.

How to do a drop down menu in excel 2016 youtube