Turn on Data Validation for Selected Cellsįor this example, we want to add drop-down lists to the Rating column or column B. Then, go back to the worksheet with your data. You can do that when you define the data validation or define a list in another location on the same worksheet or another worksheet.įor this example, we’re going to list the options for the drop-down list on another worksheet so click one of the worksheet tabs at the bottom of the Excel window.Įnter each option in a column (or row), one option to a cell. Next, we’re going to enter a list of options for the drop-down list.

You can either type your data in manually or copy and paste it from another source. Create a Data Table and the List of Optionsįirst, set up a basic data table. The steps are also the same in modern versions of Excel in the Microsoft 365 (formerly O365) suite. Although I’m taking the screenshots using Excel 2016, the steps are the same if you’re using older versions. Today I’ll show you how to create a drop-down list in a cell using Data Validation.

Insert a drop down menu in excel 2016