Training: Create and manage drop-down lists in Excel 2013: Manage drop-down lists – Video 4 of 404:33

To prevent changes to your drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data. And unhide them if you need to make changes. You can also lock and password protect the cells on the worksheet or even the entire worksheet.