I am trying to use list validation for an entire column of data. What I would like is to automatically fill the data validation down the entire column. I tried double (and triple, and quadruple) clicking on the fill handle, but that didn't do anything like it does with formulae. My data validation list is a named range from another sheet. I would also really like it if these could show up alphabetically in case I add another category to the list later on.