- HOW TO CREATE A DROP DOWN MENU IN EXCEL 2016 HOW TO
- HOW TO CREATE A DROP DOWN MENU IN EXCEL 2016 SOFTWARE
(Click and drag to select a range hold down Ctrl while you click to select non-adjacent cells.)ģ.Choose Data, Validation to display the Data Validation dialog box.Ħ.In the Source field, specify the range that contains the list items. If you'd like more than one cell to display the same list, just select them all now rather than setting them up one at a time. In Excel terminology, a rectangular group of cells (such as E1 to E12) is called a range.Ģ.Select the cell that will contain the drop-down list. In this example, I'll assume that the month names start in cell E1 and extend down to E12, but they can be in any out-of-the-way location on the worksheet.
HOW TO CREATE A DROP DOWN MENU IN EXCEL 2016 HOW TO
Here's how to add a drop-down list to that cell to make data entry a breeze-and save some keystrokes.ġ.Enter the items for your drop-down list into a list on the worksheet, one item per cell. And best of all: Macros are not required!Īssume that you have an input cell in which the user is supposed to enter a month name: January,įebruary, and so on.
Inserting a drop-down list to a cell is a slick trick that can add a touch of professionalism to your worksheets-and also ensure that erroneous data is not entered into the cell.
HOW TO CREATE A DROP DOWN MENU IN EXCEL 2016 SOFTWARE
Microsoft Excel software under a Windows environment is required to use these templates. This article provides details of Excel spreadsheet template with drop down list that you can download now. Excel spreadsheet template with drop down list