", "I have created the drop down with the help of this article.". This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. 4. Choices([@'Vehicle registration'].Vehicle_x0020_type) Replace Vehicle registration with the name of your SharePoint list and Vehicle type with the name of the lookup column in the list.. Related controls In some cases, you may need to widen the cell in order to display all your items fully. 3. Play the app, or press Alt on the keyboard and select the drop-down list.

How do I delete the tab where the list items are, since this will be a form used for work? Please consider making a contribution to wikiHow today. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. Break down the items and add multiple entries. 7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d9\/Create-a-Drop-Down-List-in-Excel-Step-1-Version-3.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d9\/Create-a-Drop-Down-List-in-Excel-Step-1-Version-3.jpg\/aid2850565-v4-728px-Create-a-Drop-Down-List-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"