ExtendOffice - Professional Add-ins and Tools for Microsoft Office
fackbook twitter

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.

Insert drop-down list in Excel


Easily batch insert checkboxes or option buttons in selection in Excel

You can easily insert multiple checkboxes or option buttons in a selection in Excel as below screenshot shown

doc checkbok ad


arrow blue right bubble Insert drop-down list in Excel


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:

doc-insert-drop-down-list1

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:

doc-insert-drop-down-list2

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.

doc-insert-drop-down-list3

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


arrow blue right bubbleRelated articles:


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Add comment


Security code
Refresh