Need to have a dropdown list or allow other entry?

V

Vera

Hi,
I'm working with Excel 2003 and I need a cell to have a dropdown list to
choose from and allow people to type something different. When I use the
data validation tool, it will only allow what's in my list. Any other method
to get a dropdown list and allow a different entry?

Thanks for all your hard work!
Vera
 
T

Tom Hutchins

Select the cell, then select Data >> Validation. Set up the List-based
validation, then go to the Error Alert tab. Uncheck the box marked 'Show
error alert after invalid data is entered' >> OK.

Hope this helps,

Hutch
 

Ask a Question

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.

Ask a Question

Top