data validation rules

Copper Contributor

If I am not the creater of the excel speadsheet my group is using can I still change data in a drop down box, or remove the restrictions all together

Ericmt70_0-1655548087197.png

 

1 Reply

@Ericmt70 If the workbooks isn't protected in some way you should be able to remove the Data Validation rule. You'll find it on the Data ribbon under Data Tools.

Riny_van_Eekelen_1-1655550640916.png

I could like like this:

Riny_van_Eekelen_0-1655550545367.png