To create a validation list with multiple columns, we'll need to trick Excel ... name the range as a list Create a list of validations in E3 (Data / Validation, in Allow: select "List" in Source: type ...

When multiple data variables are accommodated ... Under the ‘Data Tools’ select ‘Data Validation’ option. When the Data Validation window opens, you’ll see several controls.

Two quick methods for removing data validation rules in Excel Your ... If you’re working with multiple ranges, you can select them all and remove all of the validation rules at once.