I use excel data validation to reference a list of enums from multiple columns and require users to be able to add to this list. I know you can allow other values however this appears to only refer to that particular column. I know I can create a form to add to the excel sheet so that it does show to all columns however I would prefer that it can be done without exiting their current form.