✦Template Printable Ideas Insights

How to Add to a Drop Down List in Excel

By

Adding items to a dropdown list in Excel can enhance data organization and navigation. If you're wondering how to do this, you've come to the right place. In this guide, we'll walk you through the process of creating and populating a dropdown list in Excel.

Before we dive in, ensure you're using a version of Excel that supports data validation, which is the feature that enables dropdown lists. The steps we'll provide are compatible with Excel 2010 onwards and Microsoft 365.

Creating a Dropdown List

Creating a dropdown list involves three primary steps: defining the source range, creating the list, and applying data validation to the cell.

How to Add a Drop Down List In Excel- Tutorial
How to Add a Drop Down List In Excel- Tutorial
How to Create a Drop-down List in Excel (in 60 Seconds)
How to Create a Drop-down List in Excel (in 60 Seconds)
Dynamic Drop Down List
Dynamic Drop Down List

Here's how you can create a dropdown list in Excel:

Defining the Source Range

Your dropdown list will pull data from a specific range of cells, known as the source range. To define this:

How To Insert A Drop Down List In Excel: A Step-by-Step Guide
How To Insert A Drop Down List In Excel: A Step-by-Step Guide
How to Edit a Dropdown Box in Excel - Excel tips for Beginners
How to Edit a Dropdown Box in Excel - Excel tips for Beginners
Drop Down List in Excel
Drop Down List in Excel
  1. Select the cell(s) containing the data you want to include in your dropdown list.
  2. Click and drag to highlight the cells if you want to include a range.

Creating the List

Once you've defined your source range, it's time to create the dropdown list itself:

  1. Select the cell where you want the dropdown list to appear.
  2. Click on the Data tab in the Ribbon.
  3. In the Data Tools group, click on Data Validation.
  4. Under the Settings tab, in the Allow dropdown, select List.
  5. In the Source field, click thefx icon, then select your source range. Alternatively, you can manually type the range.

Adding Items to the Dropdown List

Now that you've created your initial dropdown list, let's explore how to add items to it.

When you add or remove items from your source range, the dropdown list will automatically update to reflect these changes. Here's how you can manage your source range:

How to Create a Drop Down List in Excel
How to Create a Drop Down List in Excel
Dynamic Drop Down List
Dynamic Drop Down List
The ultimate guide to searchable drop-down list in Excel
The ultimate guide to searchable drop-down list in Excel
How to Make a Drop Down List in Excel - Tutorial
How to Make a Drop Down List in Excel - Tutorial
How to Create Drop Down Lists in Excel - Complete Guide + Video Tutorial
How to Create Drop Down Lists in Excel - Complete Guide + Video Tutorial
How to add a dropdown menu in Excel?
How to add a dropdown menu in Excel?

Adding New Items

To include new items in your dropdown list, simply add them to your source range:

  1. Highlight the cell underneath the last item in your source range.
  2. Type in the new item and press Enter.
  3. Repeat these steps for each new item you want to add.

The dropdown list will now display your new items.

Removing Items

If you need to remove an item from your dropdown list, delete it from the source range:

an excel table with the drop down list highlighted in red, green and blue text
an excel table with the drop down list highlighted in red, green and blue text
Different Drop Down Lists in Same Excel Cell - Contextures Blog
Different Drop Down Lists in Same Excel Cell - Contextures Blog
Create a Drop Down List in Excel
Create a Drop Down List in Excel
  1. Select the cell containing the item you want to remove.
  2. Press the Delete key on your keyboard.

The dropdown list will now exclude your removed item.

In addition to adding and removing items, you can also sort, search, or filter your dropdown list for improved usability. These features can help you maintain an organized and efficient dropdown list.

In Excel, creating and managing dropdown lists can significantly enhance your data handling capabilities. By mastering these techniques, you'll be well-equipped to streamline your workflow and save time. Happy Exceling!