The Excel Drop Down List - How to Create It?

Microsoft Excel 2003 allows you to build your own Excel drop down list!

Well, this feature is really cool.

Have you ever been in a situation where you were building a template in Microsoft Excel 2003 and it would have been really useful to actually have a drop down list so that your users could choose from a preset list, rather than them simply typing in their own values?

This tutorial show you how to create the drop down list in Excel.

To create an Excel drop down list

  • Open a new Excel workbook. On the first worksheet (Sheet1) enter the following data.

    Cell A1 - Title
    Cell B1 - Full Name

  • Click on the second worksheet (Sheet2) in your workbook. Enter the following data.

    Cell A1 - Title
    Cell A2 - Mr
    Cell A3 - Miss
    Cell A4 - Mrs
    Cell A5 - Ms

  • Then select the cell range A2 to A5. We are going to give a name for this range of cell.
  • From the Insert menu choose the Name option from the menu and click Define.

    Excel define name dialog box

  • From the Define Name dialog box displayed, in the Names in workbook: text box simply type in the name Title and click the OK button.
  • Now, return to the first worksheet (Sheet1). We will create a drop down list in cell A2 so click on cell A2.
  • From the Data menu, click on Validation. This will open the Data Validation dialog box.

    Data Validation dialog box

  • Under the Settings tab, in the Allow: drop down list, choose the List option.
  • In the Source: text box, typing in = Title (This is to define the name Title as the range).
  • To complete the process, click the OK button.
  • Return to the cell A2 and you will now see a drop down box. If you click on the arrow you will see the results from your second sheet.

    Excel drop down list menu

    Note: If you do not want your range for your list to be on the same worksheet, then you must name the range.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!


    Back to Top

    >> Next Topic : Knowing the Excel Date and Time Functions!

    << Previous Topic : Multi-users working on the same worksheet at the same time?

    You're viewing the Excel drop down list info page, click here to go back to the Home Page