inserting a drop down menu in excel 2016

In the Source box, type the items you want to appear in your drop-down menu separated by a comma (with or without spaces).

In the Data Validation window, on the Settings tab, do the following: Enter the list items and choose the options. On the Excel ribbon, go to the Data tab > Data Tools group and click Data Validation.ģ. Use Excel Data Validation to create a drop-down list. You can even select non-contiguous cells by pressing and holding the Ctrl key while selecting the cells with the mouse.Ģ. If you select the whole column, a drop down menu will be created in each cell of that column, which is a real time-saver, for example, when you are creating a questionnaire. This can be a single cell, a range of cells or the entire column. You start by selecting a cell or cells where you want a drop-down box to appear. Select a cell or range for your drop-down list. This is the fastest 3-step way to create a drop-down box in all versions of Excel 2016, 2013, 2010, 20.

Drop down list based on a range of cellsĬreating drop down lists with comma-separated values.Drop-down box based on a list of values.Below you will find a quick outline of the main advantages and drawbacks as well as the detailed step-by-step instructions for each method: On the whole, there are 4 ways to make a drop down menu in Excel, and all of them have their own strong and weak points. Allow entering other data in a combo box.Display a message when a cell with the dropdown is clicked.Additional options for the Excel drop-down box.How to fix Excel data validation not working.Make a drop-down list from another workbook.How to create a drop-down list in Excel.Apart from that, a dropdown prevents spelling mistakes and makes data input faster.

The main purpose of using drop down lists in Excel is to limit the number of choices available for the user. It also shows how to create a dropdown from another workbook, edit and delete data validation lists.Įxcel drop-down list, aka drop down box or combo box, is used to enter data in a spreadsheet from a pre-defined items list. The tutorial demonstrates 4 quick ways to create an Excel data validation list (drop-down list) - based on a list of values, range of cells, named range and a dynamic dropdown.

Inserting a drop down menu in excel 2016