Display multiple columns in drop down list in Excel

This video demonstrates how to display multiple columns in a drop-down list in Excel.
You can follow the video or the corresponding post step by step to complete it.

[oggyytt]

Thank you for your video. Very informative. I have a question, how do I make the list to scroll? I have 100 rows and it's not showing them all.

[yanglinda]

Can this be applied to multiple columns? I want to have 5 columns that when you choose different options from the table in the Combo Box, the fields will all display different selections corresponding to that Combo Box. So far if I change one Combo Box, they all change together with the same data and only one cell is displaying the referenced data with the formula.

[victoriabenza]

Is there a way to reference a table? This way if more rows are added, they are automatically added to the dropdown box?

[Rashuge]

Can you use the same method to extend across multiple columns, so instead of going down from the dropdown list, going to the right instead and stay in the same row?

[SandraLin-vq]

Is there a way to make this work when the fill range is in a separate worksheet? Unfortunately, when trying to enter the ListFillRange with the name and range in another worksheet in the same workbook, it doesn’t let me do this. Thank you in advance!

[rubenstemphelet]

The formula shown here won’t work if the left column starts with a number any ideas how to overcome this problem?, thank you

[rojjercoc]

When i am adding combo box and set the properties, when i click on some specific date he is showing me some random no.s

[tigerlilly]

Nice, but technically that's not a drop down list, that is a combo list which works great when looking up from a one to many perspective but not when you want to add a drop down to every record. You should rename your title... To those looking for that there are many videos out there you can watch. If you want to source an entire row you can but to hide the blanks you have to use an offset calculation... just do an internet search and you should be able to find the info...