Editing the List Items
To keep the drop down list up to date with changes in your data, it may be necessary to periodically change the choices in the list.
Since we used a named range as the source for our list items rather than the actual list names, changing the cookie names in the named range located in cells A1 to A4 on sheet 2 immediately changes the names in the drop down list.
If the data is entered directly into the dialog box, making changes to the list involves going back into the dialog box and edit the source line.
In this step we will change Shortbread to Oatmeal Raisin in the drop down list by changing the data in cell A3 of the named range.
- Click on cell A3 on sheet 2 (Shortbread) to make it the active cell
- Type Oatmeal Raisin into cell A3 and press the Enter key on the keyboard
- Click on the down arrow for the drop down list in cell E1 of sheet 1 to open the list
- Item 3 in the list should now read Oatmeal Raisin instead of Shortbread