Cell validating e cancel

cell validating e cancel-20cell validating e cancel-43

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.