How to insert drop down list in Excel?

How can we insert a drop down list in cells in Excel? You may need to take a few steps to insert the drop down list as following instructions in Excel.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

1. Create a list of data that you want to use in the drop down list.

2. Select a range cell that you insert the drop down list.

3. Click Data > Data Validation > Data Validation. See screenshot:


4. And a Data Validation dialog box will appear, then click Settings, and choose List from the Allow drop down list, then click doc-replace-range-names-7 button to select the list of names. See screenshot:


5. Then click OK. The drop down list has been inserted into the worksheet. And you can quickly enter the names you need from the drop down list.


Note: the drop-down arrow is visible only when the cell is active.

Related article:

How to quickly create dynamic drop down list in Excel?

Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment

Security code