How To Create a Drop-down List in Excel


Drop-down list in Excel allows people to pick an item from a list. It will helps people to work more efficiently in Excel Worksheet.
  • In a worksheet, type all the entries that you want to appear in your drop-down list. See below example:
  • Select the cell in the worksheet where you want the drop-down list. In our example, we are creating drop-down list in Cell D5
  • Go to the Data tab on the Ribbon, then click on Data Validation.
  • On the Settings tab, in the Allow Box, click List.
  • Click in the Source box, then select your list range. We put ours on a sheet called State, in range A2:A6. Note that we left out the header row, because we don’t want that to be a selection option:
  • If it’s OK for people to leave the cell empty, check the Ignore blank box.
  • Check the In-cell dropdown box.
  • Click the Input Message tab.
    • If you want a message to pop up when the cell is clicked, check the Show input message when cell is selected box, and type a title and message in the boxes (up to 225 characters). If you don’t want a message to show up, clear the check box.
  • After you create your drop-down list, make sure it works the way you want.

scroll to top