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

Excel Guide

How to Add a Drop Down List in Excel

Adding a drop-down list in Excel can enhance data entry accuracy. This guide explains two methods to create a drop-down list: using Data Validation and the INDIRECT function.

Creating a Data Validation Drop-Down List

  1. Select Cell/Range:
  2. Choose the cell or range where you want the drop-down list.
  3. Access Data Validation:
  4. Go to the "Data" tab.
  5. In the "Data Tools" group, click "Data Validation."
  6. Choose List:
  7. In the "Allow" box, select "List."
  8. Enter Source:
  9. In the "Source" box, enter the list items separated by commas (e.g., "Red, Green, Blue").
  10. Click OK:
  11. Click "OK" to create the drop-down list.

Creating an INDIRECT Function Drop-Down List

  1. Select Cell/Range:
  2. Choose the cell or range for the drop-down list.
  3. Access Data Validation:
  4. Go to the "Data" tab.
  5. In the "Data Tools" group, click "Data Validation."
  6. Choose List:
  7. In the "Allow" box, select "List."
  8. Enter Formula:
  9. In the "Source" box, enter the formula: =INDIRECT(A1) (replace A1 with the cell containing the list).
  10. Click OK:
  11. Click "OK" to create the dynamic drop-down list.

Modifying a Drop-Down List

  1. Select Cell/Range:
  2. Choose the cell or range with the existing drop-down list.
  3. Access Data Validation:
  4. Go to the "Data" tab.
  5. In the "Data Tools" group, click "Data Validation."
  6. Modify Source:
  7. In the "Source" box, enter the new list items separated by commas.
  8. Click OK:
  9. Click "OK" to update the drop-down list.

Deleting a Drop-Down List

  1. Select Cell/Range:
  2. Choose the cell or range with the drop-down list.
  3. Access Data Validation:
  4. Go to the "Data" tab.
  5. In the "Data Tools" group, click "Data Validation."
  6. Clear Validation:
  7. Click "Clear All" and then "Clear."
  8. Click OK:
  9. Click "OK" to remove the drop-down list.

By following these steps, you can efficiently create, modify, and delete drop-down lists in Excel.