Data Validation is pretty useful for making sure that appropriate data is entered into a cell. If you’ve been reading this blog, you know I’m fond of DV despite its problems.
One of the things that I like best about DV is the In Cell Dropdown. That little dropdown arrow that goes away when you’re not in the cell. Sometimes I use Data Validation to have a handy list in the cell, but I don’t really want to validate the data. I want to be able to type in anything I want, but still have some commonly used items in a list.
For me, Data Validation is useful in that situation also. The key is to remove the error portion. Take this example where I have a list of three cities in the DV for cell A1. I use these three cities frequently, but I need to be able to type in less frequently used cities also.
On the Data Validation dialog, simply select the Error Alert tab and remove the checkbox so that no errors are generated.
While you’re there, check out the other “error” options.