SaltfishTry for free

How to Edit the Drop-Down List Source in Microsoft Excel

·2 min read
In this article

Dropdown lists in Microsoft Excel are powerful tools for data entry, but sometimes you need to modify their source data to add new options or remove outdated ones. Whether you're expanding a product list or updating employee names, knowing how to edit dropdown sources is essential for maintaining accurate spreadsheets.

This tutorial will walk you through the straightforward process of updating dropdown list sources in Excel using the Data Validation feature. You'll learn how to modify cell ranges and ensure your dropdown menus always display the most current information.

Here's how to edit the drop-down list source in MS Excel

  1. Locate and click on the cell that contains the dropdown list you want to modify.
  2. Go to the ribbon menu at the top of Excel and click on the 'Data' tab.
  3. Choose 'Data Validation' from the Data Tools group in the ribbon.
  4. Click inside the 'Source' field to modify the existing cell range or reference.
  5. Update the source by either selecting a new cell range or typing the reference manually.
  6. Click 'OK' to save your changes and update the dropdown list source.

Your turn to show how it works.

Build a walkthrough of your product with Saltfish, then share it with your customers.

Create a guide with Saltfish

Frequently Asked Questions

No, to add new items to a dropdown list, you must either expand the source range to include new cells or modify the source data itself. The dropdown will only display items that are included in the specified source range or list.