About this tutorial: Video duration: 1:15 In this HowTech written tutorial, we’re going to show you how to create a drop-down list in Excel 2016. Don’t forget to check out our main channel for more free how-to videos! Join us on Facebook Our App We’ll first create a new Sheet by hitting the plus sign located in the bottom left of the screen. Within this second sheet, we’ll write out the list of options the user can choose within the drop-down list.

Create a Cell Drop-Down List in Excel with Data Validation Adding a drop-down list to a cell or range using Data Validation is a simple matter. Data Validation is used to define restrictions on what data can or should be entered into a cell.

The example will be numbered, so I will start by typing [Qtr 1] in the first cell. Categories: / / by May 5, 2017.