Cell validating e cancel
And, you can also use the keyboard shortcut “ALT D E” (Learn more Keyboard Shortcuts) to access the “Text to Column” wizard.
Select the range from A9 to A17 and then press “ALT D E”.
Download Excel data validation examples Now, instead of typing your list values in the data validation Source box, you add the name that you just defined, preceded by an Equal (=) sign.
The best thing about using a table is that as you add or remove items from your list, your data validation list will update automatically.
One of the most common data validation uses is to create a drop-down list.