Other Links

This webpage is an extract of the downloadable
Tutorial on Excel

The drop-down lists in Excel

Lesson 2-2: Excel Drop-Down Lists and Data Validation

Part 5:

Deleting, modifying and extending drop-down lists in Excel.

To delete a DDList you select the cell or cells, you go to "Data/Validation" on the menu bar and you click on "Clear All" and "OK". If you have selected many cells and some of them do not contain the DDList or  contain a different DDList you will see one of the following dialog window:

Click on OK or "Yes" and go on with "Clear All" and "OK"

To modify a DDList you select the cell or cells, you go to "Data/Validation" on the menu bar and you make the necessary changes in the "Source" box.

To extend a DDList you select one cell containing the DDList you set its value to nothing (Right click and Select "Clear Contents" and then you copy/paste as usual. But remember that when you use addresses in the "Source" box (as in some examples above) and you want to copy/paste your DDlist make sure that you use the dollar signs ($) properly to make the addresses or part of them absolute. See lesson 3-4 on dollar signs that you can add with the F4 key.

In Part 1 you will discovered how easy it is to create a drop down list in Excel
In Part 2 you will discover how to use a range of cells addresses as source for Excel drop down list
In Part 3 you will discover how to assemble all your lists on a single sheet to maintain them easily and how you can refer to a list on another sheet to feed a drop down list. (in the downloadable tutorial)
In part 4 you will discover how to create cascading drop down list where the values offer in the second drop down list depends on what has been selected in the first one. (in the downloadable tutorial)
In Part 5 you will discover how to modify, extend and delete your drop down lists
In Part 6 you will discover different ways to automate your reports with drop down lists in Excel

This webpage is an extract of the

This webpage is an extract of the downloadable

Tutorial on Excel