Data Validation WITHOUT Restriction

[Charlie Bravo]

I have created a data validation list so users can select from the drop down option; however I would also like for them to have the ability to type in the cell whatever they'd like (e.g. Not be forced to select a drop down entry). Is this possible, if so, how?

i am using excel 2010...thank you in advance for you help here.

Charlie Bravo

 

[shg]

On the DV Error Alert tab, clear the checkbox.

 

[Charlie Bravo]

Thank You!
Can't believe how simple that was.

 

[shg]

You're welcome.