1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Data Validation List from another Worksheet

By

8 of 8

Options for Protecting the Drop Down List
Protecting the Drop Down List in the Excel

Protecting the Drop Down List in the Excel

© Ted French

Options for Protecting the Drop Down List

Since our data is on a different worksheet from the drop down list two options available for protecting the list data are:

If security is not a concern, hiding the worksheet containing the list data is a good option since it makes it easier to update the list when needed.

If security is a concern a password can be added when protecting the worksheet to prevent changes to the list items.

©2014 About.com. All rights reserved.