You can enter any item in a cell with a data validation list, if you
remove the check mark from 'Show error alert after invalid data is
entered', on the Error Alert tab in the Data Validation dialog box.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.