{"id":2754,"date":"2026-09-11T09:54:36","date_gmt":"2026-09-10T23:54:36","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=2754"},"modified":"2026-09-11T09:54:38","modified_gmt":"2026-09-10T23:54:38","slug":"how-to-create-a-drop-down-list-inexcel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-create-a-drop-down-list-inexcel","title":{"rendered":"How to Create a Drop-Down List in Excel"},"content":{"rendered":"\n

To create a drop-down list in Excel, select the cell, open the Data tab, click Data Validation, choose Allow: List, and either type your items in the Source box separated by commas or select a range that contains them. Click OK, and a small arrow lets users pick from the list instead of typing.<\/strong><\/p>\n\n\n\n\n\n\n\n

Drop-down lists keep data consistent: instead of one person typing \u201cNSW\u201d, another \u201cN.S.W.\u201d and a third \u201cNew South Wales\u201d, everyone picks the same option. This guide shows you how to build one step by step, how to base it on a range so it\u2019s easy to update, and how to edit or remove it.<\/p>\n\n\n\n

\"How<\/figure>\n\n\n\n

What is a drop-down list in Excel?<\/h2>\n\n\n\n

A drop-down list restricts what can be entered in a cell to a set of options you define. It\u2019s built with Excel\u2019s Data Validation<\/strong> feature. The result is a cell with a small arrow; click it and choose from your list. It\u2019s the simplest way to keep a spreadsheet clean, prevent typos, and make data easier to filter and analyse later.<\/p>\n\n\n\n

How do you create a drop-down list in Excel?<\/h2>\n\n\n\n

The quickest method is to type the options directly:<\/p>\n\n\n\n

    \n
  1. Select the cell (or cells) where you want the drop-down.<\/li>\n\n\n\n
  2. Go to the Data<\/strong> tab on the ribbon.<\/li>\n\n\n\n
  3. In the Data Tools group, click Data Validation<\/strong>.<\/li>\n\n\n\n
  4. On the Settings<\/strong> tab, open the Allow<\/strong> box and choose List<\/strong>.<\/li>\n\n\n\n
  5. In the Source<\/strong> box, type your options separated by commas, for example NSW,VIC,QLD,WA,SA,TAS.<\/li>\n\n\n\n
  6. Make sure In-cell dropdown<\/strong> is ticked, then click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"The
    Data > Data Validation > Allow: List. Type your options in the Source box, separated by commas.<\/figcaption><\/figure>\n\n\n\n
    \"An
    The finished drop-down: click the arrow and pick an option instead of typing.<\/figcaption><\/figure>\n\n\n\n

    How do you make a drop-down list from a range of cells?<\/h2>\n\n\n\n

    Typing options works for short, fixed lists. For anything you\u2019ll update, base the list on a range instead:<\/p>\n\n\n\n

      \n
    1. Put your options in a column (ideally on a separate sheet, e.g.\u00a0a \u201cLists\u201d tab), one per cell.<\/li>\n\n\n\n
    2. Select the cell for the drop-down, then Data > Data Validation > Allow: List<\/strong>.<\/li>\n\n\n\n
    3. Click in the Source box, then select the range of options (for example =Lists!$A$2:$A$10<\/code>).<\/li>\n\n\n\n
    4. Click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
      \"The
      Point Source at a range to build the list from cells you can edit anytime.<\/figcaption><\/figure>\n\n\n\n

      Tip:<\/strong> for a list that grows automatically, format your options as an Excel Table<\/strong> (Insert > Table) and reference it. New items you add to the table then appear in the drop-down without editing the validation.<\/p>\n\n\n\n

      How do you edit or add items to a drop-down list?<\/h2>\n\n\n\n