As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Modify a Drop-Down Selection in Excel

When you have to update a drop-down list in Excel due to outdated or irrelevant information, such as changes in employee or product lists, it's straightforward to adjust. This guide demonstrates the process.

Method 1: Altering the Source of the Drop-Down List

  1. Access your Excel file containing the drop-down list.
  2. Select the cell with the drop-down list.
  3. Navigate to the "Data" tab on the ribbon.
  4. Choose "Data Validation" in the "Data Tools" section.
  5. Inside the "Data Validation" dialog box, go to the "Settings" tab.
  6. Ensure "List" is selected in the "Allow" field.
  7. Remove the current range of cells referenced in the "Source" field.
  8. Highlight the new range by selecting the first cell and holding "Shift" while clicking the last cell.
  9. Input the range by typing the equal sign (=) and clicking the first cell of the range.
  10. Click "OK" to close the "Data Validation" dialog box.
  11. Verify the updated drop-down list by clicking the cell. If the new list appears, the source has been successfully modified.

Method 2: Editing the Contents of the Drop-Down List

  1. Open the Excel file containing the drop-down list.
  2. Click on the cell with the drop-down list.
  3. Go to the "Data" tab on the ribbon.
  4. Select "Data Validation" in the "Data Tools" section.
  5. In the "Data Validation" dialog box, access the "Settings" tab.
  6. Ensure "List" is selected in the "Allow" field.
  7. Delete the current range of cells in the "Source" field.
  8. Highlight the new range by selecting the first cell and holding "Shift" while clicking the last cell.
  9. Input the range by typing the equal sign (=) and clicking the first cell of the range.
  10. Click "OK" to close the "Data Validation" dialog box.
  11. Verify the updated drop-down list by clicking the cell. If the new list appears, the alteration of the list contents is successful.