Changing the List Items
To keep the drop down list up to date with changes in our data, it may be necessary to periodically change the choices in the list.
Since we entered the cell references (A2:A5) for our list items into the dialog box rather than the actual list names, changing the cookie names in cells A2 to A5 immediately changes the names in the drop down list.
If the data is entered directly into the dialog box to make changes to the list you need to go back into the dialog box and edit the data source.
In this step we will remove Oatmeal Raisin from the drop down list and add Shortbread.
For help with these instructions, see the image above.
- Click on cell A4 (Oatmeal Raisin) to make it the active cell
- Type Shortbread into cell A4 and press the Enter key on the keyboard
- Click on the down arrow for the drop down list in cell C1 to open the list
- Item 3 in the list should now read Shortbread instead of Oatmeal Raisin