Forum Discussion

Ericmt70's avatar
Ericmt70
Copper Contributor
Jun 18, 2022

data validation rules

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

 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

    I could like like this:

     

Resources