0

I've just created Data Validation for the named range. How can I edit the validation? I tried to click Data Validation... on the range, but there is a new validation rule, but not existing for the range (selected ranges are equals). Is there possible to view all validation rules for the sheet?

  • Next time, try selecting the whole sheet. – ahorn Mar 6 at 4:25
1

Not possible, there is no Data validation preview in Google Sheets where you would see the list of all rules you created (like in Conditional formatting, Protected ranges or Named ranges).

  • So, there is not way to remove validation rule for named range without removing named range? – SemperPeritus Mar 2 at 17:49
  • 2
    data validation is bound to the cell, not to the named range. named range is just an input. to remove data validation you just need to click on the cell/range you created data validation for and remove it by right-click > data validation > remove – user0 Mar 2 at 17:58
  • I checked it one more time. I thought the name range was X:Y and I tried to select X:Y, but named range was X:Y-1. My mistake. Too bad I can't see the whole list of all validation rules. May be later I write add-one for this if it is possible. Thank you! – SemperPeritus Mar 2 at 18:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.