Video: Manage drop-down lists
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.
Other videos in this course
This video is part of a training course called Create and manage drop-down lists.