Validation in Excel

5 pts.
Tags:
Excel 2003
free type
Microsoft Excel
Validation
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I assume you are using Data Validation to create a list of valid entries for a cell. If so, you don’t need to use the dropdown validation. As long as you type an entry from the data validation list, it will allow you to do so.

HTH,
JP

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Euhodos
    Is the question - Can I have a list validation rule but still allow free text entries, say as an exception or in lieu of an "Other" list item? If so, simply do not turn on the Error Alert (3rd tab of Data Validation). That way the user can still benefit from the drop-down list, but have flexibility to handle exception. I don't believe this is a good database management technique, but I've used it myself many times.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following